summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-05 15:59:20 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-08 19:41:06 +0100
commit6f107ecda99e339d61517de33c0d452c18dfac3e (patch)
tree4728eb7f654a925718c21e2b1d1c57199b21e865
parent19c60db20e019c3fad935f5d9a9500585c3b82ae (diff)
tdf#128503 Clarify numeric x regex conversion
+ refactoring headings Patch set 2 - reposition comment on regex vs. numberex - included in ref for regex, aka "regulaer" and available for all functions with search criteria - Rephrased regexnumex. Patch set 3 -Fix to comply w/ DTD Change-Id: I3f5a488bb05b5ea61709e574ca5d859634158bc4 Reviewed-on: https://gerrit.libreoffice.org/82094 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060101.xhp34
-rw-r--r--source/text/scalc/01/04060106.xhp163
-rw-r--r--source/text/scalc/01/04060110.xhp83
-rw-r--r--source/text/scalc/01/04060181.xhp62
-rw-r--r--source/text/scalc/01/ex_data_stat_func.xhp10
-rw-r--r--source/text/scalc/01/func_averageif.xhp23
-rw-r--r--source/text/scalc/01/func_averageifs.xhp15
-rw-r--r--source/text/scalc/01/func_countifs.xhp19
-rw-r--r--source/text/scalc/01/func_maxifs.xhp13
-rw-r--r--source/text/scalc/01/func_minifs.xhp13
-rw-r--r--source/text/scalc/01/func_sumifs.xhp17
-rw-r--r--source/text/scalc/guide/numbers_text.xhp7
-rw-r--r--source/text/shared/00/00000001.xhp69
-rw-r--r--source/text/shared/optionen/01060500.xhp58
-rw-r--r--source/text/shared/optionen/detailedcalculation.xhp13
15 files changed, 303 insertions, 296 deletions
diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp
index 39630fea8d..8e1e7505fa 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -31,10 +31,10 @@
<bookmark_value>functions; database functions</bookmark_value>
<bookmark_value>databases; functions in $[officename] Calc</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3148946" role="heading" level="1">Database Functions</paragraph>
+<h1 id="hd_id3148946">Database Functions</h1>
<paragraph xml-lang="en-US" id="par_id3145173" role="paragraph"><variable id="datenbanktext">This section deals with functions used with data organized as one row of data for one record.</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3154016" role="note">The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150329" role="heading" level="3">Example Data:</paragraph>
+ <note id="par_id3154016">The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc.</note>
+ <h3 id="hd_id3150329">Example Data:</h3>
<paragraph xml-lang="en-US" id="par_id3153713" role="paragraph">The following data will be used in some of the function description examples:</paragraph>
<paragraph xml-lang="en-US" id="par_id3155766" role="paragraph">The range A1:E10 lists the children invited to Joe's birthday party. The following information is given for each entry: column A shows the name, B the grade, then age in years, distance to school in meters and weight in kilograms.</paragraph>
<table id="tbl_id3159264">
@@ -398,7 +398,7 @@
</table>
<paragraph xml-lang="en-US" id="par_id3149282" role="paragraph">The formula in cell B16 is =DCOUNT(A1:E10;D1;A13:E14)</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150962" role="heading" level="3">Database Function Parameters:</paragraph>
+ <h3 id="hd_id3150962">Database Function Parameters:</h3>
<paragraph xml-lang="en-US" id="par_id3155837" role="paragraph">The following items are the parameter definitions for all database functions:</paragraph>
<paragraph xml-lang="en-US" id="par_id3149453" role="paragraph">
<emph>Database</emph> is the cell range defining the database.</paragraph>
@@ -407,7 +407,7 @@
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3147083" role="paragraph">
<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151188" role="paragraph">Choose <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp" name="Spreadsheet - Calculate">%PRODUCTNAME Calc - Calculate</link> to define how $[officename] Calc acts when searching for identical entries.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151188" role="paragraph">Choose <link href="text/shared/optionen/01060500.xhp" name="Spreadsheet - Calculate"><switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> to define how $[officename] Calc acts when searching for identical entries.</paragraph>
<paragraph xml-lang="en-US" id="par_id3882869" role="paragraph">See also the Wiki page about <link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation" name="wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation">Conditional Counting and Summation</link>.</paragraph>
<sort order="asc">
<section id="Section1">
@@ -415,7 +415,7 @@
<bookmark_value>counting rows;with numeric values</bookmark_value>
</bookmark><comment>mw added "counting rows;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL" id="bm_id3152926" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150882" role="heading" level="2">DCOUNT</paragraph>
+<h2 id="hd_id3150882">DCOUNT</h2>
<paragraph xml-lang="en-US" id="par_id3156133" role="paragraph"><ahelp hid="HID_FUNC_DBANZAHL">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values in the DatabaseField column.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -433,7 +433,7 @@
<bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>
</bookmark><comment>mw added "records;" and "counting rows;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL2" id="bm_id3154055" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156123" role="heading" level="2">DCOUNTA</paragraph>
+<h2 id="hd_id3156123">DCOUNTA</h2>
<paragraph xml-lang="en-US" id="par_id3156110" role="paragraph"><ahelp hid="HID_FUNC_DBANZAHL2">DCOUNTA counts the number of rows (records) in a database that match the specified search conditions, and contain numeric or alphanumeric values.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -448,7 +448,7 @@
<bookmark_value>searching;cell contents in Calc databases</bookmark_value>
</bookmark><comment>mw added "cell contents;" and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBAUSZUG" id="bm_id3149198" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147256" role="heading" level="2">DGET</paragraph>
+<h2 id="hd_id3147256">DGET</h2>
<paragraph xml-lang="en-US" id="par_id3152801" role="paragraph"><ahelp hid="HID_FUNC_DBAUSZUG">DGET returns the contents of the referenced cell in a database which matches the specified search criteria.</ahelp> In case of an error, the function returns either #VALUE! for no row found, or Err502 for more than one cell found.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -472,7 +472,7 @@
<bookmark_value>searching;maximum values in columns</bookmark_value>
</bookmark><comment>mw added "maximum..." and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMAX" id="bm_id3158401" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149766" role="heading" level="2">DMAX</paragraph>
+<h2 id="hd_id3149766">DMAX</h2>
<paragraph xml-lang="en-US" id="par_id3154903" role="paragraph"><ahelp hid="HID_FUNC_DBMAX">DMAX returns the maximum content of a cell (field) in a database (all records) that matches the specified search conditions.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -491,7 +491,7 @@
<bookmark_value>searching;minimum values in columns</bookmark_value>
</bookmark><comment>mw added "minimum..." and "searching;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMIN" id="bm_id3159152" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3159141" role="heading" level="2">DMIN</paragraph>
+<h2 id="hd_id3159141">DMIN</h2>
<paragraph xml-lang="en-US" id="par_id3154261" role="paragraph"><ahelp hid="HID_FUNC_DBMIN">DMIN returns the minimum content of a cell (field) in a database that matches the specified search criteria.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -510,7 +510,7 @@
<bookmark_value>calculating;averages in Calc databases</bookmark_value>
</bookmark><comment>mw added "averages;..." and "calculating;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMITTELWERT" id="bm_id3166435" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154274" role="heading" level="2">DAVERAGE</paragraph>
+<h2 id="hd_id3154274">DAVERAGE</h2>
<paragraph xml-lang="en-US" id="par_id3166453" role="paragraph"><ahelp hid="HID_FUNC_DBMITTELWERT">DAVERAGE returns the average of the values of all cells (fields) in all rows (database records) that match the specified search criteria.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -528,7 +528,7 @@
<bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>
</bookmark><comment>mw added "multiplying..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBPRODUKT" id="bm_id3159281" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3159269" role="heading" level="2">DPRODUCT</paragraph>
+<h2 id="hd_id3159269">DPRODUCT</h2>
<paragraph xml-lang="en-US" id="par_id3152879" role="paragraph"><ahelp hid="HID_FUNC_DBPRODUKT">DPRODUCT multiplies all cells of a data range where the cell contents match the search criteria.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -542,7 +542,7 @@
<bookmark_value>standard deviations in databases;based on a sample</bookmark_value>
</bookmark><comment>mw added "standard deviations...;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABW" id="bm_id3145370" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148462" role="heading" level="2">DSTDEV</paragraph>
+<h2 id="hd_id3148462">DSTDEV</h2>
<paragraph xml-lang="en-US" id="par_id3154605" role="paragraph"><ahelp hid="HID_FUNC_DBSTDABW">DSTDEV calculates the standard deviation of a population based on a sample, using the numbers in a database column that match the given conditions.</ahelp> The records are treated as a sample of data. That means that the children in the example represent a cross section of all children. Note that a representative result can not be obtained from a sample of less than one thousand.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -560,7 +560,7 @@
<bookmark_value>standard deviations in databases;based on populations</bookmark_value>
</bookmark><comment>mw added "standard deviations...;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABWN" id="bm_id3149523" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150429" role="heading" level="2">DSTDEVP</paragraph>
+<h2 id="hd_id3150429">DSTDEVP</h2>
<paragraph xml-lang="en-US" id="par_id3145598" role="paragraph"><ahelp hid="HID_FUNC_DBSTDABWN">DSTDEVP calculates the standard deviation of a population based on all cells of a data range which match the search criteria.</ahelp> The records from the example are treated as the whole population.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -579,7 +579,7 @@
<bookmark_value>sums;cells in Calc databases</bookmark_value>
</bookmark><comment>mw added "calculating;" and "sums;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSUMME" id="bm_id3148687" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154794" role="heading" level="2">DSUM</paragraph>
+<h2 id="hd_id3154794">DSUM</h2>
<paragraph xml-lang="en-US" id="par_id3149591" role="paragraph"><ahelp hid="HID_FUNC_DBSUMME">DSUM returns the total of all cells in a database field in all rows (records) that match the specified search criteria.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -597,7 +597,7 @@
<bookmark_value>variances;based on samples</bookmark_value>
</bookmark><comment>mw added "variances;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZ" id="bm_id3159391" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155614" role="heading" level="2">DVAR</paragraph>
+<h2 id="hd_id3155614">DVAR</h2>
<paragraph xml-lang="en-US" id="par_id3154418" role="paragraph"><ahelp hid="HID_FUNC_DBVARIANZ">DVAR returns the variance of all cells of a database field in all records that match the specified search criteria.</ahelp> The records from the example are treated as a sample of data. A representative result cannot be obtained from a sample population of less than one thousand.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -615,7 +615,7 @@
<bookmark_value>variances;based on populations</bookmark_value>
</bookmark><comment>mw added "variances;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZEN" id="bm_id3153891" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153880" role="heading" level="2">DVARP</paragraph>
+<h2 id="hd_id3153880">DVARP</h2>
<paragraph xml-lang="en-US" id="par_id3155119" role="paragraph"><ahelp hid="HID_FUNC_DBVARIANZEN">DVARP calculates the variance of all cell values in a database field in all records that match the specified search criteria.</ahelp> The records are from the example are treated as an entire population.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 7e42bdcb5b..5247d7b8a0 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -35,7 +35,7 @@
</bookmark>
-<paragraph id="hd_id3147124" role="heading" level="1" xml-lang="en-US">Mathematical Functions</paragraph>
+<h1 id="hd_id3147124">Mathematical Functions</h1>
<paragraph id="par_id3154943" role="paragraph" xml-lang="en-US"><variable id="mathematiktext">This category contains the <emph>Mathematical</emph> functions for Calc.</variable> To open the <emph>Function Wizard</emph>, choose <link href="text/scalc/01/04060000.xhp" name="Insert - Function"><emph>Insert - Function</emph></link>.</paragraph>
<sort>
@@ -48,7 +48,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/>
-<paragraph id="hd_id3146944" role="heading" level="2" xml-lang="en-US">ABS</paragraph>
+<h2 id="hd_id3146944">ABS</h2>
<paragraph id="par_id3154546" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABS">Returns the absolute value of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -68,7 +68,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/>
-<paragraph id="hd_id3153114" role="heading" level="2" xml-lang="en-US">ACOS</paragraph>
+<h2 id="hd_id3153114">ACOS</h2>
<paragraph id="par_id3145163" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -89,7 +89,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOSHYP" id="bm_id3148386" localize="false"/>
-<paragraph id="hd_id3145355" role="heading" level="2" xml-lang="en-US">ACOSH</paragraph>
+<h2 id="hd_id3145355">ACOSH</h2>
<paragraph id="par_id3157993" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOSHYP">Returns the inverse hyperbolic cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -110,7 +110,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOT" id="bm_id3154634" localize="false"/>
-<paragraph id="hd_id3149027" role="heading" level="2" xml-lang="en-US">ACOT</paragraph>
+<h2 id="hd_id3149027">ACOT</h2>
<paragraph id="par_id3155818" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOT">Returns the inverse cotangent (the arccotangent) of the given number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -131,7 +131,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOTHYP" id="bm_id3149777" localize="false"/>
-<paragraph id="hd_id3148426" role="heading" level="2" xml-lang="en-US">ACOTH</paragraph>
+<h2 id="hd_id3148426">ACOTH</h2>
<paragraph id="par_id3147478" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOTHYP">Returns the inverse hyperbolic cotangent of the given number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -146,7 +146,7 @@
<section id="aggregate">
-<paragraph id="hd_id3145084" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_head"/></paragraph>
+<h2 id="hd_id7145084" localize="false"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_head"/></h2>
<paragraph id="par_id323373151810412" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_des"/></paragraph>
</section>
@@ -157,7 +157,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
-<paragraph id="hd_id3145084" role="heading" level="2" xml-lang="en-US">ASIN</paragraph>
+<h2 id="hd_id3145084">ASIN</h2>
<paragraph id="par_id3156296" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -179,7 +179,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/>
-<paragraph id="hd_id3151266" role="heading" level="2" xml-lang="en-US">ASINH</paragraph>
+<h2 id="hd_id3151266">ASINH</h2>
<paragraph id="par_id3147077" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -199,7 +199,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/>
-<paragraph id="hd_id3155996" role="heading" level="2" xml-lang="en-US">ATAN</paragraph>
+<h2 id="hd_id3155996">ATAN</h2>
<paragraph id="par_id3149985" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -220,7 +220,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
-<paragraph id="hd_id3153983" role="heading" level="2" xml-lang="en-US">ATAN2</paragraph>
+<h2 id="hd_id3153983">ATAN2</h2>
<paragraph id="par_id3154297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN2">Returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY).</ahelp></paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -238,7 +238,7 @@
<note id="par_id5036167">%PRODUCTNAME results 0 for ATAN2(0;0).</note>
<paragraph id="par_id5036169" role="paragraph" xml-lang="en-US">The function can be used in converting cartesian coordinates to polar coordinates.</paragraph>
-<paragraph id="par_id5036170" role="paragraph" xml-lang="en-US">=DEGREES(ATAN2(-8;5)) returns &#966; = 147.9 degrees</paragraph>
+<paragraph id="par_id5036170" role="paragraph" xml-lang="en-US">=DEGREES(ATAN2(-8;5)) returns φ = 147.9 degrees</paragraph>
<paragraph role="paragraph" id="par_id5036171" xml-lang="en-US">
<image id="img_id3150758" src="media/helpimg/scalc/coordinates-to-polar-01.svg" width="2.5inch" height="1.5inch"><alt id="alt_id3150758" xml-lang="en-US">Cartesian coordinates to polar coordinates example</alt></image>
</paragraph>
@@ -252,7 +252,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARTANHYP" id="bm_id3154939" localize="false"/>
-<paragraph id="hd_id3155398" role="heading" level="2" xml-lang="en-US">ATANH</paragraph>
+<h2 id="hd_id3155398">ATANH</h2>
<paragraph id="par_id3148829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARTANHYP">Returns the inverse hyperbolic tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -272,7 +272,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/>
-<paragraph id="hd_id3153062" role="heading" level="2" xml-lang="en-US">COS</paragraph>
+<h2 id="hd_id3153062">COS</h2>
<paragraph id="par_id3148803" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COS">Returns the cosine of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -293,7 +293,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/>
-<paragraph id="hd_id3154277" role="heading" level="2" xml-lang="en-US">COSH</paragraph>
+<h2 id="hd_id3154277">COSH</h2>
<paragraph id="par_id3146946" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -312,7 +312,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/>
-<paragraph id="hd_id3152888" role="heading" level="2" xml-lang="en-US">COT</paragraph>
+<h2 id="hd_id3152888">COT</h2>
<paragraph id="par_id3153679" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COT">Returns the cotangent of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -321,7 +321,7 @@
<paragraph id="par_id3444624" role="paragraph" xml-lang="en-US">To return the cotangent of an angle in degrees, use the RADIANS function.</paragraph>
<paragraph id="par_id6814477" role="paragraph" xml-lang="en-US">The cotangent of an angle is equivalent to 1 divided by the tangent of that angle.</paragraph>
-<paragraph id="hd_id3149800" role="heading" level="3" xml-lang="en-US">Examples:</paragraph>
+<h3 id="hd_id3149800">Examples:</h3>
<paragraph id="par_id3148616" role="paragraph" xml-lang="en-US"><item type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4 radians.</paragraph>
<paragraph id="par_id3148986" role="paragraph" xml-lang="en-US"><item type="input">=COT(RADIANS(45))</item> returns 1, the cotangent of 45 degrees.</paragraph><comment>see also COS, SIN, TAN, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
@@ -334,7 +334,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/>
-<paragraph id="hd_id3154337" role="heading" level="2" xml-lang="en-US">COTH</paragraph>
+<h2 id="hd_id3154337">COTH</h2>
<paragraph id="par_id3149419" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COTHYP">Returns the hyperbolic cotangent of a given number (angle).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -353,7 +353,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANT" id="bm_id5645316" localize="false"/>
-<paragraph id="hd_id9523234" role="heading" level="2" xml-lang="en-US">CSC</paragraph>
+<h2 id="hd_id9523234">CSC</h2>
<paragraph id="par_id4896433" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -374,7 +374,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANTHYP" id="bm_id9532490" localize="false"/>
-<paragraph id="hd_id4325650" role="heading" level="2" xml-lang="en-US">CSCH</paragraph>
+<h2 id="hd_id4325650">CSCH</h2>
<paragraph id="par_id579916" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a number.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -394,7 +394,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/>
-<paragraph id="hd_id3145314" role="heading" level="2" xml-lang="en-US">DEGREES</paragraph>
+<h2 id="hd_id3145314">DEGREES</h2>
<paragraph id="par_id3149939" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -412,7 +412,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
-<paragraph id="hd_id3148698" role="heading" level="2" xml-lang="en-US">EXP</paragraph>
+<h2 id="hd_id3148698">EXP</h2>
<paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -431,7 +431,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/>
-<paragraph id="hd_id3145781" role="heading" level="2" xml-lang="en-US">FACT</paragraph>
+<h2 id="hd_id3145781">FACT</h2>
<paragraph id="par_id3151109" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -454,7 +454,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/>
-<paragraph id="hd_id3159084" role="heading" level="2" xml-lang="en-US">INT</paragraph>
+<h2 id="hd_id3159084">INT</h2>
<paragraph id="par_id3158441" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -476,7 +476,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
-<paragraph id="hd_id3150938" role="heading" level="2" xml-lang="en-US">EVEN</paragraph>
+<h2 id="hd_id3150938">EVEN</h2>
<paragraph id="par_id3149988" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the next even integer and a negative number down to the next even integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -498,7 +498,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/>
-<paragraph id="hd_id3147356" role="heading" level="2" xml-lang="en-US">GCD</paragraph>
+<h2 id="hd_id3147356">GCD</h2>
<paragraph id="par_id3152465" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph>
<paragraph id="par_id2769249" role="paragraph" xml-lang="en-US">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph>
@@ -518,7 +518,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/>
-<paragraph id="hd_id3151221" role="heading" level="2" xml-lang="en-US">GCD_EXCEL2003</paragraph>
+<h2 id="hd_id3151221">GCD_EXCEL2003</h2>
<paragraph id="par_id3153257" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_GCD">The result is the greatest common divisor of a list of numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -539,7 +539,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGV" id="bm_id3145225" localize="false"/>
-<paragraph id="hd_id3145213" role="heading" level="2" xml-lang="en-US">LCM</paragraph>
+<h2 id="hd_id3145213">LCM</h2>
<paragraph id="par_id3146814" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KGV">Returns the least common multiple of one or more integers.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -557,7 +557,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/>
-<paragraph id="hd_id3154230" role="heading" level="2" xml-lang="en-US">LCM_EXCEL2003</paragraph>
+<h2 id="hd_id3154230">LCM_EXCEL2003</h2>
<paragraph id="par_id3149036" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_LCM">The result is the lowest common multiple of a list of numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -577,7 +577,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN" id="bm_id3155077" localize="false"/><comment>should be statistical--&gt;add a link there</comment>
-<paragraph id="hd_id3155802" role="heading" level="2" xml-lang="en-US">COMBIN</paragraph>
+<h2 id="hd_id3155802">COMBIN</h2>
<paragraph id="par_id3156172" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN">Returns the number of combinations for elements without repetition.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -599,7 +599,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN2" id="bm_id3150295" localize="false"/><comment>should be statistical--&gt;add a link there</comment>
-<paragraph id="hd_id3150284" role="heading" level="2" xml-lang="en-US">COMBINA</paragraph>
+<h2 id="hd_id3150284">COMBINA</h2>
<paragraph id="par_id3157894" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN2">Returns the number of combinations of a subset of items including repetitions.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -621,15 +621,15 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KUERZEN" id="bm_id3157849" localize="false"/>
-<paragraph id="hd_id3156086" role="heading" level="2" xml-lang="en-US">TRUNC</paragraph>
+<h2 id="hd_id3156086">TRUNC</h2>
<paragraph id="par_id3157866" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number; Count)</paragraph>
<paragraph id="par_id3150796" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign.</paragraph>
<paragraph id="par_id3150816" role="paragraph" xml-lang="en-US"><item type="literal">TRUNC(Number; 0)</item> behaves as <item type="literal">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers.</paragraph>
-<paragraph id="par_id3148548" role="warning" xml-lang="en-US">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
-</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</paragraph>
+<warning id="par_id3148548">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
+</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3152569" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost.</paragraph>
@@ -644,7 +644,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LN" id="bm_id3153613" localize="false"/>
-<paragraph id="hd_id3153601" role="heading" level="2" xml-lang="en-US">LN</paragraph>
+<h2 id="hd_id3153601">LN</h2>
<paragraph id="par_id3154974" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LN">Returns the natural logarithm based on the constant e of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -664,7 +664,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG" id="bm_id3109824" localize="false"/>
-<paragraph id="hd_id3109813" role="heading" level="2" xml-lang="en-US">LOG</paragraph>
+<h2 id="hd_id3109813">LOG</h2>
<paragraph id="par_id3109841" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified base.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -685,7 +685,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG10" id="bm_id3155460" localize="false"/>
-<paragraph id="hd_id3154187" role="heading" level="2" xml-lang="en-US">LOG10</paragraph>
+<h2 id="hd_id3154187">LOG10</h2>
<paragraph id="par_id3155476" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG10">Returns the base-10 logarithm of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -704,7 +704,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/>
-<paragraph id="hd_id3152518" role="heading" level="2" xml-lang="en-US">CEILING</paragraph>
+<h2 id="hd_id3152518">CEILING</h2>
<paragraph id="par_id3153422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -712,7 +712,7 @@
<paragraph id="par_id3153467" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph>
<paragraph id="par_id3155000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
<paragraph id="par_id3155020" role="paragraph" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph>
-<paragraph id="par_id3163792" role="warning" xml-lang="en-US">If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.</paragraph>
+<warning id="par_id3163792">If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3145710" role="paragraph" xml-lang="en-US"><item type="input">=CEILING(-11;-2)</item> returns -10</paragraph>
@@ -728,7 +728,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id2952530" localize="false"/>
-<paragraph id="hd_id2952518" role="heading" level="2" xml-lang="en-US">CEILING.PRECISE</paragraph>
+<h2 id="hd_id2952518">CEILING.PRECISE</h2>
<paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -745,14 +745,14 @@
<bookmark_value>CEILING.MATH function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MATH" id="bm_id511516997249645" localize="false"/>
- <paragraph role="heading" id="hd_id91516997330445" level="2" xml-lang="en-US">CEILING.MATH</paragraph>
+ <h2 id="hd_id91516997330445">CEILING.MATH</h2>
<paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id841516997669932" xml-lang="en-US">CEILING.MATH(Number; Significance; Mode)</paragraph>
<paragraph role="paragraph" id="par_id651516997706287" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph>
<paragraph role="paragraph" id="par_id491516997725772" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
<paragraph role="paragraph" id="par_id451516997742909" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph>
- <paragraph xml-lang="en-US" id="par_id291516998575663" role="warning">This function exists for interoperability with Microsoft Excel 2013 or newer.</paragraph>
+ <warning id="par_id291516998575663">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id111516997803684" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3)</item> returns -9</paragraph>
<paragraph role="paragraph" id="par_id1001516997821483" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3;0)</item> returns -9</paragraph>
@@ -763,14 +763,14 @@
<bookmark_value>CEILING.XCL function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id221516998652517" localize="false"/>
- <paragraph role="heading" id="hd_id411516998838823" level="2" xml-lang="en-US">CEILING.XCL</paragraph>
+ <h2 id="hd_id411516998838823">CEILING.XCL</h2>
<paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number away from zero to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#5.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph>
<paragraph role="paragraph" id="par_id671516998874263" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded.</paragraph>
<paragraph role="paragraph" id="par_id151516998882622" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded.</paragraph>
- <paragraph xml-lang="en-US" id="par_id341516998889754" role="warning">This function exists for interoperability with Microsoft Excel 2007 or older versions.</paragraph>
+ <warning id="par_id341516998889754">This function exists for interoperability with Microsoft Excel 2007 or older versions.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id91516998917254" xml-lang="en-US"><item type="input">=CEILING.XCL(1;3)</item> returns 3</paragraph>
<paragraph role="paragraph" id="par_id761516998929693" xml-lang="en-US"><item type="input">=CEILING.XCL(7;4)</item> returns 8</paragraph>
@@ -784,7 +784,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_ISO" id="bm_id8952530" localize="false"/>
-<paragraph id="hd_id8952518" role="heading" level="2" xml-lang="en-US">ISO.CEILING</paragraph>
+<h2 id="hd_id8952518">ISO.CEILING</h2>
<paragraph id="par_id8953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -803,7 +803,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PI" id="bm_id3157774" localize="false"/>
-<paragraph id="hd_id3157762" role="heading" level="2" xml-lang="en-US">PI</paragraph>
+<h2 id="hd_id3157762">PI</h2>
<paragraph id="par_id3157790" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PI">Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -820,7 +820,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429" localize="false"/>
-<paragraph id="hd_id3152418" role="heading" level="2" xml-lang="en-US">MULTINOMIAL</paragraph>
+<h2 id="hd_id3152418">MULTINOMIAL</h2>
<paragraph id="par_id3152454" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MULTINOMIAL">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -838,7 +838,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/>
-<paragraph id="hd_id3155717" role="heading" level="2" xml-lang="en-US">POWER</paragraph>
+<h2 id="hd_id3155717">POWER</h2>
<paragraph id="par_id3159495" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to another number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -859,7 +859,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SERIESSUM" id="bm_id3152662" localize="false"/>
-<paragraph id="hd_id3152651" role="heading" level="2" xml-lang="en-US">SERIESSUM</paragraph>
+<h2 id="hd_id3152651">SERIESSUM</h2>
<paragraph id="par_id3152688" role="paragraph" xml-lang="en-US"><ahelp hid=".">Sums the first terms of a power series.</ahelp></paragraph>
<paragraph id="par_id3152708" role="paragraph" xml-lang="en-US">SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)</paragraph>
@@ -880,7 +880,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/>
-<paragraph id="hd_id3144386" role="heading" level="2" xml-lang="en-US">PRODUCT</paragraph>
+<h2 id="hd_id3144386">PRODUCT</h2>
<paragraph id="par_id3144414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PRODUKT">Multiplies all the numbers given as arguments and returns the product.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -901,7 +901,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUADRATESUMME" id="bm_id3160351" localize="false"/>
-<paragraph id="hd_id3160340" role="heading" level="2" xml-lang="en-US">SUMSQ</paragraph>
+<h2 id="hd_id3160340">SUMSQ</h2>
<paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_QUADRATESUMME">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -920,7 +920,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_REST" id="bm_id3158259" localize="false"/>
-<paragraph id="hd_id3158247" role="heading" level="2" xml-lang="en-US">MOD</paragraph>
+<h2 id="hd_id3158247">MOD</h2>
<paragraph id="par_id3158276" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_REST">Returns the remainder when one integer is divided by another.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -941,7 +941,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_QUOTIENT" id="bm_id3144603" localize="false"/>
-<paragraph id="hd_id3144592" role="heading" level="2" xml-lang="en-US">QUOTIENT</paragraph>
+<h2 id="hd_id3144592">QUOTIENT</h2>
<paragraph id="par_id3144627" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer part of a division operation.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -961,7 +961,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAD" id="bm_id3158008" localize="false"/>
-<paragraph id="hd_id3144702" role="heading" level="2" xml-lang="en-US">RADIANS</paragraph>
+<h2 id="hd_id3144702">RADIANS</h2>
<paragraph id="par_id3158025" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RAD">Converts degrees to radians.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -983,7 +983,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/>
-<paragraph id="hd_id3158121" role="heading" level="2" xml-lang="en-US">ROUND</paragraph>
+<h2 id="hd_id3158121">ROUND</h2>
<paragraph id="par_id3158150" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1006,7 +1006,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABRUNDEN" id="bm_id3146003" localize="false"/>
-<paragraph id="hd_id3145991" role="heading" level="2" xml-lang="en-US">ROUNDDOWN</paragraph>
+<h2 id="hd_id3145991">ROUNDDOWN</h2>
<paragraph id="par_id3146020" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1028,7 +1028,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AUFRUNDEN" id="bm_id3163280" localize="false"/>
-<paragraph id="hd_id3163268" role="heading" level="2" xml-lang="en-US">ROUNDUP</paragraph>
+<h2 id="hd_id3163268">ROUNDUP</h2>
<paragraph id="par_id3163297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1051,7 +1051,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANT" id="bm_id6577644" localize="false"/>
-<paragraph id="hd_id5187204" role="heading" level="2" xml-lang="en-US">SEC</paragraph>
+<h2 id="hd_id5187204">SEC</h2>
<paragraph id="par_id9954962" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1072,7 +1072,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANTHYP" id="bm_id6301347" localize="false"/>
-<paragraph id="hd_id8661934" role="heading" level="2" xml-lang="en-US">SECH</paragraph>
+<h2 id="hd_id8661934">SECH</h2>
<paragraph id="par_id408174" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a number.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1091,7 +1091,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SIN" id="bm_id3144889" localize="false"/>
-<paragraph id="hd_id3144877" role="heading" level="2" xml-lang="en-US">SIN</paragraph>
+<h2 id="hd_id3144877">SIN</h2>
<paragraph id="par_id3144906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SIN">Returns the sine of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1112,7 +1112,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SINHYP" id="bm_id3163409" localize="false"/>
-<paragraph id="hd_id3163397" role="heading" level="2" xml-lang="en-US">SINH</paragraph>
+<h2 id="hd_id3163397">SINH</h2>
<paragraph id="par_id3163426" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SINHYP">Returns the hyperbolic sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1132,7 +1132,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/>
-<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></paragraph>
+<h2 id="hd_id3163596"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></h2>
<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1160,16 +1160,15 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/>
-<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></paragraph>
+<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 criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criteria; SumRange)</paragraph>
<paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph>
<paragraph id="par_id3152062" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes.</paragraph>
<paragraph id="par_id3152083" role="paragraph" xml-lang="en-US"><emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.</paragraph>
-<paragraph id="par_id8347422" role="note" xml-lang="en-US">SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph>
+<note id="par_id8347422">SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</note>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3152148" role="paragraph" xml-lang="en-US">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"&lt;0")</item></paragraph>
@@ -1183,7 +1182,7 @@
<section id="sumifs">
-<paragraph id="hd_id72921259523046" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></paragraph>
+<h2 id="hd_id72921259523046"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></h2>
<paragraph id="par_id131512822630259" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_des"/></paragraph>
</section>
@@ -1194,7 +1193,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/>
-<paragraph id="hd_id3152195" role="heading" level="2" xml-lang="en-US">TAN</paragraph>
+<h2 id="hd_id3152195">TAN</h2>
<paragraph id="par_id3152224" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1215,7 +1214,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TANHYP" id="bm_id3165446" localize="false"/>
-<paragraph id="hd_id3165434" role="heading" level="2" xml-lang="en-US">TANH</paragraph>
+<h2 id="hd_id3165434">TANH</h2>
<paragraph id="par_id3165462" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TANHYP">Returns the hyperbolic tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1237,7 +1236,7 @@
<comment>mw made "sums..." a two level entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEILERGEBNIS" id="bm_id3165644" localize="false"/>
-<paragraph id="hd_id3165633" role="heading" level="2" xml-lang="en-US">SUBTOTAL</paragraph>
+<h2 id="hd_id3165633">SUBTOTAL</h2>
<paragraph id="par_id3165682" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEILERGEBNIS">Calculates subtotals.</ahelp> If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1480,7 +1479,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EUROCONVERT" id="bm_id0119200904282677" localize="false"/>
-<paragraph id="hd_id3143672" role="heading" level="2" xml-lang="en-US">EUROCONVERT<comment>insert link in financial</comment></paragraph>
+<h2 id="hd_id3143672">EUROCONVERT<comment>insert link in financial</comment></h2>
<paragraph id="par_id3143708" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to and from Euros.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1490,7 +1489,7 @@
<paragraph id="par_id0119200904301810" role="paragraph" xml-lang="en-US"><emph>Full_precision</emph> is optional. If omitted or False, the result is rounded according to the decimals of the To currency. If Full_precision is True, the result is not rounded.</paragraph>
<paragraph id="par_id0119200904301815" role="paragraph" xml-lang="en-US"><emph>Triangulation_precision</emph> is optional. If Triangulation_precision is given and &gt;=3, the intermediate result of a triangular conversion (currency1,EUR,currency2) is rounded to that precision. If Triangulation_precision is omitted, the intermediate result is not rounded. Also if To currency is "EUR", Triangulation_precision is used as if triangulation was needed and conversion from EUR to EUR was applied.</paragraph>
-<paragraph id="par_id3143819" role="heading" level="3" xml-lang="en-US"><emph>Examples</emph></paragraph>
+<h3 id="par_id3143819"><emph>Examples</emph></h3>
<paragraph id="par_id3143837" role="paragraph" xml-lang="en-US"><item type="input">=EUROCONVERT(100;"ATS";"EUR")</item> converts 100 Austrian Schillings into Euros.</paragraph>
<paragraph id="par_id3143853" role="paragraph" xml-lang="en-US"><item type="input">=EUROCONVERT(100;"EUR";"DEM")</item> converts 100 Euros into German Marks.</paragraph>
</section>
@@ -1502,7 +1501,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id0908200902093111" localize="false"/>
-<paragraph id="hd_id0908200902074836" role="heading" level="2" xml-lang="en-US">CONVERT_OOO</paragraph>
+<h2 id="hd_id0908200902074836">CONVERT_OOO</h2>
<paragraph id="par_id0908200902131122" role="paragraph" xml-lang="en-US"><ahelp hid=".">Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.</ahelp></paragraph>
<paragraph id="par_id0908200902475420" role="paragraph" xml-lang="en-US">At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies.</paragraph>
@@ -1522,7 +1521,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNGERADE" id="bm_id3157188" localize="false"/>
-<paragraph id="hd_id3157177" role="heading" level="2" xml-lang="en-US">ODD</paragraph>
+<h2 id="hd_id3157177">ODD</h2>
<paragraph id="par_id3157205" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNGERADE">Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1544,7 +1543,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MS" id="bm_id2957415" localize="false"/>
-<paragraph id="hd_id2957404" role="heading" level="2" xml-lang="en-US">FLOOR.PRECISE</paragraph>
+<h2 id="hd_id2957404">FLOOR.PRECISE</h2>
<paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1564,7 +1563,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/>
-<paragraph id="hd_id3157404" role="heading" level="2" xml-lang="en-US">FLOOR</paragraph>
+<h2 id="hd_id3157404">FLOOR</h2>
<paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1572,7 +1571,7 @@
<paragraph id="par_id3157478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph>
<paragraph id="par_id3157497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph>
<paragraph id="par_id3157517" role="paragraph" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.</paragraph>
-<paragraph id="par_id3163894" role="warning" xml-lang="en-US">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</paragraph>
+<warning id="par_id3163894">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2)</item> returns -12</paragraph>
@@ -1588,7 +1587,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORZEICHEN" id="bm_id3164098" localize="false"/>
-<paragraph id="hd_id3164086" role="heading" level="2" xml-lang="en-US">SIGN</paragraph>
+<h2 id="hd_id3164086">SIGN</h2>
<paragraph id="par_id3164115" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VORZEICHEN">Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1608,7 +1607,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MROUND" id="bm_id3164264" localize="false"/>
-<paragraph id="hd_id3164252" role="heading" level="2" xml-lang="en-US">MROUND</paragraph>
+<h2 id="hd_id3164252">MROUND</h2>
<paragraph id="par_id3164288" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MROUND">Returns a number rounded to the nearest multiple of another number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1629,7 +1628,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WURZEL" id="bm_id3164387" localize="false"/>
-<paragraph id="hd_id3164375" role="heading" level="2" xml-lang="en-US">SQRT</paragraph>
+<h2 id="hd_id3164375">SQRT</h2>
<paragraph id="par_id3164404" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WURZEL">Returns the positive square root of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1650,7 +1649,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SQRTPI" id="bm_id3164572" localize="false"/>
-<paragraph id="hd_id3164560" role="heading" level="2" xml-lang="en-US">SQRTPI</paragraph>
+<h2 id="hd_id3164560">SQRTPI</h2>
<paragraph id="par_id3164596" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_SQRTPI">Returns the square root of (PI times a number).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1670,7 +1669,7 @@
<comment>mw changed "random numbers;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_RANDBETWEEN" id="bm_id3164680" localize="false"/>
-<paragraph id="hd_id3164669" role="heading" level="2" xml-lang="en-US">RANDBETWEEN</paragraph>
+<h2 id="hd_id3164669">RANDBETWEEN</h2>
<paragraph id="par_id3164711" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1691,7 +1690,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZUFALLSZAHL" id="bm_id3164812" localize="false"/>
-<paragraph id="hd_id3164800" role="heading" level="2" xml-lang="en-US">RAND</paragraph>
+<h2 id="hd_id3164800">RAND</h2>
<paragraph id="par_id3164829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp><comment>The value of 0 can be returned, the value of 1 not.</comment><comment>this is really true after issue 53642 will be fixed</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 31722b8cfb..664d238859 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -34,7 +34,7 @@
</bookmark>
-<paragraph id="hd_id3145389" role="heading" level="1" xml-lang="en-US"><variable id="head_text"><link href="text/scalc/01/04060110.xhp" name="Text Functions">Text Functions</link></variable></paragraph>
+<h1 id="hd_id3145389"><variable id="head_text"><link href="text/scalc/01/04060110.xhp" name="Text Functions">Text Functions</link></variable></h1>
<paragraph id="par_id3152986" role="paragraph" xml-lang="en-US"><variable id="texttext">This section contains descriptions of the <emph>Text</emph> functions. </variable></paragraph>
<section id="howtoget">
@@ -49,7 +49,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARABISCH" id="bm_id3145359" localize="false"/>
-<paragraph id="hd_id3149384" role="heading" level="2" xml-lang="en-US">ARABIC</paragraph>
+<h2 id="hd_id3149384">ARABIC</h2>
<paragraph id="par_id3153558" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARABISCH">Calculates the value of a Roman number. The value range must be between 0 and 3999.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -68,7 +68,7 @@
<comment>i79585</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" id="bm_id3187353" localize="false"/>
-<paragraph id="hd_id7723929" role="heading" level="2" xml-lang="en-US">ASC</paragraph>
+<h2 id="hd_id7723929">ASC</h2>
<paragraph id="par_id8455153" role="paragraph" xml-lang="en-US"><ahelp hid=".">The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
<paragraph id="par_id9912411" role="paragraph" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
@@ -85,7 +85,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BAHTTEXT" id="bm_id744346" localize="false"/><comment>i66350</comment>
-<paragraph id="hd_id6695455" role="heading" level="2" xml-lang="en-US">BAHTTEXT</paragraph>
+<h2 id="hd_id6695455">BAHTTEXT</h2>
<paragraph id="par_id354014" role="paragraph" xml-lang="en-US">Converts a number to Thai text, including the Thai currency names.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -103,7 +103,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BASIS" id="bm_id3150957" localize="false"/>
-<paragraph id="hd_id3153072" role="heading" level="2" xml-lang="en-US">BASE</paragraph>
+<h2 id="hd_id3153072">BASE</h2>
<paragraph id="par_id3153289" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BASIS">Converts a positive integer to a specified base into a text from the <link href="text/shared/00/00000005.xhp#zahlensystem" name="numbering system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -137,7 +137,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEICHEN" id="bm_id3159128" localize="false"/>
-<paragraph id="hd_id3149321" role="heading" level="2" xml-lang="en-US">CHAR</paragraph>
+<h2 id="hd_id3149321">CHAR</h2>
<paragraph id="par_id3149150" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEICHEN">Converts a number into a character according to the current code table.</ahelp> The number can be a two-digit or three-digit integer number.</paragraph>
<embed href="text/scalc/00/00000004.xhp#codes"/>
@@ -157,7 +157,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SAEUBERN" id="bm_id3148729" localize="false"/>
-<paragraph id="hd_id3149009" role="heading" level="2" xml-lang="en-US">CLEAN</paragraph>
+<h2 id="hd_id3149009">CLEAN</h2>
<paragraph id="par_id3150482" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SAEUBERN">All non-printing characters are removed from the string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -172,7 +172,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CODE" id="bm_id3159084" localize="false"/>
-<paragraph id="hd_id3155498" role="heading" level="2" xml-lang="en-US">CODE</paragraph>
+<h2 id="hd_id3155498">CODE</h2>
<paragraph id="par_id3152770" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CODE">Returns a numeric code for the first character in a text string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -182,7 +182,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3159209" role="paragraph" xml-lang="en-US"> <item type="input">=CODE("Hieronymus")</item> returns 72, <item type="input">=CODE("hieroglyphic")</item> returns 104.</paragraph>
-<paragraph id="par_id3150280" role="note" xml-lang="en-US">The code used here does not refer to ASCII, but to the code table currently loaded.</paragraph>
+<note id="par_id3150280">The code used here does not refer to ASCII, but to the code table currently loaded.</note>
</section>
<section id="concatenate">
@@ -192,7 +192,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERKETTEN" id="bm_id3153084" localize="false"/>
-<paragraph id="hd_id3149688" role="heading" level="2" xml-lang="en-US">CONCATENATE</paragraph>
+<h2 id="hd_id3149688">CONCATENATE</h2>
<paragraph id="par_id3154524" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VERKETTEN">Combines several text strings into one string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -210,7 +210,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEZIMAL" id="bm_id3150338" localize="false"/>
-<paragraph id="hd_id3145166" role="heading" level="2" xml-lang="en-US">DECIMAL</paragraph>
+<h2 id="hd_id3145166">DECIMAL</h2>
<paragraph id="par_id3156361" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEZIMAL">Converts text with characters from a <link href="text/shared/00/00000005.xhp#zahlensystem" name="number system">number system</link> to a positive integer in the base radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive.</paragraph>
<paragraph id="par_id3157994" role="paragraph" xml-lang="en-US">If the radix is 16, a leading x or X or 0x or 0X, and an appended h or H, is disregarded. If the radix is 2, an appended b or B is disregarded. Other characters that do not belong to the number system generate an error.</paragraph>
@@ -232,7 +232,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DM" id="bm_id3149532" localize="false"/>
-<paragraph id="hd_id3148402" role="heading" level="2" xml-lang="en-US">DOLLAR</paragraph>
+<h2 id="hd_id3148402">DOLLAR</h2>
<paragraph id="par_id3153049" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DM">Converts a number to an amount in the currency format, rounded to a specified decimal place.</ahelp> In the <item type="literal">Value</item> field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the <item type="literal">Decimals</item> field. If no value is specified, all numbers in currency format will be displayed with two decimal places. </paragraph>
<paragraph id="par_id3151280" role="paragraph" xml-lang="en-US">You set the currency format in your system settings.</paragraph>
@@ -253,7 +253,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_IDENTISCH" id="bm_id3155081" localize="false"/>
-<paragraph id="hd_id3150685" role="heading" level="2" xml-lang="en-US">EXACT</paragraph>
+<h2 id="hd_id3150685">EXACT</h2>
<paragraph id="par_id3158413" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_IDENTISCH">Compares two text strings and returns TRUE if they are identical.</ahelp> This function is case-sensitive.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -272,7 +272,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FINDEN" id="bm_id3147482" localize="false"/>
-<paragraph id="hd_id3152589" role="heading" level="2" xml-lang="en-US">FIND</paragraph>
+<h2 id="hd_id3152589">FIND</h2>
<paragraph id="par_id3146149" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FINDEN">Returns the position of a string of text within another string.</ahelp>You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -292,7 +292,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FEST" id="bm_id3149450" localize="false"/>
-<paragraph id="hd_id3149268" role="heading" level="2" xml-lang="en-US">FIXED</paragraph>
+<h2 id="hd_id3149268">FIXED</h2>
<paragraph id="par_id3155833" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -313,7 +313,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" id="bm_id3818475" localize="false"/>
-<paragraph id="hd_id3666188" role="heading" level="2" xml-lang="en-US">JIS</paragraph>
+<h2 id="hd_id3666188">JIS</h2>
<paragraph id="par_id964384" role="paragraph" xml-lang="en-US"><ahelp hid=".">The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
<paragraph id="par_id1551561" role="paragraph" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions" name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table.</paragraph>
@@ -330,7 +330,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LINKS" id="bm_id3154645" localize="false"/>
-<paragraph id="hd_id3147083" role="heading" level="2" xml-lang="en-US">LEFT</paragraph>
+<h2 id="hd_id3147083">LEFT</h2>
<paragraph id="par_id3153622" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LINKS">Returns the first character or characters of a text.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -349,7 +349,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
-<paragraph id="hd_id2947083" role="heading" level="2" xml-lang="en-US">LEFTB</paragraph>
+<h2 id="hd_id2947083">LEFTB</h2>
<paragraph id="par_id2953622" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS text.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -372,7 +372,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LAENGE" id="bm_id3154050" localize="false"/>
-<paragraph id="hd_id3156110" role="heading" level="2" xml-lang="en-US">LEN</paragraph>
+<h2 id="hd_id3156110">LEN</h2>
<paragraph id="par_id3150147" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LAENGE">Returns the length of a string including spaces.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -391,7 +391,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
-<paragraph id="hd_id2956110" role="heading" level="2" xml-lang="en-US">LENB</paragraph>
+<h2 id="hd_id2956110">LENB</h2>
<paragraph id="par_id2950147" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LENB">For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -413,7 +413,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KLEIN" id="bm_id3151173" localize="false"/>
-<paragraph id="hd_id3153983" role="heading" level="2" xml-lang="en-US">LOWER</paragraph>
+<h2 id="hd_id3153983">LOWER</h2>
<paragraph id="par_id3152791" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KLEIN">Converts all uppercase letters in a text string to lowercase.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -431,7 +431,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEIL" id="bm_id3155392" localize="false"/>
-<paragraph id="hd_id3154589" role="heading" level="2" xml-lang="en-US">MID</paragraph>
+<h2 id="hd_id3154589">MID</h2>
<paragraph id="par_id3154938" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEIL">Returns a text string of a text. The parameters specify the starting position and the number of characters.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -451,7 +451,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
-<paragraph id="hd_id2954589" role="heading" level="2" xml-lang="en-US">MIDB</paragraph>
+<h2 id="hd_id2954589">MIDB</h2>
<paragraph id="par_id2954938" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -481,7 +481,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GROSS2" id="bm_id3154897" localize="false"/>
-<paragraph id="hd_id3159143" role="heading" level="2" xml-lang="en-US">PROPER</paragraph>
+<h2 id="hd_id3159143">PROPER</h2>
<paragraph id="par_id3149768" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -503,7 +503,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERSETZEN" id="bm_id3149990" localize="false"/>
-<paragraph id="hd_id3149171" role="heading" level="2" xml-lang="en-US">REPLACE</paragraph>
+<h2 id="hd_id3149171">REPLACE</h2>
<paragraph id="par_id3148925" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ERSETZEN">Replaces part of a text string with a different text string.</ahelp> This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the <link href="text/scalc/01/04060110.xhp" name="VALUE">VALUE</link> function.</paragraph>
<paragraph id="par_id3158426" role="paragraph" xml-lang="en-US">Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text.</paragraph>
@@ -525,7 +525,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WIEDERHOLEN" id="bm_id3155582" localize="false"/>
-<paragraph id="hd_id3149741" role="heading" level="2" xml-lang="en-US">REPT</paragraph>
+<h2 id="hd_id3149741">REPT</h2>
<paragraph id="par_id3153748" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WIEDERHOLEN">Repeats a character string by the given <emph>number</emph> of copies.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -545,7 +545,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RECHTS" id="bm_id3154602" localize="false"/>
-<paragraph id="hd_id3149805" role="heading" level="2" xml-lang="en-US">RIGHT</paragraph>
+<h2 id="hd_id3149805">RIGHT</h2>
<paragraph id="par_id3145375" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RECHTS">Returns the last character or characters of a text.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -564,7 +564,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
-<paragraph id="hd_id2949805" role="heading" level="2" xml-lang="en-US">RIGHTB</paragraph>
+<h2 id="hd_id2949805">RIGHTB</h2>
<paragraph id="par_id2945375" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -587,7 +587,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ROEMISCH" id="bm_id3144755" localize="false"/>
-<paragraph id="hd_id3153534" role="heading" level="2" xml-lang="en-US">ROMAN</paragraph>
+<h2 id="hd_id3153534">ROMAN</h2>
<paragraph id="par_id3151256" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ROEMISCH">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -611,10 +611,9 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUCHEN" id="bm_id3149484" localize="false"/>
-<paragraph id="hd_id3151005" role="heading" level="2" xml-lang="en-US">SEARCH</paragraph>
+<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/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>
@@ -632,7 +631,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WECHSELN" id="bm_id3147090" localize="false"/>
-<paragraph id="hd_id3154830" role="heading" level="2" xml-lang="en-US">SUBSTITUTE</paragraph>
+<h2 id="hd_id3154830">SUBSTITUTE</h2>
<paragraph id="par_id3153698" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WECHSELN">Substitutes new text for old text in a string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -654,7 +653,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_T" id="bm_id3156051" localize="false"/>
-<paragraph id="hd_id3148977" role="heading" level="2" xml-lang="en-US">T</paragraph>
+<h2 id="hd_id3148977">T</h2>
<paragraph id="par_id3154359" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_T">This function returns the target text, or a blank text string if the target is not text.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -673,7 +672,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEXT" id="bm_id3156426" localize="false"/>
-<paragraph id="hd_id3147132" role="heading" level="2" xml-lang="en-US">TEXT</paragraph>
+<h2 id="hd_id3147132">TEXT</h2>
<paragraph id="par_id3147213" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEXT">Converts a number into text according to a given format.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -685,7 +684,7 @@
<paragraph id="par_id9044770" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT(12.34567;"###.##")</item> returns the text 12.35</paragraph>
<paragraph id="par_id3674123" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph>
-<paragraph id="par_id3145364" role="tip" xml-lang="en-US">See also <link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link>: custom format codes defined by the user.</paragraph>
+<tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link>: custom format codes defined by the user.</tip>
</section>
<section id="trim">
@@ -695,7 +694,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GLAETTEN" id="bm_id3150584" localize="false"/>
-<paragraph id="hd_id3151039" role="heading" level="2" xml-lang="en-US">TRIM</paragraph>
+<h2 id="hd_id3151039">TRIM</h2>
<paragraph id="par_id3157888" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GLAETTEN">Removes spaces from a string, leaving only a single space character between words.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -713,7 +712,7 @@
</bookmark>
-<paragraph id="hd_id0907200904022525" role="heading" level="2" xml-lang="en-US">UNICHAR</paragraph>
+<h2 id="hd_id0907200904022525">UNICHAR</h2>
<paragraph id="par_id0907200904022538" role="paragraph" xml-lang="en-US"><ahelp hid=".">Converts a code number into a Unicode character or letter.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -721,7 +720,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id090720090412378" role="paragraph" xml-lang="en-US">=UNICHAR(169) returns the Copyright character <emph>©</emph>.</paragraph>
-<paragraph id="par_id050220170755399756" role="tip" xml-lang="en-US">See also the UNICODE() function.</paragraph>
+<tip id="par_id050220170755399756">See also the UNICODE() function.</tip>
</section>
<section id="unicode">
@@ -731,7 +730,7 @@
</bookmark>
-<paragraph id="hd_id0907200904022588" role="heading" level="2" xml-lang="en-US">UNICODE</paragraph>
+<h2 id="hd_id0907200904022588">UNICODE</h2>
<paragraph id="par_id0907200904022594" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the numeric code for the first Unicode character in a text string.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -739,7 +738,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id0907200904123919" role="paragraph" xml-lang="en-US">=UNICODE("©") returns the Unicode number 169 for the Copyright character.</paragraph>
-<paragraph id="par_id050220170755393174" role="tip" xml-lang="en-US">See also the UNICHAR() function.</paragraph>
+<tip id="par_id050220170755393174">See also the UNICHAR() function.</tip>
</section>
<section id="upper">
@@ -749,7 +748,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GROSS" id="bm_id3145189" localize="false"/>
-<paragraph id="hd_id3145178" role="heading" level="2" xml-lang="en-US">UPPER</paragraph>
+<h2 id="hd_id3145178">UPPER</h2>
<paragraph id="par_id3162905" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GROSS">Converts the string specified in the <emph>text</emph> field to uppercase.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -767,7 +766,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WERT" id="bm_id3150814" localize="false"/>
-<paragraph id="hd_id3150802" role="heading" level="2" xml-lang="en-US">VALUE</paragraph>
+<h2 id="hd_id3150802">VALUE</h2>
<paragraph id="par_id3152551" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WERT">Converts a text string into a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index bc016f6fc4..a2ebfd4806 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -28,7 +28,7 @@
<body>
-<paragraph id="hd_id3146320" role="heading" level="1" xml-lang="en-US"><variable id="ae"><link href="text/scalc/01/04060181.xhp">Statistical Functions Part One</link></variable></paragraph>
+<h1 id="hd_id3146320"><variable id="ae"><link href="text/scalc/01/04060181.xhp">Statistical Functions Part One</link></variable></h1>
<sort order="asc">
<section id="intercept">
@@ -40,7 +40,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ACHSENABSCHNITT" id="bm_id3153018" localize="false"/>
-<paragraph id="hd_id3145632" role="heading" level="2" xml-lang="en-US">INTERCEPT</paragraph>
+<h2 id="hd_id3145632">INTERCEPT</h2>
<paragraph id="par_id3146887" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ACHSENABSCHNITT">Calculates the point at which a line will intersect the y-values by using known x-values and y-values.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -62,7 +62,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/>
-<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US"><variable id="count_head"><link href="text/scalc/01/04060181.xhp#count">COUNT</link></variable></paragraph>
+<h2 id="hd_id3148437"><variable id="count_head"><link href="text/scalc/01/04060181.xhp#count">COUNT</link></variable></h2>
<paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -82,7 +82,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/>
-<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></paragraph>
+<h2 id="hd_id3149729"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></h2>
<paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -103,7 +103,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/>
-<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US"><variable id="countblank_head"><link href="text/scalc/01/04060181.xhp#countblank">COUNTBLANK</link></variable></paragraph>
+<h2 id="hd_id3150896"><variable id="countblank_head"><link href="text/scalc/01/04060181.xhp#countblank">COUNTBLANK</link></variable></h2>
<paragraph id="par_id3155260" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -122,15 +122,13 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/>
-<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US"><variable id="countif_head"><link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link></variable></paragraph>
+<h2 id="hd_id3164897"><variable id="countif_head"><link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link></variable></h2>
<paragraph id="par_id3164926" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph>
-<embed href="text/shared/00/00000001.xhp#regulaer"/>
-
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3164967" role="code" xml-lang="en-US">COUNTIF(Range; Criteria)</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>
-<paragraph id="par_id3165000" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. If regular expressions are enabled in calculation options you may also enter a search text in the form of a regular expression, e.g. b.* for all cells that begin with b. If wildcards are enabled in calculation options you may enter a search text with wildcards, e.g. b* for all cells that begin with b. You may also indicate a cell address that contains the search criterion. If you search for literal text, enclose the text in double quotes.</paragraph>
-
+<paragraph id="par_id3165000" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted.</paragraph>
+<embed href="text/shared/00/00000001.xhp#regulaer"/>
<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>
@@ -143,7 +141,7 @@
<section id="countifs">
-<paragraph id="hd_id224412044220134" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/></paragraph>
+<h2 id="hd_id224412044220134"><embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/></h2>
<paragraph id="par_id16399242326772" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_countifs.xhp#countifs_des"/></paragraph>
</section>
@@ -155,7 +153,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_B" id="bm_id3153044" localize="false"/>
-<paragraph id="hd_id3150267" role="heading" level="2" xml-lang="en-US">B</paragraph>
+<h2 id="hd_id3150267">B</h2>
<paragraph id="par_id3156061" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_B">Returns the probability of a sample with binomial distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -179,7 +177,7 @@
<comment>mw added regression analysis</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BESTIMMTHEITSMASS" id="bm_id3153228" localize="false"/>
-<paragraph id="hd_id3158416" role="heading" level="2" xml-lang="en-US">RSQ</paragraph>
+<h2 id="hd_id3158416">RSQ</h2>
<paragraph id="par_id3154949" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BESTIMMTHEITSMASS">Returns the square of the Pearson correlation coefficient based on the given values.</ahelp> RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -199,7 +197,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAINV" id="bm_id3146154" localize="false"/>
-<paragraph id="hd_id3145620" role="heading" level="2" xml-lang="en-US">BETAINV</paragraph>
+<h2 id="hd_id3145620">BETAINV</h2>
<paragraph id="par_id3149825" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETAINV">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -223,7 +221,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAINV_MS" id="bm_id2946154" localize="false"/>
-<paragraph id="hd_id2945620" role="heading" level="2" xml-lang="en-US">BETA.INV</paragraph>
+<h2 id="hd_id2945620">BETA.INV</h2>
<paragraph id="par_id2949825" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETAINV_MS">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -247,7 +245,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAVERT" id="bm_id3153213" localize="false"/>
-<paragraph id="hd_id3156096" role="heading" level="2" xml-lang="en-US">BETADIST</paragraph>
+<h2 id="hd_id3156096">BETADIST</h2>
<paragraph id="par_id3150880" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETAVERT">Returns the beta function.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -272,7 +270,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETADIST_MS" id="bm_id2953213" localize="false"/>
-<paragraph id="hd_id2956096" role="heading" level="2" xml-lang="en-US">BETA.DIST</paragraph>
+<h2 id="hd_id2956096">BETA.DIST</h2>
<paragraph id="par_id2950880" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETADIST_MS">Returns the beta function.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -297,7 +295,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/>
-<paragraph id="hd_id3143228" role="heading" level="2" xml-lang="en-US">BINOMDIST</paragraph>
+<h2 id="hd_id3143228">BINOMDIST</h2>
<paragraph id="par_id3146897" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BINOMVERT">Returns the individual term binomial distribution probability.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -319,7 +317,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOM_DIST_MS" id="bm_id2950146" localize="false"/>
-<paragraph id="hd_id2943228" role="heading" level="2" xml-lang="en-US">BINOM.DIST</paragraph>
+<h2 id="hd_id2943228">BINOM.DIST</h2>
<paragraph id="par_id2946897" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution probability.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -341,7 +339,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOM_INV_MS" id="bm_id2850146" localize="false"/>
-<paragraph id="hd_id2843228" role="heading" level="2" xml-lang="en-US">BINOM.INV</paragraph>
+<h2 id="hd_id2843228">BINOM.INV</h2>
<paragraph id="par_id2846897" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BINOM_INV_MS">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -361,7 +359,7 @@
</bookmark>
-<paragraph id="hd_id0119200902421451" role="heading" level="2" xml-lang="en-US">CHISQINV</paragraph>
+<h2 id="hd_id0119200902421451">CHISQINV</h2>
<paragraph id="par_id0119200902421449" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the inverse of CHISQDIST.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -376,7 +374,7 @@
</bookmark>
-<paragraph id="hd_id2919200902421451" role="heading" level="2" xml-lang="en-US">CHISQ.INV</paragraph>
+<h2 id="hd_id2919200902421451">CHISQ.INV</h2>
<paragraph id="par_id2919200902421449" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the left-tailed probability of the chi-square distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -395,7 +393,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/>
-<paragraph id="hd_id3148835" role="heading" level="2" xml-lang="en-US">CHIINV</paragraph>
+<h2 id="hd_id3148835">CHIINV</h2>
<paragraph id="par_id3149906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIINV">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -419,7 +417,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIINV_MS" id="bm_id2948823" localize="false"/>
-<paragraph id="hd_id2948835" role="heading" level="2" xml-lang="en-US">CHISQ.INV.RT</paragraph>
+<h2 id="hd_id2948835">CHISQ.INV.RT</h2>
<paragraph id="par_id2949906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIINV_MS">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -443,7 +441,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/>
-<paragraph id="hd_id3154260" role="heading" level="2" xml-lang="en-US">CHITEST</paragraph>
+<h2 id="hd_id3154260">CHITEST</h2>
<paragraph id="par_id3151052" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHITEST">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHITEST returns the chi-squared distribution of the data.</paragraph>
<paragraph id="par_id3148925" role="paragraph" xml-lang="en-US">The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph>
@@ -543,7 +541,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHITEST_MS" id="bm_id2955355" localize="false"/>
-<paragraph id="hd_id2954260" role="heading" level="2" xml-lang="en-US">CHISQ.TEST</paragraph>
+<h2 id="hd_id2954260">CHISQ.TEST</h2>
<paragraph id="par_id2951052" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHITEST_MS">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHISQ.TEST returns the chi-squared distribution of the data.</paragraph>
<paragraph id="par_id2948925" role="paragraph" xml-lang="en-US">The probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
@@ -643,7 +641,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/>
-<paragraph id="hd_id3148690" role="heading" level="2" xml-lang="en-US">CHIDIST</paragraph>
+<h2 id="hd_id3148690">CHIDIST</h2>
<paragraph id="par_id3156338" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIVERT">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph>
<paragraph id="par_id3151316" role="paragraph" xml-lang="en-US">The probability determined by CHIDIST can also be determined by CHITEST.</paragraph>
@@ -664,7 +662,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQDIST_MS" id="bm_id2947521" localize="false"/>
-<paragraph id="hd_id2848690" role="heading" level="2" xml-lang="en-US">CHISQ.DIST</paragraph>
+<h2 id="hd_id2848690">CHISQ.DIST</h2>
<paragraph id="par_id2856338" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQDIST_MS">Returns the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -685,7 +683,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIVERT_MS" id="bm_id2947522" localize="false"/>
-<paragraph id="hd_id2948690" role="heading" level="2" xml-lang="en-US">CHISQ.DIST.RT</paragraph>
+<h2 id="hd_id2948690">CHISQ.DIST.RT</h2>
<paragraph id="par_id2956338" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIVERT_MS">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph>
<paragraph id="par_id2951316" role="paragraph" xml-lang="en-US">The probability determined by CHISQ.DIST.RT can also be determined by CHITEST.</paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
@@ -707,7 +705,7 @@
</bookmark>
-<paragraph id="hd_id0119200901583452" role="heading" level="2" xml-lang="en-US">CHISQDIST</paragraph>
+<h2 id="hd_id0119200901583452">CHISQDIST</h2>
<paragraph id="par_id0119200901583471" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -725,7 +723,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXPONVERT" id="bm_id3152962" localize="false"/>
-<paragraph id="hd_id3150603" role="heading" level="2" xml-lang="en-US">EXPONDIST</paragraph>
+<h2 id="hd_id3150603">EXPONDIST</h2>
<paragraph id="par_id3149563" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXPONVERT">Returns the exponential distribution.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -746,7 +744,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP_DIST_MS" id="bm_id2952962" localize="false"/>
-<paragraph id="hd_id2950603" role="heading" level="2" xml-lang="en-US">EXPON.DIST</paragraph>
+<h2 id="hd_id2950603">EXPON.DIST</h2>
<paragraph id="par_id2949563" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP_DIST_MS">Returns the exponential distribution.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp b/source/text/scalc/01/ex_data_stat_func.xhp
index bb4f701b1e..c43dd90897 100644
--- a/source/text/scalc/01/ex_data_stat_func.xhp
+++ b/source/text/scalc/01/ex_data_stat_func.xhp
@@ -19,7 +19,7 @@
<body>
<section id="ex_func_average">
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="hd_id2609201512474295" role="heading" level="4" xml-lang="en-US">Consider the following table</paragraph>
+<paragraph role="paragraph" id="hd_id2609201512474295">Consider the following table</paragraph>
<table id="table_averageif_example">
<tablerow>
<tablecell>
@@ -119,14 +119,14 @@
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.</paragraph>
+<warning id="par_id1191767622119">In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.</warning>
</section>
<paragraph role="paragraph" id="par_id961527953004850" xml-lang="en-US"><variable id="args">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable></paragraph>
<section id="note01">
- <paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation.</paragraph>
+ <note id="par_id94162948227556">The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation.</note>
</section>
<section id="warning01">
- <paragraph id="par_id14734320631377" role="warning" xml-lang="en-US"><emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph>
+ <paragraph id="par_id14734320631377" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph>
</section>
<section id="par00">
<paragraph id="par_id23526994221948" role="paragraph" xml-lang="en-US"><emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href="text/shared/optionen/01060500.xhp#wildcards" name="Wild cards">if enabled in calculation options</link>).</paragraph>
@@ -135,7 +135,7 @@
</section>
<section id="par01">
<paragraph xml-lang="en-US" id="par_id191527781733238" role="paragraph">The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them.</paragraph>
- <paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).</paragraph>
+ <paragraph id="par_id175721789527973" role="paragraph" xml-lang="en-US">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).</paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp
index 15ad55ef07..b9e78bcfda 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -23,7 +23,7 @@
<bookmark_value>AVERAGEIF function</bookmark_value>
<bookmark_value>arithmetic mean;satisfying condition</bookmark_value>
</bookmark>
-<paragraph id="hd_id16852304621982" role="heading" level="2" xml-lang="en-US"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</paragraph>
+<h2 id="hd_id16852304621982"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</h2>
<paragraph id="par_id7281266615152" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#4.0"/>
@@ -31,35 +31,36 @@
<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>
<paragraph id="par_id24499731228013" role="paragraph" xml-lang="en-US"><emph>Criterion</emph> – required argument. A condition in the form of expression or a cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options).</paragraph>
+<embed href="text/shared/00/00000001.xhp#regulaer"/>
<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>
-<paragraph id="par_id45123108916423" role="note" xml-lang="en-US">Note that 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 the <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 mean calculation.<br/>
-The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and an operation of a string concatenation (&amp;).</paragraph><embed href="text/scalc/01/ODFF.xhp#odff"/>
-<paragraph id="par_id278275053653" role="warning" xml-lang="en-US">If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>
-If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error. </paragraph>
+<note id="par_id45123108916423">Note that 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 the <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 mean calculation.<br/>
+The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and an operation of a string concatenation (&amp;).</note><embed href="text/scalc/01/ODFF.xhp#odff"/>
+<warning id="par_id278275053653">If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>
+If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error. </warning>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="par_id38832436828097" role="warning" xml-lang="en-US">In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text.</paragraph>
-<paragraph id="hd_id229513120314273" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
+<warning id="par_id38832436828097">In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text.</warning>
+<h4 id="hd_id229513120314273">Simple usage</h4>
<paragraph id="par_id2509201519225446" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&lt;35")</item></paragraph>
<paragraph id="par_id11322891219251" role="paragraph" xml-lang="en-US">Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation.</paragraph>
<paragraph id="par_id250920151922590" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id3813266131474" role="paragraph" xml-lang="en-US">Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation.</paragraph>
<paragraph id="par_id2509201519230832" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&gt;"&amp;SMALL(B2:B6;1))</item></paragraph>
<paragraph id="par_id243522732832394" role="paragraph" xml-lang="en-US">Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation.</paragraph>
-<paragraph id="hd_id2101254257133" role="heading" level="4" xml-lang="en-US">Using the Average_Range</paragraph>
+<h4 id="hd_id2101254257133">Using the Average_Range</h4>
<paragraph id="par_id2509201519315584" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&lt;35";C2:C6)</item></paragraph>
<paragraph id="par_id148222637631350" role="paragraph" xml-lang="en-US">The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation. </paragraph>
<paragraph id="par_id2509201519315535" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&gt;"&amp;MIN(B2:B6);C2:C6)</item></paragraph>
<paragraph id="par_id2412836525208" role="paragraph" xml-lang="en-US">The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation.</paragraph>
<paragraph id="par_id2509201519315547" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"&lt;"&amp;LARGE(B2:B6;2);C2:C6)</item></paragraph>
<paragraph id="par_id173931101529497" role="paragraph" xml-lang="en-US">The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation. </paragraph>
-<paragraph id="hd_id30054471316969" role="heading" level="4" xml-lang="en-US">Using regular expressions</paragraph>
+<h4 id="hd_id30054471316969">Using regular expressions</h4>
<paragraph id="par_id2509201519360514" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;"pen";B2:B6)</item></paragraph>
<paragraph id="par_id14714860719948" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range.</paragraph>
<paragraph id="par_id250920151936096" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;"pen.*";B2:B6)</item></paragraph>
<paragraph id="par_id26959239098104" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation. </paragraph>
<paragraph id="par_id2509201519361352" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;".*book.*";B2:B6)</item></paragraph>
<paragraph id="par_id227041304619482" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation.</paragraph>
-<paragraph id="hd_id251309885188" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id251309885188">Reference to a cell as a criterion</h4>
<paragraph id="par_id177972099720424" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIF function. </paragraph>
<paragraph id="par_id134941261230060" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;".*"&amp;E2&amp;".*";B2:B6)</item></paragraph>
<paragraph id="par_id172572288310247" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5.</paragraph>
@@ -78,7 +79,7 @@ If the whole range is empty, contains only text or all values of the range do no
<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
-<paragraph id="par_id251321802714497" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id251321802714497" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp
index 3c72f34dce..ead6f7280e 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -23,7 +23,7 @@
<bookmark_value>AVERAGEIFS function</bookmark_value>
<bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>
</bookmark>
-<paragraph id="hd_id537445374453744" role="heading" level="2" xml-lang="en-US"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</paragraph>
+<h2 id="hd_id537445374453744"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</h2>
<paragraph id="par_id538405384053840" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#4.0"/>
@@ -32,23 +32,24 @@
<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/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"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="hd_id20733192524041" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
-<paragraph id="par_id24004653627203" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(B2:B6;B2:B6;">=20")</item></paragraph>
+<h4 id="hd_id20733192524041">Simple usage</h4>
+<paragraph id="par_id24004653627203" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(B2:B6;B2:B6;"&gt;=20")</item></paragraph>
<paragraph id="par_id30201168686268" role="paragraph" xml-lang="en-US">Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion.</paragraph>
-<paragraph id="par_id30279247419921" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">=20";C2:C6;">70")</item></paragraph>
+<paragraph id="par_id30279247419921" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;"&gt;=20";C2:C6;"&gt;70")</item></paragraph>
<paragraph id="par_id2930764965983" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion.</paragraph>
-<paragraph id="hd_id317532515726820" role="heading" level="4" xml-lang="en-US">Using regular expressions and nested functions</paragraph>
-<paragraph id="par_id457966021670" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
+<h4 id="hd_id317532515726820">Using regular expressions and nested functions</h4>
+<paragraph id="par_id457966021670" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;"&gt;"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id66091035229950" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion.</paragraph>
<paragraph id="par_id303162761931870" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;"pen.*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id40031348913642" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria.</paragraph>
-<paragraph id="hd_id31201205191857" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id31201205191857">Reference to a cell as a criterion</h4>
<paragraph id="par_id316794795433" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id67531072426731" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&amp;".*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id65612244926745" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph>
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp
index a06f12b85c..71517c8246 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -24,7 +24,7 @@
<bookmark_value>counting row;satisfying criteria</bookmark_value>
<bookmark_value>counting column;satisfying criteria</bookmark_value>
</bookmark>
-<paragraph id="hd_id456845684568" role="heading" level="2" xml-lang="en-US"><variable id="countifs_head"><link href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable> function</paragraph>
+<h2 id="hd_id456845684568"><variable id="countifs_head"><link href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable> function</h2>
<paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#4.0"/>
@@ -32,24 +32,25 @@
<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])</paragraph>
<paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Range1</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 counting and finding the corresponding criterion.</paragraph>
<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
-<paragraph id="par_id14734320631377" role="warning" xml-lang="en-US"><emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph>
+<embed href="text/shared/00/00000001.xhp#regulaer"/>
+<paragraph role="paragraph" id="par_id14734320631377"><emph>Range1, Range2, ...</emph> and <emph>Criterion1, 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"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="hd_id3861259759512" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
-<paragraph id="par_id15856592423333" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">=20")</item></paragraph>
+<h4 id="hd_id3861259759512">Simple usage</h4>
+<paragraph id="par_id15856592423333" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;"&gt;=20")</item></paragraph>
<paragraph id="par_id323511393121175" role="paragraph" xml-lang="en-US">Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion.</paragraph>
-<paragraph id="par_id74301057922522" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">=20";C2:C6;">70")</item></paragraph>
+<paragraph id="par_id74301057922522" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;"&gt;=20";C2:C6;"&gt;70")</item></paragraph>
<paragraph id="par_id109622995127628" role="paragraph" xml-lang="en-US">Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion.</paragraph>
-<paragraph id="hd_id298462825526166" role="heading" level="4" xml-lang="en-US">Using regular expressions and nested functions</paragraph>
+<h4 id="hd_id298462825526166">Using regular expressions and nested functions</h4>
<paragraph id="par_id22736248573471" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;"[:alpha:]*")</item></paragraph>
<paragraph id="par_id22137303324873" role="paragraph" xml-lang="en-US">Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion.</paragraph>
-<paragraph id="par_id82271340221411" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
+<paragraph id="par_id82271340221411" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;"&gt;"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id1105320769334" role="paragraph" xml-lang="en-US">Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion.</paragraph>
<paragraph id="par_id267603146513224" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(A2:A6;"pen.*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id111252614832220" role="paragraph" xml-lang="en-US">Counts the amount of rows that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria.</paragraph>
-<paragraph id="hd_id212582362610399" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id212582362610399">Reference to a cell as a criterion</h4>
<paragraph id="par_id3245551524846" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id109501907712434" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(A2:A6;E2&amp;".*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id738533068520" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above.</paragraph>
@@ -68,7 +69,7 @@
<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
-<paragraph id="par_id235992404316585" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id235992404316585" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp
index ebb829283f..934f89e5e8 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -23,7 +23,7 @@
<bookmark_value>MAXIFS function</bookmark_value>
<bookmark_value>maximum;satisfying conditions</bookmark_value>
</bookmark>
-<paragraph id="hd_id658866588665886" role="heading" level="1" xml-lang="en-US"><variable id="maxifs_head"><link href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable> function</paragraph>
+<h1 id="hd_id658866588665886"><variable id="maxifs_head"><link href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable> function</h1>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#5.2"/>
@@ -33,23 +33,24 @@
<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/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"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="hd_id193452436229521" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
+<h4 id="hd_id193452436229521">Simple usage</h4>
<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(B2:B6;B2:B6;"&lt;35")</item></paragraph>
<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion.</paragraph>
<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;B2:B6;"&gt;=20";C2:C6;"&lt;90")</item></paragraph>
<paragraph id="par_id189772445525114" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion.</paragraph>
-<paragraph id="hd_id30455222431067" role="heading" level="4" xml-lang="en-US">Using regular expressions and nested functions</paragraph>
-<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;B2:B6;">"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
+<h4 id="hd_id30455222431067">Using regular expressions and nested functions</h4>
+<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;B2:B6;"&gt;"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id27619246864839" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria.</paragraph>
<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;"pen.*";B2:B6;"&lt;="&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id15342189586295" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria.</paragraph>
-<paragraph id="hd_id8168283329426" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4>
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;E2&amp;".*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph>
@@ -68,7 +69,7 @@
<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
-<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp
index 1fe496539d..2fbb087a16 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -23,7 +23,7 @@
<bookmark_value>MINIFS function</bookmark_value>
<bookmark_value>minimum;satisfying conditions</bookmark_value>
</bookmark>
-<paragraph id="hd_id658866588665886" role="heading" level="1" xml-lang="en-US"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</paragraph>
+<h1 id="hd_id658866588665886"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</h1>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#5.2"/>
@@ -33,23 +33,24 @@
<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/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"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="hd_id193452436229521" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
+<h4 id="hd_id193452436229521">Simple usage</h4>
<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(B2:B6;B2:B6;"&lt;35")</item></paragraph>
<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17.</paragraph>
<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;"&gt;=20";C2:C6;"&gt;90")</item></paragraph>
<paragraph id="par_id189772445525114" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190.</paragraph>
-<paragraph id="hd_id30455222431067" role="heading" level="4" xml-lang="en-US">Using regular expressions and nested functions</paragraph>
-<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;">"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
+<h4 id="hd_id30455222431067">Using regular expressions and nested functions</h4>
+<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;"&gt;"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id27619246864839" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65.</paragraph>
<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;"&lt;="&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id15342189586295" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its minimum. Returns 180.</paragraph>
-<paragraph id="hd_id8168283329426" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4>
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&amp;E2;B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph>
@@ -69,7 +70,7 @@
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
-<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp
index 364da42f75..ec594d56b4 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -23,7 +23,7 @@
<bookmark_value>SUMIFS function</bookmark_value>
<bookmark_value>sum;satisfying conditions</bookmark_value>
</bookmark>
-<paragraph id="hd_id658866588665886" role="heading" level="1" xml-lang="en-US"><variable id="sumifs_head"><link href="text/scalc/01/func_sumifs.xhp">SUMIFS</link></variable> function</paragraph>
+<h1 id="hd_id658866588665886"><variable id="sumifs_head"><link href="text/scalc/01/func_sumifs.xhp">SUMIFS</link></variable> function</h1>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="sumifs_des">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
<embed href="text/scalc/00/avail_release.xhp#4.0"/>
@@ -33,23 +33,24 @@
<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/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"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="hd_id193452436229521" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
-<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(B2:B6;B2:B6;">=20")</item></paragraph>
+<h4 id="hd_id193452436229521">Simple usage</h4>
+<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(B2:B6;B2:B6;"&gt;=20")</item></paragraph>
<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion.</paragraph>
-<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;B2:B6;">=20";C2:C6;">70")</item></paragraph>
+<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;B2:B6;"&gt;=20";C2:C6;"&gt;70")</item></paragraph>
<paragraph id="par_id189772445525114" role="paragraph" xml-lang="en-US">Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion.</paragraph>
-<paragraph id="hd_id30455222431067" role="heading" level="4" xml-lang="en-US">Using regular expressions and nested functions</paragraph>
-<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;B2:B6;">"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
+<h4 id="hd_id30455222431067">Using regular expressions and nested functions</h4>
+<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;B2:B6;"&gt;"&amp;MIN(B2:B6);B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id27619246864839" role="paragraph" xml-lang="en-US">Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion.</paragraph>
<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;A2:A6;"pen.*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id15342189586295" role="paragraph" xml-lang="en-US">Calculates the sum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria.</paragraph>
-<paragraph id="hd_id8168283329426" role="heading" level="4" xml-lang="en-US">Reference to a cell as a criterion</paragraph>
+<h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4>
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;A2:A6;E2&amp;".*";B2:B6;"&lt;"&amp;MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph>
@@ -66,7 +67,7 @@
<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
</paragraph>
-<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp
index 0cf821b145..51fe8d7613 100644
--- a/source/text/scalc/guide/numbers_text.xhp
+++ b/source/text/scalc/guide/numbers_text.xhp
@@ -32,8 +32,8 @@
<bookmark_value>date formats;conversion</bookmark_value>
<bookmark_value>converting;text, into numbers</bookmark_value>
</bookmark><comment>mw changed "converting;" and added two index entries</comment>
-<paragraph xml-lang="en-US" id="hd_id0908200901265171" role="heading" level="1"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link>
-</variable></paragraph>
+<h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link>
+</variable></h1>
<section id="text">
<paragraph xml-lang="en-US" id="par_id0908200901265127" role="paragraph">Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.</paragraph>
<paragraph xml-lang="en-US" id="par_id0908200901265196" role="paragraph"><emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.</paragraph>
@@ -73,7 +73,8 @@
<note id="par_id761567607207916">The conversion is done for single scalar values only, not within ranges.</note>
<paragraph xml-lang="en-US" id="par_id0908200901265448" role="paragraph">The conversion is done for single scalar values, as in =A1+A2, or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string.</paragraph>
<paragraph xml-lang="en-US" id="par_id090820090126540" role="paragraph">Strings inside formulas are also converted, such as in ="1999-11-22"+42, which returns the date 42 days after November 22nd, 1999. Calculations involving localized dates as strings inside the formula return an error. For example, the localized date string "11/22/1999" or "22.11.1999" cannot be used for the automatic conversion.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id1005200903485368" role="heading" level="2">Example</paragraph>
+ <embed href="text/shared/00/00000001.xhp#regexnumex"/>
+ <h2 id="hd_id1005200903485368">Example</h2>
<paragraph xml-lang="en-US" id="par_id1005200903485359" role="paragraph">In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally).</paragraph>
<paragraph xml-lang="en-US" id="par_id1005200903485341" role="paragraph">In A2 enter <literal>=A1+1</literal> (which correctly results in 101).</paragraph>
<paragraph role="paragraph" id="par_id891567607263849">The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which has value 0 for the SUM function.</paragraph>
diff --git a/source/text/shared/00/00000001.xhp b/source/text/shared/00/00000001.xhp
index 10dc6d076b..6b716b3b58 100644
--- a/source/text/shared/00/00000001.xhp
+++ b/source/text/shared/00/00000001.xhp
@@ -25,7 +25,7 @@
</topic>
</meta>
<body>
-<paragraph xml-lang="en-US" id="hd_id3152952" role="heading" level="1">Frequently-Used Buttons</paragraph>
+<h1 id="hd_id3152952">Frequently-Used Buttons</h1>
<section id="abbrechen">
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDCANCEL" id="bm_id4245124" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CANCEL" id="bm_id7074800" localize="false"/>
@@ -36,21 +36,21 @@
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDCANCEL" id="bm_id3149177" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDCANCEL" id="bm_id3154142" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_CANCEL" id="bm_id3145416" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147617" role="heading" level="2">Cancel</paragraph>
+<h2 id="hd_id3147617">Cancel</h2>
<paragraph xml-lang="en-US" id="par_id3155913" role="paragraph"><ahelp hid=".">Clicking <emph>Cancel</emph> closes a dialog without saving any changes made.</ahelp></paragraph>
</section>
<section id="finish">
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDFINISH" id="bm_id3211157" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_QUERYWIZARD_CREATE" id="bm_id189519" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2341685" role="heading" level="2">Finish</paragraph>
+<h2 id="hd_id2341685">Finish</h2>
<paragraph xml-lang="en-US" id="par_id6909390" role="paragraph"><ahelp hid=".">Applies all changes and closes the wizard.</ahelp></paragraph>
</section>
<section id="abreissleiste">
-<paragraph xml-lang="en-US" id="hd_id3147477" role="heading" level="2">Toolbars</paragraph>
+<h2 id="hd_id3147477">Toolbars</h2>
<paragraph xml-lang="en-US" id="par_id3149783" role="paragraph">By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the <emph>Close Window</emph> icon. Make the toolbar visible again by choosing <emph>View - Toolbars - (toolbar name)</emph>.</paragraph>
</section>
<section id="drehfeld">
-<paragraph xml-lang="en-US" id="hd_id3152414" role="heading" level="2">Spin button</paragraph>
+<h2 id="hd_id3152414">Spin button</h2>
<section id="spinbutton">
<list type="ordered">
<listitem>
@@ -65,11 +65,11 @@
</section>
</section>
<section id="import">
-<paragraph xml-lang="en-US" id="hd_id3154232" role="heading" level="2">Convert</paragraph>
+<h2 id="hd_id3154232">Convert</h2>
<paragraph xml-lang="en-US" id="par_id3148983" role="paragraph"><ahelp hid=".">If you click forward through the dialog, this button is called <emph>Next</emph>. On the last page the button has the name <emph>Convert</emph>. The conversion is then performed by clicking the button.</ahelp></paragraph>
</section>
<section id="kontextmenue">
-<paragraph xml-lang="en-US" id="hd_id3145129" role="heading" level="2">Context Menu</paragraph>
+<h2 id="hd_id3145129">Context Menu</h2>
<section id="contextmenu">
<paragraph xml-lang="en-US" id="par_id3156553" role="paragraph"><variable id="context">To activate the context menu of an object, first click the object with the <switchinline select="sys"><caseinline select="MAC">
</caseinline><defaultinline>left</defaultinline></switchinline> mouse button to select it, and then, <switchinline select="sys"><caseinline select="MAC">while holding down the <emph>Ctrl</emph> key or the <emph>Command</emph> and <emph>Option</emph> keys, click the mouse button again
@@ -93,7 +93,7 @@
<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/dialogpage/library" id="bm_id3214514" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/BasicIDE/ui/libpage/delete" id="bm_id3145749" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/linestyletabpage/BTN_DELETE" id="bm_id3150443" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149180" role="heading" level="2">Delete</paragraph>
+<h2 id="hd_id3149180">Delete</h2>
<paragraph xml-lang="en-US" id="par_id3153750" role="paragraph"><ahelp hid=".">Deletes the selected element or elements after confirmation.</ahelp></paragraph>
</section>
<section id="loeschen1">
@@ -105,24 +105,24 @@
<bookmark xml-lang="en-US" branch="hid/cui/ui/acorreplacepage/delete" id="bm_id7878353" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/delabbrev" id="bm_id5413373" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/cui/ui/acorexceptpage/deldouble" id="bm_id2580950" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147557" role="heading" level="2">Delete</paragraph>
+<h2 id="hd_id3147557">Delete</h2>
<paragraph xml-lang="en-US" id="par_id3155338" role="paragraph"><ahelp hid=".">Deletes the selected element or elements without requiring confirmation.</ahelp></paragraph>
</section>
<section id="metrik">
-<paragraph xml-lang="en-US" id="hd_id3148620" role="heading" level="2">Metrics</paragraph>
+<h2 id="hd_id3148620">Metrics</h2>
<paragraph xml-lang="en-US" id="par_id3145345" role="paragraph">You can enter values in the input fields in different <link href="text/shared/00/00000003.xhp#metrik" name="units of measurement">units of measurement</link>. The default unit is inches. However, if you want a space of exactly 1 cm, then type "1cm". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value.</paragraph>
</section>
<section id="schliessen">
-<paragraph xml-lang="en-US" id="hd_id3155535" role="heading" level="2">Close</paragraph>
+<h2 id="hd_id3155535">Close</h2>
<paragraph xml-lang="en-US" id="par_id3147008" role="paragraph"><ahelp hid=".">Closes the dialog and saves all changes.</ahelp></paragraph>
</section>
<section id="schliessen2">
-<paragraph xml-lang="en-US" id="hd_id3147275" role="heading" level="2">Close</paragraph>
+<h2 id="hd_id3147275">Close</h2>
<paragraph xml-lang="en-US" id="par_id3153031" role="paragraph"><ahelp hid=".">Closes the dialog.</ahelp></paragraph>
</section>
<section id="uebernehmen">
<bookmark xml-lang="en-US" branch="hid/modules/smath/ui/catalogdialog/insert" id="bm_id3149053" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156113" role="heading" level="2">Apply</paragraph>
+<h2 id="hd_id3156113">Apply</h2>
<paragraph xml-lang="en-US" id="par_id3155341" role="paragraph"><ahelp hid=".">Applies the modified or selected values without closing the dialog.</ahelp></paragraph>
</section>
<section id="eingabesymbol">
@@ -145,7 +145,7 @@
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/rbfilterarea" id="bm_id3153190" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/standardfilterdialog/rbcopyarea" id="bm_id3150010" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/rbcopyarea" id="bm_id3146985" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153760" role="heading" level="2">Shrink / Maximize</paragraph>
+<h2 id="hd_id3153760">Shrink / Maximize</h2>
<paragraph xml-lang="en-US" id="par_id3153087" role="paragraph"><ahelp hid=".">Click the <emph>Shrink</emph> icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the <emph>Maximize</emph> icon. Click it to restore the dialog to its original size.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3155062" role="paragraph">The dialog is automatically minimized when you click into a sheet with the mouse. As soon as you release the mouse button, the dialog is restored and the reference range defined with the mouse is highlighted in the document by a blue frame.</paragraph>
<table id="tbl_id3148473">
@@ -173,7 +173,7 @@
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/preview" id="bm_id3155601" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/autoformattable/preview" id="bm_id3147175" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/swriter/ui/inserttable/previewinstable" id="bm_id3147227" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156192" role="heading" level="2">Preview Field</paragraph>
+<h2 id="hd_id3156192">Preview Field</h2>
<paragraph xml-lang="en-US" id="par_id3154046" role="paragraph"><ahelp hid=".">Displays a preview of the current selection.</ahelp></paragraph>
</section>
<section id="weiterautopi">
@@ -186,38 +186,38 @@
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id31475761" localize="false"/>
<!-- removed HID HID_DLGREPORT_0_CMDNEXTORREADY -->
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145609" role="heading" level="2">Next</paragraph>
+<h2 id="hd_id3145609">Next</h2>
<paragraph xml-lang="en-US" id="par_id3152473" role="paragraph"><ahelp hid=".">Click the <emph>Next</emph> button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp></paragraph>
</section>
<section id="AutocorrectButtons">
<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/reset" id="bm_id4539934" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149671" role="heading" level="2">Dialog Buttons</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145069" role="heading" level="3">Reset</paragraph>
+<h2 id="hd_id3149671">Dialog Buttons</h2>
+<h3 id="par_id3145069">Reset</h3>
<paragraph xml-lang="en-US" id="par_id3145169" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/reset">Resets modified values back to the tab page previous values.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/cancel" id="bm_id4539935" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3145070" role="heading" level="3">Cancel</paragraph>
+<h3 id="par_id3145070">Cancel</h3>
<paragraph xml-lang="en-US" id="par_id3145269" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/cancel">Closes dialog and discards all changes.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/cui/ui/autocorrectdialog/ok" id="bm_id4539936" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3145071" role="heading" level="3">OK</paragraph>
+<h3 id="par_id3145071">OK</h3>
<paragraph xml-lang="en-US" id="par_id3145369" role="paragraph"><ahelp hid="cui/ui/autocorrectdialog/ok">Saves all changes and closes dialog.</ahelp></paragraph>
</section>
<section id="zurueck">
<bookmark xml-lang="en-US" branch="hid/cui/ui/optionsdialog/revert" id="bm_id4539933" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149670" role="heading" level="2">Reset<comment>in Tools - Options</comment></paragraph>
+<h2 id="hd_id3149670">Reset<comment>in Tools - Options</comment></h2>
<paragraph xml-lang="en-US" id="par_id3145068" role="paragraph"><ahelp hid="cui/ui/optionsdialog/revert">Resets changes made to the current tab to those applicable when this dialog was opened.</ahelp></paragraph>
</section>
<section id="zurueck2">
<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_RESET_BTN" id="bm_id3151054" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148755" role="heading" level="2">Reset<comment>all tab dialogs</comment></paragraph>
+<h2 id="hd_id3148755">Reset<comment>all tab dialogs</comment></h2>
<paragraph xml-lang="en-US" id="par_id3149651" role="paragraph"><ahelp hid=".">Resets changes made to the current tab to those applicable when this dialog was opened. A confirmation query does not appear when you close the dialog.</ahelp></paragraph>
</section>
<section id="standard">
<bookmark xml-lang="en-US" branch="hid/sw:PushButton:TP_STD_FONT:PB_STANDARD" id="bm_id481887" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SFX2_HID_TABDLG_STANDARD_BTN" id="bm_id3157322" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/sdraw/ui/copydlg/default" id="bm_id3083280" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145173" role="heading" level="2">Standard<comment>e.g. in Format - Para Style</comment><comment>UFI: Name is Default on Tools-Options-Writer-Basic Fonts</comment></paragraph>
+<h2 id="hd_id3145173">Standard<comment>e.g. in Format - Para Style</comment><comment>UFI: Name is Default on Tools-Options-Writer-Basic Fonts</comment></h2>
<paragraph xml-lang="en-US" id="par_id3154153" role="paragraph"><ahelp hid=".">Resets the values visible in the dialog back to the default installation values.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id3154299" role="warning">A confirmation does not appear before the defaults are reloaded.</paragraph>
+ <warning id="par_id3154299">A confirmation does not appear before the defaults are reloaded.</warning>
</section>
<section id="zurueckautopi">
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDPREV" id="bm_id1064180" localize="false"/>
@@ -228,29 +228,34 @@
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDPREV" id="bm_id3145346" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGREPORT_0_CMDPREV" id="bm_id3150984" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147502" role="heading" level="2">Back</paragraph>
+<h2 id="hd_id3147502">Back</h2>
<paragraph xml-lang="en-US" id="par_id3150439" role="paragraph"><ahelp hid=".">View the selections in the dialog made in the previous step. The current settings remain unchanged.</ahelp> This button can only be activated from page two on.</paragraph>
</section>
<section id="zusaetze">
<bookmark xml-lang="en-US" branch="hid/SFX2_HID_MOREOPTIONS_BTN" id="bm_id3157322" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147353" role="heading" level="2">Options</paragraph>
+<h2 id="hd_id3147353">Options</h2>
<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>
-<paragraph xml-lang="en-US" id="par_id3147418" role="paragraph"><variable id="regulaer">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"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph></link>.</variable></paragraph>
+<section id="regulaer">
+ <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>
+ </section>
+</section>
<paragraph xml-lang="en-US" id="par_id3163714" role="paragraph"><variable id="wahr">If an error occurs, the function returns a logical or numerical value.</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3154145" role="paragraph"><variable id="kontext">(This command is only accessible through the <link href="text/shared/00/00000005.xhp#kontextmenue" name="context menu">context menu</link>).</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3152791" role="paragraph"><variable id="wiederholen">By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id9345377" role="paragraph"><variable id="ShiftF1">Press <emph>Shift+F1</emph> and point to a control to learn more about that control.</variable></paragraph>
<section id="optionsbuttons">
-<paragraph role="heading" id="hd_id631527692833772" level="2" xml-lang="en-US">Options dialog buttons</paragraph>
-<paragraph role="heading" id="hd_id831527692839432" level="3" xml-lang="en-US">OK</paragraph>
+<h2 id="hd_id631527692833772">Options dialog buttons</h2>
+<h3 id="hd_id831527692839432">OK</h3>
<paragraph role="paragraph" id="par_id471527692844934" xml-lang="en-US">Save the changes in the page and close the Options dialog.</paragraph>
-<paragraph role="heading" id="hd_id261527692850720" level="3" xml-lang="en-US">Cancel</paragraph>
+<h3 id="hd_id261527692850720">Cancel</h3>
<paragraph role="paragraph" id="par_id571527692855533" xml-lang="en-US">Close the Options dialog and discard all changes done.</paragraph>
- <embed href="text/shared/00/00000001.xhp#zurueck" />
+ <embed href="text/shared/00/00000001.xhp#zurueck"/>
<section id="optionsbuttonwarn01">
-<paragraph xml-lang="en-US" id="par_id261527693436801" role="warning">Some options cannot be reset once edited. Either edit back the changes manually or click <emph>Cancel</emph> and reopen the <emph>Options</emph> dialog.</paragraph>
+<warning id="par_id261527693436801">Some options cannot be reset once edited. Either edit back the changes manually or click <emph>Cancel</emph> and reopen the <emph>Options</emph> dialog.</warning>
</section>
</section>
</body>
diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp
index 0577a03b7b..bb3bf1216b 100644
--- a/source/text/shared/optionen/01060500.xhp
+++ b/source/text/shared/optionen/01060500.xhp
@@ -45,16 +45,16 @@
</bookmark><comment>UFI: removed a double entry</comment><comment>mw changed "cell contents;" to "case sensitivity;.."</comment><comment>mw deleted "numbers;decimal places (Calc)"</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/OptCalculatePage" id="bm_id3149095" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/@@nowidget@@" id="bm_id3149095" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145071" role="heading" level="1"><link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link></paragraph>
+<h1 id="hd_id3145071"><link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link></h1>
<paragraph xml-lang="en-US" id="par_id3147576" role="paragraph"><ahelp hid=".">Defines the calculation settings for spreadsheets.</ahelp> Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.</paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#exopbe"/>
</section>
- <paragraph xml-lang="en-US" id="hd_id3149399" role="heading" level="2">Iterative references</paragraph>
+ <h2 id="hd_id3149399">Iterative references</h2>
<paragraph xml-lang="en-US" id="par_id3155419" role="paragraph">In this section you can delimit the number of approximation steps carried out during iterative calculations. In addition, you can specify the degree of precision of the answer.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/iterate" id="bm_id3156153" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154142" role="heading" level="3">Iterations</paragraph>
+<h3 id="hd_id3154142">Iterations</h3>
<paragraph xml-lang="en-US" id="par_id3149795" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/iterate">Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.</ahelp> If the<emph> Iterations </emph>box is not marked, an iterative reference in the table will cause an error message.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148686" role="paragraph">
<emph>Example:</emph> calculating the cost of an item without the value-added tax.</paragraph>
@@ -77,15 +77,15 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154365" role="paragraph">A</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154365" role="tablehead">A</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3145606" role="paragraph">B</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3145606" role="tablehead">B</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3149202" role="paragraph">5</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149202" role="tablehead">5</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3151041" role="paragraph">Selling Price</paragraph>
@@ -96,7 +96,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3159254" role="paragraph">6</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159254" role="tablehead">6</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3147317" role="paragraph">Net</paragraph>
@@ -107,7 +107,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3154918" role="paragraph">7</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154918" role="tablehead">7</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3153573" role="paragraph">Tax</paragraph>
@@ -119,34 +119,34 @@
</table>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/steps" id="bm_id3146119" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145750" role="heading" level="3">Steps</paragraph>
+<h3 id="hd_id3145750">Steps</h3>
<paragraph xml-lang="en-US" id="par_id3152576" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/steps">Sets the maximum number of iteration steps.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/minchange" id="bm_id3145273" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153728" role="heading" level="3">Minimum Change</paragraph>
+<h3 id="hd_id3153728">Minimum Change</h3>
<paragraph xml-lang="en-US" id="par_id3153139" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/minchange">Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147125" role="heading" level="2">Date</paragraph>
+ <h2 id="hd_id3147125">Date</h2>
<paragraph xml-lang="en-US" id="par_id3155416" role="paragraph">Select the start date for the internal conversion from days to numbers.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/datestd" id="bm_id3153159" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147396" role="heading" level="3">12/30/1899 (default)</paragraph>
+<h3 id="hd_id3147396">12/30/1899 (default)</h3>
<paragraph xml-lang="en-US" id="par_id3145646" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/datestd">Sets 12/30/1899 as day zero.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/datesc10" id="bm_id3150715" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156283" role="heading" level="3">01/01/1900 (StarCalc 1.0)</paragraph>
+<h3 id="hd_id3156283">01/01/1900 (StarCalc 1.0)</h3>
<paragraph xml-lang="en-US" id="par_id3154018" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/datesc10">Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/date1904" id="bm_id3147173" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156181" role="heading" level="3">01/01/1904</paragraph>
+<h3 id="hd_id3156181">01/01/1904</h3>
<paragraph xml-lang="en-US" id="par_id3153948" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/date1904">Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/case" id="bm_id3151205" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153838" role="heading" level="2">Case sensitive</paragraph>
+<h2 id="hd_id3153838">Case sensitive</h2>
<paragraph xml-lang="en-US" id="par_id3146793" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/case">Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3153707" role="paragraph">
<emph>Example:</emph> Type the text 'Test' in cell A1; and the text 'test' in B1. Then type the formula "=A1=B1" in cell C1. If the <emph>Case sensitive</emph> box is marked, FALSE will appear in the cell; otherwise, TRUE will appear in the cell.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153965" role="note">The EXACT text function is always case-sensitive, independent of the settings in this dialog.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153966" role="warning">Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.</paragraph>
+ <note id="par_id3153965">The EXACT text function is always case-sensitive, independent of the settings in this dialog.</note>
+ <warning id="par_id3153966">Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.</warning>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/calc" id="bm_id3145766" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145150" role="heading" level="2">Precision as shown</paragraph>
+<h2 id="hd_id3145150">Precision as shown</h2>
<paragraph xml-lang="en-US" id="par_id3150644" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/calc">Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the <emph>Precision as shown</emph> option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/match" id="bm_id3150364" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152581" role="heading" level="2">Search criteria = and &lt;&gt; must apply to whole cells</paragraph>
+<h2 id="hd_id3152581">Search criteria = and &lt;&gt; must apply to whole cells</h2>
<paragraph xml-lang="en-US" id="par_id3149211" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/match">Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the <emph>Search criteria = and &lt;&gt; must apply to whole cells</emph> box and the <emph>Enable wildcards in formulas</emph> box are marked, $[officename] Calc behaves exactly as Microsoft Excel when searching cells in the database functions.</ahelp></paragraph>
<table id="tbl_id3149814">
<tablerow>
@@ -192,11 +192,11 @@
</table>
<paragraph xml-lang="en-US" id="par_id3148814" role="paragraph">If <emph>Search criteria = and &lt;&gt; must apply to whole cells </emph>is not enabled, the "win" search pattern acts like "*win*". The search pattern can be at any position within the cell when searching with the Calc database functions.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155096" role="warning">Enable whole cell match for spreadsheets that need to be interoperable with Microsoft Excel.</paragraph>
+ <warning id="par_id3155096">Enable whole cell match for spreadsheets that need to be interoperable with Microsoft Excel.</warning>
<section id="wildcards">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formulawildcards" id="bm_id3154420" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156449" role="heading" level="2">Enable wildcards in formulas</paragraph>
+<h2 id="hd_id3156449">Enable wildcards in formulas</h2>
<paragraph xml-lang="en-US" id="par_id3155093" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulawildcards">Specifies that wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.</caseinline></switchinline></paragraph>
<list type="unordered">
<listitem>
@@ -209,32 +209,32 @@
<paragraph xml-lang="en-US" id="par_id3155102" role="listitem"><emph>~</emph> (tilde) escapes the special meaning of a question mark, asterisk or tilde character that follows immediately after the tilde character</paragraph>
</listitem>
</list>
- <paragraph xml-lang="en-US" id="par_id3155094" role="warning">Enable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</paragraph>
+ <warning id="par_id3155094">Enable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</warning>
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formularegex" id="bm_id3154419" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156448" role="heading" level="2">Enable regular expressions in formulas</paragraph>
+<h2 id="hd_id3156448">Enable regular expressions in formulas</h2>
<paragraph xml-lang="en-US" id="par_id3155092" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formularegex">Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.
</caseinline></switchinline><comment>Sorry, no more switches allowed inside AVIS tags</comment></paragraph>
- <paragraph xml-lang="en-US" id="par_id3155095" role="warning">Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</paragraph>
+ <warning id="par_id3155095">Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</warning>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formulaliteral" id="bm_id3154421" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156450" role="heading" level="2">No wildcards or regular expressions in formulas</paragraph>
+<h2 id="hd_id3156450">No wildcards or regular expressions in formulas</h2>
<paragraph xml-lang="en-US" id="par_id3155097" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulaliteral">Specifies that only literal strings are used when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.
</caseinline></switchinline></paragraph>
- <paragraph xml-lang="en-US" id="par_id3155098" role="warning">Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</paragraph>
+ <warning id="par_id3155098">Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</warning>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/lookup" id="bm_id3152901" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156199" role="heading" level="2">Automatically find column and row labels</paragraph>
+<h2 id="hd_id3156199">Automatically find column and row labels</h2>
<paragraph xml-lang="en-US" id="par_id3153818" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/lookup">Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3151242" role="paragraph">
<emph>Example</emph>: Cell E5 contains the text "Europe". Below, in cell E6, is the value 100 and in cell E7 the value 200. If the <emph>Automatically find column and row labels</emph> box is marked, you can write the following formula in cell A1: =SUM(Europe).</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/generalprec" id="bm_id315342901" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id315634199" role="heading" level="2">Limit decimals for general number format</paragraph>
+<h2 id="hd_id315634199">Limit decimals for general number format</h2>
<paragraph xml-lang="en-US" id="par_id315343818" role="paragraph"><ahelp hid=".">You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/prec" id="bm_id3147362" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145231" role="heading" level="2">Decimal places</paragraph>
+<h2 id="hd_id3145231">Decimal places</h2>
<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/prec">Defines the number of decimals to be displayed for numbers with the <emph>General</emph> number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.</ahelp></paragraph>
</body>
diff --git a/source/text/shared/optionen/detailedcalculation.xhp b/source/text/shared/optionen/detailedcalculation.xhp
index cef7a5058a..f9bf1119eb 100644
--- a/source/text/shared/optionen/detailedcalculation.xhp
+++ b/source/text/shared/optionen/detailedcalculation.xhp
@@ -7,7 +7,6 @@
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
-->
-
<helpdocument version="1.0">
<meta>
<topic id="detailedcalculation" indexer="include" status="PUBLISH">
@@ -34,22 +33,22 @@
<section id="detailed_calculation">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/formulacalculationoptions/FormulaCalculationOptions" id="bm_id2745673" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/formulacalculationoptions/@@nowidget@@" id="@@nowidget@@" localize="false"/>
- <paragraph id="hd_id371535153017185" role="heading" level="1" xml-lang="en-US"><variable id="detailed_heading"><link href="text/shared/optionen/detailedcalculation.xhp" name="detailedcalc">Detailed Calculation Settings</link></variable></paragraph>
+ <h1 id="hd_id371535153017185"><variable id="detailed_heading"><link href="text/shared/optionen/detailedcalculation.xhp" name="detailedcalc">Detailed Calculation Settings</link></variable></h1>
<paragraph id="par_id461535153017196" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats.</ahelp></variable></paragraph>
</section>
<section id="howtoget">
<paragraph role="paragraph" id="par_id2752992" xml-lang="en-US"><variable id="sam01">Menu <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Formula</emph>, and in section <emph>Detailed Calculation Settings</emph> press <emph>Details...</emph> button.</variable></paragraph>
</section>
- <paragraph role="heading" id="par_id4238715" xml-lang="en-US" level="2">Contents to Numbers</paragraph>
- <paragraph role="heading" id="par_id8277230" xml-lang="en-US" level="3">Conversion from text to number</paragraph>
+ <h2 id="par_id4238715">Contents to Numbers</h2>
+ <h3 id="par_id8277230">Conversion from text to number</h3>
<paragraph role="paragraph" id="par_id396740" xml-lang="en-US">How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales!</paragraph>
<paragraph role="paragraph" id="par_id4086428" xml-lang="en-US"><emph>Generate #VALUE! error:</emph> Text found where numeric data is expected will generate #VALUE! error. Example: <item type="input">"123.45"</item> will generate a #VALUE! error, while <item type="input">123.45</item> not.</paragraph>
<paragraph role="paragraph" id="par_id9024628" xml-lang="en-US"><emph>Treat as zero:</emph> Any text found where numeric data is expected will be considered as a number of value zero. Example: <item type="input">"123.45"</item> will map to zero, while <item type="input">123.45</item> not.</paragraph>
<paragraph role="paragraph" id="par_id3067110" xml-lang="en-US"><emph>Convert only if unambiguous:</emph> If the text represents a valid and unambiguous numeric value, convert it. Example: <item type="input">"123.456"</item> will generate a #VALUE! error because the text contains a separator, while <item type="input">"123456"</item> will not.</paragraph>
<paragraph role="paragraph" id="par_id8841822" xml-lang="en-US"><emph>Convert also locale dependent:</emph> convert values valid in the locale representation. Example: <item type="input">"123,45"</item> is a valid number in some locales because the comma is the decimal separator there.</paragraph>
- <paragraph role="heading" id="par_id4077578" xml-lang="en-US" level="3">Treat empty string as zero</paragraph>
+ <h3 id="par_id4077578">Treat empty string as zero</h3>
<paragraph role="paragraph" id="par_id9094515" xml-lang="en-US">This option determines how an empty string is treated when used in arithmetic operations. If you have set "Conversion from text to number" to either "Generate #VALUE! error" or "Treat as zero", you cannot choose (here) if conversion of an empty string to a number will generate an error or if it will treat empty strings as zero. Otherwise this option determines how empty strings are treated.</paragraph>
- <paragraph role="heading" id="par_id3859675" xml-lang="en-US" level="3">Reference syntax for string reference</paragraph>
+ <h3 id="par_id3859675">Reference syntax for string reference</h3>
<paragraph role="paragraph" id="par_id402233" xml-lang="en-US">Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value.</paragraph>
<list type="unordered">
<listitem>
@@ -65,7 +64,7 @@
<paragraph role="listitem" id="par_id9534592" xml-lang="en-US"><emph>Excel R1C1</emph></paragraph>
</listitem>
<listitem>
- <paragraph id="par_id811567770857290" role="listitem"><emph>Calc A1 | Excel A1</emph></paragraph>
+ <paragraph id="par_id811567770857290" role="listitem"><emph>Calc A1 | Excel A1</emph></paragraph>
</listitem>
</list>
<section id="relatedtopics">