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>

11 files changed, 227 insertions, 225 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>