summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/01/04060106.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-05 15:59:20 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-08 19:41:06 +0100
commit6f107ecda99e339d61517de33c0d452c18dfac3e (patch)
tree4728eb7f654a925718c21e2b1d1c57199b21e865 /source/text/scalc/01/04060106.xhp
parentFix missing %PRODUCTNAME replacements (diff)
downloadhelp-6f107ecda99e339d61517de33c0d452c18dfac3e.tar.gz
help-6f107ecda99e339d61517de33c0d452c18dfac3e.zip
tdf#128503 Clarify numeric x regex conversion
+ refactoring headings Patch set 2 - reposition comment on regex vs. numberex - included in ref for regex, aka "regulaer" and available for all functions with search criteria - Rephrased regexnumex. Patch set 3 -Fix to comply w/ DTD Change-Id: I3f5a488bb05b5ea61709e574ca5d859634158bc4 Reviewed-on: https://gerrit.libreoffice.org/82094 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060106.xhp')
-rw-r--r--source/text/scalc/01/04060106.xhp163
1 files changed, 81 insertions, 82 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 7e42bdcb5b..5247d7b8a0 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -35,7 +35,7 @@
</bookmark>
-<paragraph id="hd_id3147124" role="heading" level="1" xml-lang="en-US">Mathematical Functions</paragraph>
+<h1 id="hd_id3147124">Mathematical Functions</h1>
<paragraph id="par_id3154943" role="paragraph" xml-lang="en-US"><variable id="mathematiktext">This category contains the <emph>Mathematical</emph> functions for Calc.</variable> To open the <emph>Function Wizard</emph>, choose <link href="text/scalc/01/04060000.xhp" name="Insert - Function"><emph>Insert - Function</emph></link>.</paragraph>
<sort>
@@ -48,7 +48,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/>
-<paragraph id="hd_id3146944" role="heading" level="2" xml-lang="en-US">ABS</paragraph>
+<h2 id="hd_id3146944">ABS</h2>
<paragraph id="par_id3154546" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABS">Returns the absolute value of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -68,7 +68,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/>
-<paragraph id="hd_id3153114" role="heading" level="2" xml-lang="en-US">ACOS</paragraph>
+<h2 id="hd_id3153114">ACOS</h2>
<paragraph id="par_id3145163" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -89,7 +89,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOSHYP" id="bm_id3148386" localize="false"/>
-<paragraph id="hd_id3145355" role="heading" level="2" xml-lang="en-US">ACOSH</paragraph>
+<h2 id="hd_id3145355">ACOSH</h2>
<paragraph id="par_id3157993" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOSHYP">Returns the inverse hyperbolic cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -110,7 +110,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOT" id="bm_id3154634" localize="false"/>
-<paragraph id="hd_id3149027" role="heading" level="2" xml-lang="en-US">ACOT</paragraph>
+<h2 id="hd_id3149027">ACOT</h2>
<paragraph id="par_id3155818" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOT">Returns the inverse cotangent (the arccotangent) of the given number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -131,7 +131,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOTHYP" id="bm_id3149777" localize="false"/>
-<paragraph id="hd_id3148426" role="heading" level="2" xml-lang="en-US">ACOTH</paragraph>
+<h2 id="hd_id3148426">ACOTH</h2>
<paragraph id="par_id3147478" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOTHYP">Returns the inverse hyperbolic cotangent of the given number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -146,7 +146,7 @@
<section id="aggregate">
-<paragraph id="hd_id3145084" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_head"/></paragraph>
+<h2 id="hd_id7145084" localize="false"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_head"/></h2>
<paragraph id="par_id323373151810412" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_aggregate.xhp#aggregate_des"/></paragraph>
</section>
@@ -157,7 +157,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
-<paragraph id="hd_id3145084" role="heading" level="2" xml-lang="en-US">ASIN</paragraph>
+<h2 id="hd_id3145084">ASIN</h2>
<paragraph id="par_id3156296" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -179,7 +179,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/>
-<paragraph id="hd_id3151266" role="heading" level="2" xml-lang="en-US">ASINH</paragraph>
+<h2 id="hd_id3151266">ASINH</h2>
<paragraph id="par_id3147077" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -199,7 +199,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/>
-<paragraph id="hd_id3155996" role="heading" level="2" xml-lang="en-US">ATAN</paragraph>
+<h2 id="hd_id3155996">ATAN</h2>
<paragraph id="par_id3149985" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -220,7 +220,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
-<paragraph id="hd_id3153983" role="heading" level="2" xml-lang="en-US">ATAN2</paragraph>
+<h2 id="hd_id3153983">ATAN2</h2>
<paragraph id="par_id3154297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN2">Returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY).</ahelp></paragraph>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -238,7 +238,7 @@
<note id="par_id5036167">%PRODUCTNAME results 0 for ATAN2(0;0).</note>
<paragraph id="par_id5036169" role="paragraph" xml-lang="en-US">The function can be used in converting cartesian coordinates to polar coordinates.</paragraph>
-<paragraph id="par_id5036170" role="paragraph" xml-lang="en-US">=DEGREES(ATAN2(-8;5)) returns &#966; = 147.9 degrees</paragraph>
+<paragraph id="par_id5036170" role="paragraph" xml-lang="en-US">=DEGREES(ATAN2(-8;5)) returns φ = 147.9 degrees</paragraph>
<paragraph role="paragraph" id="par_id5036171" xml-lang="en-US">
<image id="img_id3150758" src="media/helpimg/scalc/coordinates-to-polar-01.svg" width="2.5inch" height="1.5inch"><alt id="alt_id3150758" xml-lang="en-US">Cartesian coordinates to polar coordinates example</alt></image>
</paragraph>
@@ -252,7 +252,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARTANHYP" id="bm_id3154939" localize="false"/>
-<paragraph id="hd_id3155398" role="heading" level="2" xml-lang="en-US">ATANH</paragraph>
+<h2 id="hd_id3155398">ATANH</h2>
<paragraph id="par_id3148829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARTANHYP">Returns the inverse hyperbolic tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -272,7 +272,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/>
-<paragraph id="hd_id3153062" role="heading" level="2" xml-lang="en-US">COS</paragraph>
+<h2 id="hd_id3153062">COS</h2>
<paragraph id="par_id3148803" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COS">Returns the cosine of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -293,7 +293,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/>
-<paragraph id="hd_id3154277" role="heading" level="2" xml-lang="en-US">COSH</paragraph>
+<h2 id="hd_id3154277">COSH</h2>
<paragraph id="par_id3146946" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -312,7 +312,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/>
-<paragraph id="hd_id3152888" role="heading" level="2" xml-lang="en-US">COT</paragraph>
+<h2 id="hd_id3152888">COT</h2>
<paragraph id="par_id3153679" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COT">Returns the cotangent of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -321,7 +321,7 @@
<paragraph id="par_id3444624" role="paragraph" xml-lang="en-US">To return the cotangent of an angle in degrees, use the RADIANS function.</paragraph>
<paragraph id="par_id6814477" role="paragraph" xml-lang="en-US">The cotangent of an angle is equivalent to 1 divided by the tangent of that angle.</paragraph>
-<paragraph id="hd_id3149800" role="heading" level="3" xml-lang="en-US">Examples:</paragraph>
+<h3 id="hd_id3149800">Examples:</h3>
<paragraph id="par_id3148616" role="paragraph" xml-lang="en-US"><item type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4 radians.</paragraph>
<paragraph id="par_id3148986" role="paragraph" xml-lang="en-US"><item type="input">=COT(RADIANS(45))</item> returns 1, the cotangent of 45 degrees.</paragraph><comment>see also COS, SIN, TAN, ACOS, ASIN, ATAN, ATAN2, ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
@@ -334,7 +334,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/>
-<paragraph id="hd_id3154337" role="heading" level="2" xml-lang="en-US">COTH</paragraph>
+<h2 id="hd_id3154337">COTH</h2>
<paragraph id="par_id3149419" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COTHYP">Returns the hyperbolic cotangent of a given number (angle).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -353,7 +353,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANT" id="bm_id5645316" localize="false"/>
-<paragraph id="hd_id9523234" role="heading" level="2" xml-lang="en-US">CSC</paragraph>
+<h2 id="hd_id9523234">CSC</h2>
<paragraph id="par_id4896433" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -374,7 +374,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANTHYP" id="bm_id9532490" localize="false"/>
-<paragraph id="hd_id4325650" role="heading" level="2" xml-lang="en-US">CSCH</paragraph>
+<h2 id="hd_id4325650">CSCH</h2>
<paragraph id="par_id579916" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a number.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -394,7 +394,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/>
-<paragraph id="hd_id3145314" role="heading" level="2" xml-lang="en-US">DEGREES</paragraph>
+<h2 id="hd_id3145314">DEGREES</h2>
<paragraph id="par_id3149939" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -412,7 +412,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
-<paragraph id="hd_id3148698" role="heading" level="2" xml-lang="en-US">EXP</paragraph>
+<h2 id="hd_id3148698">EXP</h2>
<paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -431,7 +431,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/>
-<paragraph id="hd_id3145781" role="heading" level="2" xml-lang="en-US">FACT</paragraph>
+<h2 id="hd_id3145781">FACT</h2>
<paragraph id="par_id3151109" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -454,7 +454,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/>
-<paragraph id="hd_id3159084" role="heading" level="2" xml-lang="en-US">INT</paragraph>
+<h2 id="hd_id3159084">INT</h2>
<paragraph id="par_id3158441" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -476,7 +476,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
-<paragraph id="hd_id3150938" role="heading" level="2" xml-lang="en-US">EVEN</paragraph>
+<h2 id="hd_id3150938">EVEN</h2>
<paragraph id="par_id3149988" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the next even integer and a negative number down to the next even integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -498,7 +498,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/>
-<paragraph id="hd_id3147356" role="heading" level="2" xml-lang="en-US">GCD</paragraph>
+<h2 id="hd_id3147356">GCD</h2>
<paragraph id="par_id3152465" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph>
<paragraph id="par_id2769249" role="paragraph" xml-lang="en-US">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph>
@@ -518,7 +518,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/>
-<paragraph id="hd_id3151221" role="heading" level="2" xml-lang="en-US">GCD_EXCEL2003</paragraph>
+<h2 id="hd_id3151221">GCD_EXCEL2003</h2>
<paragraph id="par_id3153257" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_GCD">The result is the greatest common divisor of a list of numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -539,7 +539,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGV" id="bm_id3145225" localize="false"/>
-<paragraph id="hd_id3145213" role="heading" level="2" xml-lang="en-US">LCM</paragraph>
+<h2 id="hd_id3145213">LCM</h2>
<paragraph id="par_id3146814" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KGV">Returns the least common multiple of one or more integers.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -557,7 +557,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/>
-<paragraph id="hd_id3154230" role="heading" level="2" xml-lang="en-US">LCM_EXCEL2003</paragraph>
+<h2 id="hd_id3154230">LCM_EXCEL2003</h2>
<paragraph id="par_id3149036" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_LCM">The result is the lowest common multiple of a list of numbers.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -577,7 +577,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN" id="bm_id3155077" localize="false"/><comment>should be statistical--&gt;add a link there</comment>
-<paragraph id="hd_id3155802" role="heading" level="2" xml-lang="en-US">COMBIN</paragraph>
+<h2 id="hd_id3155802">COMBIN</h2>
<paragraph id="par_id3156172" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN">Returns the number of combinations for elements without repetition.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -599,7 +599,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN2" id="bm_id3150295" localize="false"/><comment>should be statistical--&gt;add a link there</comment>
-<paragraph id="hd_id3150284" role="heading" level="2" xml-lang="en-US">COMBINA</paragraph>
+<h2 id="hd_id3150284">COMBINA</h2>
<paragraph id="par_id3157894" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN2">Returns the number of combinations of a subset of items including repetitions.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -621,15 +621,15 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KUERZEN" id="bm_id3157849" localize="false"/>
-<paragraph id="hd_id3156086" role="heading" level="2" xml-lang="en-US">TRUNC</paragraph>
+<h2 id="hd_id3156086">TRUNC</h2>
<paragraph id="par_id3157866" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number; Count)</paragraph>
<paragraph id="par_id3150796" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign.</paragraph>
<paragraph id="par_id3150816" role="paragraph" xml-lang="en-US"><item type="literal">TRUNC(Number; 0)</item> behaves as <item type="literal">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers.</paragraph>
-<paragraph id="par_id3148548" role="warning" xml-lang="en-US">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
-</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</paragraph>
+<warning id="par_id3148548">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
+</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3152569" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost.</paragraph>
@@ -644,7 +644,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LN" id="bm_id3153613" localize="false"/>
-<paragraph id="hd_id3153601" role="heading" level="2" xml-lang="en-US">LN</paragraph>
+<h2 id="hd_id3153601">LN</h2>
<paragraph id="par_id3154974" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LN">Returns the natural logarithm based on the constant e of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -664,7 +664,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG" id="bm_id3109824" localize="false"/>
-<paragraph id="hd_id3109813" role="heading" level="2" xml-lang="en-US">LOG</paragraph>
+<h2 id="hd_id3109813">LOG</h2>
<paragraph id="par_id3109841" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified base.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -685,7 +685,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG10" id="bm_id3155460" localize="false"/>
-<paragraph id="hd_id3154187" role="heading" level="2" xml-lang="en-US">LOG10</paragraph>
+<h2 id="hd_id3154187">LOG10</h2>
<paragraph id="par_id3155476" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG10">Returns the base-10 logarithm of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -704,7 +704,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/>
-<paragraph id="hd_id3152518" role="heading" level="2" xml-lang="en-US">CEILING</paragraph>
+<h2 id="hd_id3152518">CEILING</h2>
<paragraph id="par_id3153422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -712,7 +712,7 @@
<paragraph id="par_id3153467" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph>
<paragraph id="par_id3155000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
<paragraph id="par_id3155020" role="paragraph" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph>
-<paragraph id="par_id3163792" role="warning" xml-lang="en-US">If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.</paragraph>
+<warning id="par_id3163792">If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3145710" role="paragraph" xml-lang="en-US"><item type="input">=CEILING(-11;-2)</item> returns -10</paragraph>
@@ -728,7 +728,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id2952530" localize="false"/>
-<paragraph id="hd_id2952518" role="heading" level="2" xml-lang="en-US">CEILING.PRECISE</paragraph>
+<h2 id="hd_id2952518">CEILING.PRECISE</h2>
<paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -745,14 +745,14 @@
<bookmark_value>CEILING.MATH function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MATH" id="bm_id511516997249645" localize="false"/>
- <paragraph role="heading" id="hd_id91516997330445" level="2" xml-lang="en-US">CEILING.MATH</paragraph>
+ <h2 id="hd_id91516997330445">CEILING.MATH</h2>
<paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id841516997669932" xml-lang="en-US">CEILING.MATH(Number; Significance; Mode)</paragraph>
<paragraph role="paragraph" id="par_id651516997706287" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph>
<paragraph role="paragraph" id="par_id491516997725772" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
<paragraph role="paragraph" id="par_id451516997742909" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph>
- <paragraph xml-lang="en-US" id="par_id291516998575663" role="warning">This function exists for interoperability with Microsoft Excel 2013 or newer.</paragraph>
+ <warning id="par_id291516998575663">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id111516997803684" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3)</item> returns -9</paragraph>
<paragraph role="paragraph" id="par_id1001516997821483" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3;0)</item> returns -9</paragraph>
@@ -763,14 +763,14 @@
<bookmark_value>CEILING.XCL function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id221516998652517" localize="false"/>
- <paragraph role="heading" id="hd_id411516998838823" level="2" xml-lang="en-US">CEILING.XCL</paragraph>
+ <h2 id="hd_id411516998838823">CEILING.XCL</h2>
<paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number away from zero to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#5.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph>
<paragraph role="paragraph" id="par_id671516998874263" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded.</paragraph>
<paragraph role="paragraph" id="par_id151516998882622" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded.</paragraph>
- <paragraph xml-lang="en-US" id="par_id341516998889754" role="warning">This function exists for interoperability with Microsoft Excel 2007 or older versions.</paragraph>
+ <warning id="par_id341516998889754">This function exists for interoperability with Microsoft Excel 2007 or older versions.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id91516998917254" xml-lang="en-US"><item type="input">=CEILING.XCL(1;3)</item> returns 3</paragraph>
<paragraph role="paragraph" id="par_id761516998929693" xml-lang="en-US"><item type="input">=CEILING.XCL(7;4)</item> returns 8</paragraph>
@@ -784,7 +784,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_ISO" id="bm_id8952530" localize="false"/>
-<paragraph id="hd_id8952518" role="heading" level="2" xml-lang="en-US">ISO.CEILING</paragraph>
+<h2 id="hd_id8952518">ISO.CEILING</h2>
<paragraph id="par_id8953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -803,7 +803,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PI" id="bm_id3157774" localize="false"/>
-<paragraph id="hd_id3157762" role="heading" level="2" xml-lang="en-US">PI</paragraph>
+<h2 id="hd_id3157762">PI</h2>
<paragraph id="par_id3157790" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PI">Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -820,7 +820,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429" localize="false"/>
-<paragraph id="hd_id3152418" role="heading" level="2" xml-lang="en-US">MULTINOMIAL</paragraph>
+<h2 id="hd_id3152418">MULTINOMIAL</h2>
<paragraph id="par_id3152454" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MULTINOMIAL">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -838,7 +838,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/>
-<paragraph id="hd_id3155717" role="heading" level="2" xml-lang="en-US">POWER</paragraph>
+<h2 id="hd_id3155717">POWER</h2>
<paragraph id="par_id3159495" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to another number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -859,7 +859,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SERIESSUM" id="bm_id3152662" localize="false"/>
-<paragraph id="hd_id3152651" role="heading" level="2" xml-lang="en-US">SERIESSUM</paragraph>
+<h2 id="hd_id3152651">SERIESSUM</h2>
<paragraph id="par_id3152688" role="paragraph" xml-lang="en-US"><ahelp hid=".">Sums the first terms of a power series.</ahelp></paragraph>
<paragraph id="par_id3152708" role="paragraph" xml-lang="en-US">SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)</paragraph>
@@ -880,7 +880,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/>
-<paragraph id="hd_id3144386" role="heading" level="2" xml-lang="en-US">PRODUCT</paragraph>
+<h2 id="hd_id3144386">PRODUCT</h2>
<paragraph id="par_id3144414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PRODUKT">Multiplies all the numbers given as arguments and returns the product.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -901,7 +901,7 @@
<comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUADRATESUMME" id="bm_id3160351" localize="false"/>
-<paragraph id="hd_id3160340" role="heading" level="2" xml-lang="en-US">SUMSQ</paragraph>
+<h2 id="hd_id3160340">SUMSQ</h2>
<paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_QUADRATESUMME">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -920,7 +920,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_REST" id="bm_id3158259" localize="false"/>
-<paragraph id="hd_id3158247" role="heading" level="2" xml-lang="en-US">MOD</paragraph>
+<h2 id="hd_id3158247">MOD</h2>
<paragraph id="par_id3158276" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_REST">Returns the remainder when one integer is divided by another.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -941,7 +941,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_QUOTIENT" id="bm_id3144603" localize="false"/>
-<paragraph id="hd_id3144592" role="heading" level="2" xml-lang="en-US">QUOTIENT</paragraph>
+<h2 id="hd_id3144592">QUOTIENT</h2>
<paragraph id="par_id3144627" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer part of a division operation.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -961,7 +961,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAD" id="bm_id3158008" localize="false"/>
-<paragraph id="hd_id3144702" role="heading" level="2" xml-lang="en-US">RADIANS</paragraph>
+<h2 id="hd_id3144702">RADIANS</h2>
<paragraph id="par_id3158025" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RAD">Converts degrees to radians.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -983,7 +983,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/>
-<paragraph id="hd_id3158121" role="heading" level="2" xml-lang="en-US">ROUND</paragraph>
+<h2 id="hd_id3158121">ROUND</h2>
<paragraph id="par_id3158150" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1006,7 +1006,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABRUNDEN" id="bm_id3146003" localize="false"/>
-<paragraph id="hd_id3145991" role="heading" level="2" xml-lang="en-US">ROUNDDOWN</paragraph>
+<h2 id="hd_id3145991">ROUNDDOWN</h2>
<paragraph id="par_id3146020" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1028,7 +1028,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AUFRUNDEN" id="bm_id3163280" localize="false"/>
-<paragraph id="hd_id3163268" role="heading" level="2" xml-lang="en-US">ROUNDUP</paragraph>
+<h2 id="hd_id3163268">ROUNDUP</h2>
<paragraph id="par_id3163297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1051,7 +1051,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANT" id="bm_id6577644" localize="false"/>
-<paragraph id="hd_id5187204" role="heading" level="2" xml-lang="en-US">SEC</paragraph>
+<h2 id="hd_id5187204">SEC</h2>
<paragraph id="par_id9954962" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1072,7 +1072,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANTHYP" id="bm_id6301347" localize="false"/>
-<paragraph id="hd_id8661934" role="heading" level="2" xml-lang="en-US">SECH</paragraph>
+<h2 id="hd_id8661934">SECH</h2>
<paragraph id="par_id408174" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a number.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1091,7 +1091,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SIN" id="bm_id3144889" localize="false"/>
-<paragraph id="hd_id3144877" role="heading" level="2" xml-lang="en-US">SIN</paragraph>
+<h2 id="hd_id3144877">SIN</h2>
<paragraph id="par_id3144906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SIN">Returns the sine of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1112,7 +1112,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SINHYP" id="bm_id3163409" localize="false"/>
-<paragraph id="hd_id3163397" role="heading" level="2" xml-lang="en-US">SINH</paragraph>
+<h2 id="hd_id3163397">SINH</h2>
<paragraph id="par_id3163426" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SINHYP">Returns the hyperbolic sine of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1132,7 +1132,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/>
-<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></paragraph>
+<h2 id="hd_id3163596"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></h2>
<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1160,16 +1160,15 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/>
-<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></paragraph>
+<h2 id="hd_id3151957"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></h2>
<paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criteria; SumRange)</paragraph>
<paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph>
<paragraph id="par_id3152062" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes.</paragraph>
<paragraph id="par_id3152083" role="paragraph" xml-lang="en-US"><emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.</paragraph>
-<paragraph id="par_id8347422" role="note" xml-lang="en-US">SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph>
+<note id="par_id8347422">SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</note>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3152148" role="paragraph" xml-lang="en-US">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"&lt;0")</item></paragraph>
@@ -1183,7 +1182,7 @@
<section id="sumifs">
-<paragraph id="hd_id72921259523046" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></paragraph>
+<h2 id="hd_id72921259523046"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></h2>
<paragraph id="par_id131512822630259" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_des"/></paragraph>
</section>
@@ -1194,7 +1193,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/>
-<paragraph id="hd_id3152195" role="heading" level="2" xml-lang="en-US">TAN</paragraph>
+<h2 id="hd_id3152195">TAN</h2>
<paragraph id="par_id3152224" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1215,7 +1214,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TANHYP" id="bm_id3165446" localize="false"/>
-<paragraph id="hd_id3165434" role="heading" level="2" xml-lang="en-US">TANH</paragraph>
+<h2 id="hd_id3165434">TANH</h2>
<paragraph id="par_id3165462" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TANHYP">Returns the hyperbolic tangent of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1237,7 +1236,7 @@
<comment>mw made "sums..." a two level entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEILERGEBNIS" id="bm_id3165644" localize="false"/>
-<paragraph id="hd_id3165633" role="heading" level="2" xml-lang="en-US">SUBTOTAL</paragraph>
+<h2 id="hd_id3165633">SUBTOTAL</h2>
<paragraph id="par_id3165682" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEILERGEBNIS">Calculates subtotals.</ahelp> If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1480,7 +1479,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EUROCONVERT" id="bm_id0119200904282677" localize="false"/>
-<paragraph id="hd_id3143672" role="heading" level="2" xml-lang="en-US">EUROCONVERT<comment>insert link in financial</comment></paragraph>
+<h2 id="hd_id3143672">EUROCONVERT<comment>insert link in financial</comment></h2>
<paragraph id="par_id3143708" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to and from Euros.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1490,7 +1489,7 @@
<paragraph id="par_id0119200904301810" role="paragraph" xml-lang="en-US"><emph>Full_precision</emph> is optional. If omitted or False, the result is rounded according to the decimals of the To currency. If Full_precision is True, the result is not rounded.</paragraph>
<paragraph id="par_id0119200904301815" role="paragraph" xml-lang="en-US"><emph>Triangulation_precision</emph> is optional. If Triangulation_precision is given and &gt;=3, the intermediate result of a triangular conversion (currency1,EUR,currency2) is rounded to that precision. If Triangulation_precision is omitted, the intermediate result is not rounded. Also if To currency is "EUR", Triangulation_precision is used as if triangulation was needed and conversion from EUR to EUR was applied.</paragraph>
-<paragraph id="par_id3143819" role="heading" level="3" xml-lang="en-US"><emph>Examples</emph></paragraph>
+<h3 id="par_id3143819"><emph>Examples</emph></h3>
<paragraph id="par_id3143837" role="paragraph" xml-lang="en-US"><item type="input">=EUROCONVERT(100;"ATS";"EUR")</item> converts 100 Austrian Schillings into Euros.</paragraph>
<paragraph id="par_id3143853" role="paragraph" xml-lang="en-US"><item type="input">=EUROCONVERT(100;"EUR";"DEM")</item> converts 100 Euros into German Marks.</paragraph>
</section>
@@ -1502,7 +1501,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id0908200902093111" localize="false"/>
-<paragraph id="hd_id0908200902074836" role="heading" level="2" xml-lang="en-US">CONVERT_OOO</paragraph>
+<h2 id="hd_id0908200902074836">CONVERT_OOO</h2>
<paragraph id="par_id0908200902131122" role="paragraph" xml-lang="en-US"><ahelp hid=".">Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.</ahelp></paragraph>
<paragraph id="par_id0908200902475420" role="paragraph" xml-lang="en-US">At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies.</paragraph>
@@ -1522,7 +1521,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNGERADE" id="bm_id3157188" localize="false"/>
-<paragraph id="hd_id3157177" role="heading" level="2" xml-lang="en-US">ODD</paragraph>
+<h2 id="hd_id3157177">ODD</h2>
<paragraph id="par_id3157205" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNGERADE">Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1544,7 +1543,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MS" id="bm_id2957415" localize="false"/>
-<paragraph id="hd_id2957404" role="heading" level="2" xml-lang="en-US">FLOOR.PRECISE</paragraph>
+<h2 id="hd_id2957404">FLOOR.PRECISE</h2>
<paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1564,7 +1563,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/>
-<paragraph id="hd_id3157404" role="heading" level="2" xml-lang="en-US">FLOOR</paragraph>
+<h2 id="hd_id3157404">FLOOR</h2>
<paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1572,7 +1571,7 @@
<paragraph id="par_id3157478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph>
<paragraph id="par_id3157497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph>
<paragraph id="par_id3157517" role="paragraph" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.</paragraph>
-<paragraph id="par_id3163894" role="warning" xml-lang="en-US">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</paragraph>
+<warning id="par_id3163894">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2)</item> returns -12</paragraph>
@@ -1588,7 +1587,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORZEICHEN" id="bm_id3164098" localize="false"/>
-<paragraph id="hd_id3164086" role="heading" level="2" xml-lang="en-US">SIGN</paragraph>
+<h2 id="hd_id3164086">SIGN</h2>
<paragraph id="par_id3164115" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VORZEICHEN">Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1608,7 +1607,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MROUND" id="bm_id3164264" localize="false"/>
-<paragraph id="hd_id3164252" role="heading" level="2" xml-lang="en-US">MROUND</paragraph>
+<h2 id="hd_id3164252">MROUND</h2>
<paragraph id="par_id3164288" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MROUND">Returns a number rounded to the nearest multiple of another number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1629,7 +1628,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WURZEL" id="bm_id3164387" localize="false"/>
-<paragraph id="hd_id3164375" role="heading" level="2" xml-lang="en-US">SQRT</paragraph>
+<h2 id="hd_id3164375">SQRT</h2>
<paragraph id="par_id3164404" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WURZEL">Returns the positive square root of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1650,7 +1649,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SQRTPI" id="bm_id3164572" localize="false"/>
-<paragraph id="hd_id3164560" role="heading" level="2" xml-lang="en-US">SQRTPI</paragraph>
+<h2 id="hd_id3164560">SQRTPI</h2>
<paragraph id="par_id3164596" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_SQRTPI">Returns the square root of (PI times a number).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1670,7 +1669,7 @@
<comment>mw changed "random numbers;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_RANDBETWEEN" id="bm_id3164680" localize="false"/>
-<paragraph id="hd_id3164669" role="heading" level="2" xml-lang="en-US">RANDBETWEEN</paragraph>
+<h2 id="hd_id3164669">RANDBETWEEN</h2>
<paragraph id="par_id3164711" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -1691,7 +1690,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZUFALLSZAHL" id="bm_id3164812" localize="false"/>
-<paragraph id="hd_id3164800" role="heading" level="2" xml-lang="en-US">RAND</paragraph>
+<h2 id="hd_id3164800">RAND</h2>
<paragraph id="par_id3164829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp><comment>The value of 0 can be returned, the value of 1 not.</comment><comment>this is really true after issue 53642 will be fixed</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>