source/text/scalc/01/04060101.xhp | 34 ++--
source/text/scalc/01/04060106.xhp | 163 +++++++++-----------
source/text/scalc/01/04060110.xhp | 83 +++++-----
source/text/scalc/01/04060181.xhp | 62 +++----
source/text/scalc/01/ex_data_stat_func.xhp | 10 -
source/text/scalc/01/func_averageif.xhp | 23 +-
source/text/scalc/01/func_averageifs.xhp | 15 -
source/text/scalc/01/func_countifs.xhp | 19 +-
source/text/scalc/01/func_maxifs.xhp | 13 -
source/text/scalc/01/func_minifs.xhp | 13 -
source/text/scalc/01/func_sumifs.xhp | 17 +-
source/text/scalc/guide/numbers_text.xhp | 7
source/text/shared/00/00000001.xhp | 69 ++++----
source/text/shared/optionen/01060500.xhp | 58 +++----
source/text/shared/optionen/detailedcalculation.xhp | 13 -
15 files changed, 303 insertions(+), 296 deletions(-)
New commits:
commit 6f107ecda99e339d61517de33c0d452c18dfac3e
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Nov 5 15:59:20 2019 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Nov 8 19:41:06 2019 +0100
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 <er...@redhat.com>
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060101.xhp
b/source/text/scalc/01/04060101.xhp
index 39630fea8..8e1e7505f 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 7e42bdcb5..5247d7b8a 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 φ = 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-->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-->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;"<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 >=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 31722b8cf..664d23885 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 bc016f6fc..a2ebfd480 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"/>
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
