tdf#132643 Translate German section IDs

Change-Id: Iab660ef9810902be11dd51c830e1a6f537352427
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115649
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

11 files changed, 14 insertions, 14 deletions

diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index ae4de417cb..5fd12041ef 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1050,7 +1050,7 @@
 
 <h2 id="hd_id3151957"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></h2>
 <paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value.</paragraph>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criterion [; SumRange])</paragraph>
 <paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criterion is to be applied.</paragraph>
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index c8aedc337b..43333f2de6 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -274,7 +274,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SVERWEIS" id="bm_id3152809" localize="false"/>
 <h2 id="hd_id3153152">VLOOKUP</h2>
 <paragraph xml-lang="en-US" id="par_id3149984" role="paragraph"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order.</paragraph>
-         <embed href="text/shared/00/00000001.xhp#regulaer"/>
+         <embed href="text/shared/00/00000001.xhp#regex"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3150156" role="code">=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3149289" role="paragraph">
@@ -342,7 +342,7 @@
             <emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154265" role="paragraph">If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options).</paragraph>
          <paragraph xml-lang="en-US" id="par_id3147528" role="paragraph">If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. This applies even when the search array is not sorted. For Type = -1, the first value that is larger or equal is returned.</paragraph>
-         <embed href="text/shared/00/00000001.xhp#regulaer"/>
+         <embed href="text/shared/00/00000001.xhp#regex"/>
          <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
          <paragraph xml-lang="en-US" id="par_id3155343" role="paragraph">
             <item type="input">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned.</paragraph>
@@ -393,7 +393,7 @@
 <h2 id="hd_id3159273">LOOKUP</h2>
          <paragraph xml-lang="en-US" id="par_id3153389" role="paragraph"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp#Section17" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.</paragraph>
          <note id="par_id4484084">If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion.</note>
-         <embed href="text/shared/00/00000001.xhp#regulaer"/>
+         <embed href="text/shared/00/00000001.xhp#regex"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3154104" role="code">LOOKUP(Lookup; SearchVector [; ResultVector])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3150646" role="paragraph">
@@ -455,7 +455,7 @@
 <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WVERWEIS" id="bm_id3149481" localize="false"/>
 <h2 id="hd_id3151001">HLOOKUP</h2>
          <paragraph xml-lang="en-US" id="par_id3148688" role="paragraph"><ahelp hid="HID_FUNC_WVERWEIS">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column.</paragraph>
-         <embed href="text/shared/00/00000001.xhp#regulaer"/>
+         <embed href="text/shared/00/00000001.xhp#regex"/>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
          <paragraph xml-lang="en-US" id="par_id3146070" role="code">HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph>
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index cd8dca90f5..59ded0137f 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -615,7 +615,7 @@
 
 <h2 id="hd_id3151005">SEARCH</h2>
 <paragraph id="par_id3148692" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUCHEN">Returns the position of a text segment within a character string.</ahelp> You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. If the text is not found, returns error 519 (#VALUE).</paragraph>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 <paragraph id="par_id3154671" role="code" xml-lang="en-US">SEARCH("FindText"; "Text" [; Position])</paragraph>
 <paragraph id="par_id3146080" role="paragraph" xml-lang="en-US"> <emph>FindText</emph> is the text to be searched for.</paragraph>
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 4ce586cb68..21bf538dfa 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -126,7 +126,7 @@
 <paragraph id="par_id3164967" role="code" xml-lang="en-US">COUNTIF(Range; Criterion)</paragraph>
 <paragraph id="par_id3164980" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
 <paragraph id="par_id3166505" role="paragraph" xml-lang="en-US">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. Cell B1 contains the number <item type="input">2006</item>. In cell B2, you enter a formula:</paragraph>
 <paragraph id="par_id3581652" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1.</paragraph>
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp
index db00a5611a..5d41712ccb 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -31,7 +31,7 @@
 <paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph>
 <paragraph id="par_id15226321619829" role="paragraph" xml-lang="en-US"><emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition.</paragraph>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <paragraph id="par_id174711913219765" role="paragraph" xml-lang="en-US"><emph>Average_Range</emph> – optional. It is a range of values for calculating the mean.</paragraph>
 <note id="par_id45123108916423">If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If  <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation.</note>
 <embed href="text/scalc/01/ODFF.xhp#odff"/>
diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp
index ead6f7280e..e94dc7bea1 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -32,7 +32,7 @@
 <paragraph id="par_id165832700711773" role="paragraph" xml-lang="en-US"><emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean.</paragraph>
 
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp
index 860b90dc73..d2af44ba1f 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -32,7 +32,7 @@
 
 <paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <paragraph role="paragraph" id="par_id14734320631377"><emph>Range, Range2, ...</emph> and <emph>Criterion, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp
index 934f89e5e8..55cdbe15e5 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -33,7 +33,7 @@
 <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum.</paragraph>
 
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp
index 096e404fb2..57f92186b5 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -33,7 +33,7 @@
 <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph>
 
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp
index db5e3c5401..924fa85b63 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -33,7 +33,7 @@
 <paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum.</paragraph>
 
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<embed href="text/shared/00/00000001.xhp#regex"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
 <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
diff --git a/source/text/shared/00/00000001.xhp b/source/text/shared/00/00000001.xhp
index 7aee1070dc..97e43cc645 100644
--- a/source/text/shared/00/00000001.xhp
+++ b/source/text/shared/00/00000001.xhp
@@ -266,7 +266,7 @@
   <paragraph xml-lang="en-US" id="par_id3155314" role="paragraph"><ahelp hid=".">Click the <emph>Options</emph> label to expand the dialog to show further options. Click again to restore the dialog.</ahelp></paragraph>
 </section>
 <paragraph xml-lang="en-US" id="par_id3161659" role="paragraph"><variable id="siehe">See also the following functions:</variable></paragraph>
-<section id="regulaer">
+<section id="regex">
     <paragraph xml-lang="en-US" id="par_id3147418" role="paragraph">The search supports wildcards or <link href="text/shared/01/02100001.xhp" name="regular expressions">regular expressions</link>. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in <link href="text/shared/optionen/01060500.xhp"><switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>.</paragraph>
     <section id="regexnumex">
         <warning id="par_id651572973288601">When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0". </warning>