[Libreoffice-commits] help.git: source/text
Johnny_M (via logerrit)
logerrit at kemper.freedesktop.org
Sat May 15 13:47:24 UTC 2021
source/text/scalc/01/04060106.xhp | 2 +-
source/text/scalc/01/04060109.xhp | 8 ++++----
source/text/scalc/01/04060110.xhp | 2 +-
source/text/scalc/01/04060181.xhp | 2 +-
source/text/scalc/01/func_averageif.xhp | 2 +-
source/text/scalc/01/func_averageifs.xhp | 2 +-
source/text/scalc/01/func_countifs.xhp | 2 +-
source/text/scalc/01/func_maxifs.xhp | 2 +-
source/text/scalc/01/func_minifs.xhp | 2 +-
source/text/scalc/01/func_sumifs.xhp | 2 +-
source/text/shared/00/00000001.xhp | 2 +-
11 files changed, 14 insertions(+), 14 deletions(-)
New commits:
commit 13a43eef6b8452f3f13e3d3b5f0266cf7ca141e7
Author: Johnny_M <klasse at partyheld.de>
AuthorDate: Sat May 15 13:54:11 2021 +0200
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sat May 15 15:47:03 2021 +0200
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 at libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index ae4de417c..5fd12041e 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 c8aedc337..43333f2de 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 cd8dca90f..59ded0137 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 4ce586cb6..21bf538df 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 db00a5611..5d41712cc 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 ead6f7280..e94dc7bea 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 860b90dc7..d2af44ba1 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 934f89e5e..55cdbe15e 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 096e404fb..57f92186b 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 db5e3c540..924fa85b6 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 7aee1070d..97e43cc64 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>
More information about the Libreoffice-commits
mailing list