source/text/scalc/01/04060106.xhp | 1012 ++++++++++++++++----------------
source/text/scalc/01/func_randarray.xhp | 1
2 files changed, 507 insertions(+), 506 deletions(-)
New commits:
commit 1b06c45742f070d204183a7e24ccb5e2386d59a7
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu May 16 10:19:57 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu May 16 15:22:18 2024 +0200
tdf#159872 Link RAND* to RANDARRAY function
+ refactor
Change-Id: I54fdfca2d15f0ddca0e36a9513da011896e886cf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167743
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index e10a68ae61..3cd61a4c23 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -20,14 +20,14 @@
<meta>
<topic id="textscalc0104060106xml" indexer="include">
- <title id="tit" xml-lang="en-US">Mathematical Functions</title>
+ <title id="tit">Mathematical Functions</title>
<filename>/text/scalc/01/04060106.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3147124">
+<bookmark branch="index" id="bm_id3147124">
<bookmark_value>mathematical functions</bookmark_value>
<bookmark_value>Function Wizard; mathematical</bookmark_value>
<bookmark_value>functions; mathematical functions</bookmark_value>
@@ -36,574 +36,574 @@
<h1 id="hd_id3147124"><variable id="math_functions_h1"><link
href="text/scalc/01/04060106.xhp">Mathematical Functions</link></variable></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"><emph>Insert -
Function</emph></link>.</paragraph>
+<paragraph id="par_id3154943" role="paragraph"><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"><emph>Insert -
Function</emph></link>.</paragraph>
<sort order="asc" descendant="h2">
<section id="Section1">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3146944">
+<bookmark branch="index" id="bm_id3146944">
<bookmark_value>ABS function</bookmark_value>
<bookmark_value>absolute values</bookmark_value>
<bookmark_value>values;absolute</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/>
<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>
+<paragraph id="par_id3154546" role="paragraph"><ahelp
hid="HID_FUNC_ABS">Returns the absolute value of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3147475" role="code"
xml-lang="en-US">ABS(Number)</paragraph>
-<paragraph id="par_id3148438" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number whose absolute value is to
be calculated. The absolute value of a number is its value without the +/-
sign.</paragraph>
+<paragraph id="par_id3147475" role="code">ABS(Number)</paragraph>
+<paragraph id="par_id3148438" role="paragraph"><emph>Number</emph> is the
number whose absolute value is to be calculated. The absolute value of a number
is its value without the +/- sign.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3152787" role="paragraph" xml-lang="en-US"><item
type="input">=ABS(-56)</item> returns 56.</paragraph>
-<paragraph id="par_id3148752" role="paragraph" xml-lang="en-US"><item
type="input">=ABS(12)</item> returns 12.</paragraph>
-<paragraph id="par_id320139" role="paragraph" xml-lang="en-US"><item
type="input">=ABS(0)</item> returns 0.<comment>see also
SIGN</comment></paragraph>
+<paragraph id="par_id3152787" role="paragraph"><item
type="input">=ABS(-56)</item> returns 56.</paragraph>
+<paragraph id="par_id3148752" role="paragraph"><item
type="input">=ABS(12)</item> returns 12.</paragraph>
+<paragraph id="par_id320139" role="paragraph"><item
type="input">=ABS(0)</item> returns 0.<comment>see also
SIGN</comment></paragraph>
</section>
<section id="Section61">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153114">
+<bookmark branch="index" id="bm_id3153114">
<bookmark_value>ACOS function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOS" id="bm_id3155952"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/>
<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>
+<paragraph id="par_id3145163" role="paragraph"><ahelp
hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150020" role="code"
xml-lang="en-US">ACOS(Number)</paragraph>
-<paragraph id="par_id3159134" role="paragraph" xml-lang="en-US">This function
returns the inverse trigonometric cosine of <emph>Number</emph>, that is the
angle (in radians) whose cosine is Number. The angle returned is between 0 and
PI.</paragraph>
-<paragraph id="par_id679647" role="paragraph" xml-lang="en-US">To return the
angle in degrees, use the DEGREES function.</paragraph>
+<paragraph id="par_id3150020" role="code">ACOS(Number)</paragraph>
+<paragraph id="par_id3159134" role="paragraph">This function returns the
inverse trigonometric cosine of <emph>Number</emph>, that is the angle (in
radians) whose cosine is Number. The angle returned is between 0 and
PI.</paragraph>
+<paragraph id="par_id679647" role="paragraph">To return the angle in degrees,
use the DEGREES function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3150128" role="paragraph" xml-lang="en-US"><item
type="input">=ACOS(-1)</item> returns 3.14159265358979 (PI radians)</paragraph>
-<paragraph id="par_id8792382" role="paragraph" xml-lang="en-US"><item
type="input">=DEGREES(ACOS(0.5))</item> returns 60. The cosine of 60 degrees is
0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2,
ACOT</comment>
+<paragraph id="par_id3150128" role="paragraph"><item
type="input">=ACOS(-1)</item> returns 3.14159265358979 (PI radians)</paragraph>
+<paragraph id="par_id8792382" role="paragraph"><item
type="input">=DEGREES(ACOS(0.5))</item> returns 60. The cosine of 60 degrees is
0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2,
ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section60">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145355">
+<bookmark branch="index" id="bm_id3145355">
<bookmark_value>ACOSH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOSHYP" id="bm_id3148386"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCOSHYP" id="bm_id3148386"
localize="false"/>
<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>
+<paragraph id="par_id3157993" role="paragraph"><ahelp
hid="HID_FUNC_ARCOSHYP">Returns the inverse hyperbolic cosine of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3151017" role="code"
xml-lang="en-US">ACOSH(Number)</paragraph>
-<paragraph id="par_id3149000" role="paragraph" xml-lang="en-US">This function
returns the inverse hyperbolic cosine of <emph>Number</emph>, that is the
number whose hyperbolic cosine is Number.</paragraph>
-<paragraph id="par_id6393932" role="paragraph" xml-lang="en-US">Number must be
greater than or equal to 1.</paragraph>
+<paragraph id="par_id3151017" role="code">ACOSH(Number)</paragraph>
+<paragraph id="par_id3149000" role="paragraph">This function returns the
inverse hyperbolic cosine of <emph>Number</emph>, that is the number whose
hyperbolic cosine is Number.</paragraph>
+<paragraph id="par_id6393932" role="paragraph">Number must be greater than or
equal to 1.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3145629" role="paragraph" xml-lang="en-US"><item
type="input">=ACOSH(1)</item> returns 0.</paragraph>
-<paragraph id="par_id951567" role="paragraph" xml-lang="en-US"><item
type="input">=ACOSH(COSH(4))</item> returns 4.</paragraph><comment>see also
ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
+<paragraph id="par_id3145629" role="paragraph"><item
type="input">=ACOSH(1)</item> returns 0.</paragraph>
+<paragraph id="par_id951567" role="paragraph"><item
type="input">=ACOSH(COSH(4))</item> returns 4.</paragraph><comment>see also
ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section59">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3149027">
+<bookmark branch="index" id="bm_id3149027">
<bookmark_value>ACOT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOT" id="bm_id3154634"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCCOT" id="bm_id3154634" localize="false"/>
<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>
+<paragraph id="par_id3155818" role="paragraph"><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"/>
-<paragraph id="par_id3158419" role="code"
xml-lang="en-US">ACOT(Number)</paragraph>
-<paragraph id="par_id3154948" role="paragraph" xml-lang="en-US">This function
returns the inverse trigonometric cotangent of <emph>Number</emph>, that is the
angle (in radians) whose cotangent is Number. The angle returned is between 0
and PI.</paragraph>
-<paragraph id="par_id5834528" role="paragraph" xml-lang="en-US">To return the
angle in degrees, use the DEGREES function.</paragraph>
+<paragraph id="par_id3158419" role="code">ACOT(Number)</paragraph>
+<paragraph id="par_id3154948" role="paragraph">This function returns the
inverse trigonometric cotangent of <emph>Number</emph>, that is the angle (in
radians) whose cotangent is Number. The angle returned is between 0 and
PI.</paragraph>
+<paragraph id="par_id5834528" role="paragraph">To return the angle in degrees,
use the DEGREES function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3155375" role="paragraph" xml-lang="en-US"><item
type="input">=ACOT(1)</item> returns 0.785398163397448 (PI/4
radians).</paragraph>
-<paragraph id="par_id8589434" role="paragraph" xml-lang="en-US"><item
type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45 degrees is
1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN,
ATAN2</comment>
+<paragraph id="par_id3155375" role="paragraph"><item
type="input">=ACOT(1)</item> returns 0.785398163397448 (PI/4
radians).</paragraph>
+<paragraph id="par_id8589434" role="paragraph"><item
type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45 degrees is
1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN,
ATAN2</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section58">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3148426">
+<bookmark branch="index" id="bm_id3148426">
<bookmark_value>ACOTH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOTHYP" id="bm_id3149777"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCOTHYP" id="bm_id3149777"
localize="false"/>
<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>
+<paragraph id="par_id3147478" role="paragraph"><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"/>
-<paragraph id="par_id3147172" role="code"
xml-lang="en-US">ACOTH(Number)</paragraph>
-<paragraph id="par_id3146155" role="paragraph" xml-lang="en-US">This function
returns the inverse hyperbolic cotangent of <emph>Number</emph>, that is the
number whose hyperbolic cotangent is Number.</paragraph>
-<paragraph id="par_id5818659" role="paragraph" xml-lang="en-US">An error
results if Number is between -1 and 1 inclusive.</paragraph>
+<paragraph id="par_id3147172" role="code">ACOTH(Number)</paragraph>
+<paragraph id="par_id3146155" role="paragraph">This function returns the
inverse hyperbolic cotangent of <emph>Number</emph>, that is the number whose
hyperbolic cotangent is Number.</paragraph>
+<paragraph id="par_id5818659" role="paragraph">An error results if Number is
between -1 and 1 inclusive.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3150608" role="paragraph" xml-lang="en-US"><item
type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1,
approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH,
SINH, TANH, COTH</comment>
+<paragraph id="par_id3150608" role="paragraph"><item
type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1,
approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH,
SINH, TANH, COTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="aggregate">
<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>
+<paragraph id="par_id323373151810412" role="paragraph"
localize="false"><embedvar
href="text/scalc/01/func_aggregate.xhp#aggregate_des"/></paragraph>
</section>
<section id="Section57">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145084">
+<bookmark branch="index" id="bm_id3145084">
<bookmark_value>ASIN function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
<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>
+<paragraph id="par_id3156296" role="paragraph"><ahelp
hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3156305" role="code"
xml-lang="en-US">ASIN(Number)</paragraph>
-<paragraph id="par_id3150964" role="paragraph" xml-lang="en-US">This function
returns the inverse trigonometric sine of <emph>Number</emph>, that is the
angle (in radians) whose sine is Number. The angle returned is between -PI/2
and +PI/2.</paragraph>
-<paragraph id="par_id203863" role="paragraph" xml-lang="en-US">To return the
angle in degrees, use the DEGREES function.</paragraph>
+<paragraph id="par_id3156305" role="code">ASIN(Number)</paragraph>
+<paragraph id="par_id3150964" role="paragraph">This function returns the
inverse trigonometric sine of <emph>Number</emph>, that is the angle (in
radians) whose sine is Number. The angle returned is between -PI/2 and
+PI/2.</paragraph>
+<paragraph id="par_id203863" role="paragraph">To return the angle in degrees,
use the DEGREES function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156100" role="paragraph" xml-lang="en-US"><item
type="input">=ASIN(0)</item> returns 0.</paragraph>
-<paragraph id="par_id6853846" role="paragraph" xml-lang="en-US"><item
type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians).</paragraph>
-<paragraph id="par_id8772240" role="paragraph" xml-lang="en-US"><item
type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is
0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2,
ACOT</comment>
+<paragraph id="par_id3156100" role="paragraph"><item
type="input">=ASIN(0)</item> returns 0.</paragraph>
+<paragraph id="par_id6853846" role="paragraph"><item
type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians).</paragraph>
+<paragraph id="par_id8772240" role="paragraph"><item
type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is
0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2,
ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section56">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3151266">
+<bookmark branch="index" id="bm_id3151266">
<bookmark_value>ASINH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206"
localize="false"/>
<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>
+<paragraph id="par_id3147077" role="paragraph"><ahelp
hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150882" role="code"
xml-lang="en-US">ASINH(Number)</paragraph>
-<paragraph id="par_id3147621" role="paragraph" xml-lang="en-US">This function
returns the inverse hyperbolic sine of <emph>Number</emph>, that is the number
whose hyperbolic sine is Number.</paragraph>
+<paragraph id="par_id3150882" role="code">ASINH(Number)</paragraph>
+<paragraph id="par_id3147621" role="paragraph">This function returns the
inverse hyperbolic sine of <emph>Number</emph>, that is the number whose
hyperbolic sine is Number.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156120" role="paragraph" xml-lang="en-US"><item
type="input">=ASINH(-90)</item> returns approximately -5.1929877.</paragraph>
-<paragraph id="par_id4808496" role="paragraph" xml-lang="en-US"><item
type="input">=ASINH(SINH(4))</item> returns 4.</paragraph><comment>see also
ACOSH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
+<paragraph id="par_id3156120" role="paragraph"><item
type="input">=ASINH(-90)</item> returns approximately -5.1929877.</paragraph>
+<paragraph id="par_id4808496" role="paragraph"><item
type="input">=ASINH(SINH(4))</item> returns 4.</paragraph><comment>see also
ACOSH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section55">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3155996">
+<bookmark branch="index" id="bm_id3155996">
<bookmark_value>ATAN function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN" id="bm_id3154743"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/>
<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>
+<paragraph id="par_id3149985" role="paragraph"><ahelp
hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150261" role="code"
xml-lang="en-US">ATAN(Number)</paragraph>
-<paragraph id="par_id3147267" role="paragraph" xml-lang="en-US">This function
returns the inverse trigonometric tangent of <emph>Number</emph>, that is the
angle (in radians) whose tangent is Number. The angle returned is between -PI/2
and PI/2.</paragraph>
-<paragraph id="par_id6293527" role="paragraph" xml-lang="en-US">To return the
angle in degrees, use the DEGREES function.</paragraph>
+<paragraph id="par_id3150261" role="code">ATAN(Number)</paragraph>
+<paragraph id="par_id3147267" role="paragraph">This function returns the
inverse trigonometric tangent of <emph>Number</emph>, that is the angle (in
radians) whose tangent is Number. The angle returned is between -PI/2 and
PI/2.</paragraph>
+<paragraph id="par_id6293527" role="paragraph">To return the angle in degrees,
use the DEGREES function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3143229" role="paragraph" xml-lang="en-US"><item
type="input">=ATAN(1)</item> returns 0.785398163397448 (PI/4
radians).</paragraph>
-<paragraph id="par_id8746299" role="paragraph" xml-lang="en-US"><item
type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is
1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN2,
ACOT</comment>
+<paragraph id="par_id3143229" role="paragraph"><item
type="input">=ATAN(1)</item> returns 0.785398163397448 (PI/4
radians).</paragraph>
+<paragraph id="par_id8746299" role="paragraph"><item
type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is
1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN2,
ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section54">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153983">
+<bookmark branch="index" id="bm_id3153983">
<bookmark_value>ATAN2 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
<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>
+<paragraph id="par_id3154297" role="paragraph"><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"/>
-<paragraph id="par_id3156013" role="code" xml-lang="en-US">ATAN2(NumberX;
NumberY)</paragraph>
-<paragraph id="par_id3001800" role="paragraph"
xml-lang="en-US"><emph>NumberX</emph> is the value of the x
coordinate.</paragraph>
-<paragraph id="par_id3152798" role="paragraph"
xml-lang="en-US"><emph>NumberY</emph> is the value of the y
coordinate.</paragraph>
+<paragraph id="par_id3156013" role="code">ATAN2(NumberX; NumberY)</paragraph>
+<paragraph id="par_id3001800" role="paragraph"><emph>NumberX</emph> is the
value of the x coordinate.</paragraph>
+<paragraph id="par_id3152798" role="paragraph"><emph>NumberY</emph> is the
value of the y coordinate.</paragraph>
<tip id="par_id5036168">Programming languages have usually the opposite order
of arguments for their atan2() function.</tip>
-<paragraph id="par_id5036165" role="paragraph" xml-lang="en-US">ATAN2 returns
the angle (in radians) between the x-axis and a line from the origin to the
point (NumberX|NumberY)</paragraph>
+<paragraph id="par_id5036165" role="paragraph">ATAN2 returns the angle (in
radians) between the x-axis and a line from the origin to the point
(NumberX|NumberY)</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154692" role="paragraph" xml-lang="en-US"><item
type="input">=ATAN2(-5;9)</item> returns 2.07789 radians.</paragraph>
+<paragraph id="par_id3154692" role="paragraph"><item
type="input">=ATAN2(-5;9)</item> returns 2.07789 radians.</paragraph>
-<paragraph id="par_id5036166" role="paragraph" xml-lang="en-US">To get the
angle in degrees apply the DEGREES function to the result.</paragraph>
-<paragraph id="par_id1477095" role="paragraph"
xml-lang="en-US"><input>=DEGREES(ATAN2(12.3;12.3))</input> returns 45. The
tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT,
ACOS, ASIN, ATAN, ACOT</comment>
+<paragraph id="par_id5036166" role="paragraph">To get the angle in degrees
apply the DEGREES function to the result.</paragraph>
+<paragraph id="par_id1477095"
role="paragraph"><input>=DEGREES(ATAN2(12.3;12.3))</input> returns 45. The
tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT,
ACOS, ASIN, ATAN, ACOT</comment>
<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 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 id="par_id5036169" role="paragraph">The function can be used in
converting cartesian coordinates to polar coordinates.</paragraph>
+<paragraph id="par_id5036170" role="paragraph">=DEGREES(ATAN2(-8;5)) returns φ
= 147.9 degrees</paragraph>
+<paragraph role="paragraph" id="par_id5036171">
+<image id="img_id3150758"
src="media/helpimg/scalc/coordinates-to-polar-01.svg" width="2.5inch"
height="1.5inch"><alt id="alt_id3150758">Cartesian coordinates to polar
coordinates example</alt></image>
</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section53">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3155398">
+<bookmark branch="index" id="bm_id3155398">
<bookmark_value>ATANH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARTANHYP" id="bm_id3154939"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_ARTANHYP" id="bm_id3154939"
localize="false"/>
<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>
+<paragraph id="par_id3148829" role="paragraph"><ahelp
hid="HID_FUNC_ARTANHYP">Returns the inverse hyperbolic tangent of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3149912" role="code"
xml-lang="en-US">ATANH(Number)</paragraph>
-<paragraph id="par_id3150521" role="paragraph" xml-lang="en-US">This function
returns the inverse hyperbolic tangent of <emph>Number</emph>, that is the
number whose hyperbolic tangent is Number.</paragraph>
-<paragraph id="par_id9357280" role="paragraph" xml-lang="en-US">Number must
obey the condition -1 < number < 1.</paragraph>
+<paragraph id="par_id3149912" role="code">ATANH(Number)</paragraph>
+<paragraph id="par_id3150521" role="paragraph">This function returns the
inverse hyperbolic tangent of <emph>Number</emph>, that is the number whose
hyperbolic tangent is Number.</paragraph>
+<paragraph id="par_id9357280" role="paragraph">Number must obey the condition
-1 < number < 1.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3145419" role="paragraph" xml-lang="en-US"><item
type="input">=ATANH(0)</item> returns 0.</paragraph><comment>see also ACOSH,
ASINH, ACOTH, COSH, SINH, TANH, COTH</comment>
+<paragraph id="par_id3145419" role="paragraph"><item
type="input">=ATANH(0)</item> returns 0.</paragraph><comment>see also ACOSH,
ASINH, ACOTH, COSH, SINH, TANH, COTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section52">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153062">
+<bookmark branch="index" id="bm_id3153062">
<bookmark_value>COS function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/>
<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>
+<paragraph id="par_id3148803" role="paragraph"><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"/>
-<paragraph id="par_id3154213" role="code"
xml-lang="en-US">COS(Number)</paragraph>
-<paragraph id="par_id3154285" role="paragraph" xml-lang="en-US">Returns the
(trigonometric) cosine of <emph>Number</emph>, the angle in radians.</paragraph>
-<paragraph id="par_id831019" role="paragraph" xml-lang="en-US">To return the
cosine of an angle in degrees, use the RADIANS function.</paragraph>
+<paragraph id="par_id3154213" role="code">COS(Number)</paragraph>
+<paragraph id="par_id3154285" role="paragraph">Returns the (trigonometric)
cosine of <emph>Number</emph>, the angle in radians.</paragraph>
+<paragraph id="par_id831019" role="paragraph">To return the cosine of an angle
in degrees, use the RADIANS function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3147241" role="paragraph" xml-lang="en-US"><item
type="input">=COS(PI()*2)</item> returns 1, the cosine of 2*PI
radians.</paragraph>
-<paragraph id="par_id3147516" role="paragraph" xml-lang="en-US"><item
type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60
degrees.</paragraph><comment>see also SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2,
ACOT</comment>
+<paragraph id="par_id3147241" role="paragraph"><item
type="input">=COS(PI()*2)</item> returns 1, the cosine of 2*PI
radians.</paragraph>
+<paragraph id="par_id3147516" role="paragraph"><item
type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60
degrees.</paragraph><comment>see also SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2,
ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section51">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154277">
+<bookmark branch="index" id="bm_id3154277">
<bookmark_value>COSH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/>
<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>
+<paragraph id="par_id3146946" role="paragraph"><ahelp
hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3166440" role="code"
xml-lang="en-US">COSH(Number)</paragraph>
-<paragraph id="par_id3150710" role="paragraph" xml-lang="en-US">Returns the
hyperbolic cosine of <emph>Number</emph>.</paragraph>
+<paragraph id="par_id3166440" role="code">COSH(Number)</paragraph>
+<paragraph id="par_id3150710" role="paragraph">Returns the hyperbolic cosine
of <emph>Number</emph>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154099" role="paragraph" xml-lang="en-US"><item
type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of
0.</paragraph><comment>see also SINH, TANH, COTH, ACOSH, ASINH, ATANH,
ACOTH</comment>
+<paragraph id="par_id3154099" role="paragraph"><item
type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of
0.</paragraph><comment>see also SINH, TANH, COTH, ACOSH, ASINH, ATANH,
ACOTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section50">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3152888">
+<bookmark branch="index" id="bm_id3152888">
<bookmark_value>COT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/>
<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>
+<paragraph id="par_id3153679" role="paragraph"><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"/>
-<paragraph id="par_id3154856" role="code"
xml-lang="en-US">COT(Number)</paragraph>
-<paragraph id="par_id3149969" role="paragraph" xml-lang="en-US">Returns the
(trigonometric) cotangent of <emph>Number</emph>, the angle in
radians.</paragraph>
-<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="par_id3154856" role="code">COT(Number)</paragraph>
+<paragraph id="par_id3149969" role="paragraph">Returns the (trigonometric)
cotangent of <emph>Number</emph>, the angle in radians.</paragraph>
+<paragraph id="par_id3444624" role="paragraph">To return the cotangent of an
angle in degrees, use the RADIANS function.</paragraph>
+<paragraph id="par_id6814477" role="paragraph">The cotangent of an angle is
equivalent to 1 divided by the tangent of that angle.</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>
+<paragraph id="par_id3148616" role="paragraph"><item
type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4
radians.</paragraph>
+<paragraph id="par_id3148986" role="paragraph"><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"/>
</section>
<section id="Section49">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154337">
+<bookmark branch="index" id="bm_id3154337">
<bookmark_value>COTH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/>
<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>
+<paragraph id="par_id3149419" role="paragraph"><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"/>
-<paragraph id="par_id3143280" role="code"
xml-lang="en-US">COTH(Number)</paragraph>
-<paragraph id="par_id3154799" role="paragraph" xml-lang="en-US">Returns the
hyperbolic cotangent of <emph>Number</emph>.</paragraph>
+<paragraph id="par_id3143280" role="code">COTH(Number)</paragraph>
+<paragraph id="par_id3154799" role="paragraph">Returns the hyperbolic
cotangent of <emph>Number</emph>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3144754" role="paragraph" xml-lang="en-US"><item
type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1,
approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH, ACOSH,
ASINH, ATANH, ACOTH</comment>
+<paragraph id="par_id3144754" role="paragraph"><item
type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1,
approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH, ACOSH,
ASINH, ATANH, ACOTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section64">
-<bookmark xml-lang="en-US" branch="index" id="bm_id6110552">
+<bookmark branch="index" id="bm_id6110552">
<bookmark_value>CSC function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANT" id="bm_id5645316"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COSECANT" id="bm_id5645316"
localize="false"/>
<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>
+<paragraph id="par_id4896433" role="paragraph"><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"/>
-<paragraph id="par_id4571344" role="code"
xml-lang="en-US">CSC(Number)</paragraph>
-<paragraph id="par_id9859164" role="paragraph" xml-lang="en-US">Returns the
(trigonometric) cosecant of <emph>Number</emph>, the angle in
radians.</paragraph>
-<paragraph id="par_id3428494" role="paragraph" xml-lang="en-US">To return the
cosecant of an angle in degrees, use the RADIANS function.</paragraph>
+<paragraph id="par_id4571344" role="code">CSC(Number)</paragraph>
+<paragraph id="par_id9859164" role="paragraph">Returns the (trigonometric)
cosecant of <emph>Number</emph>, the angle in radians.</paragraph>
+<paragraph id="par_id3428494" role="paragraph">To return the cosecant of an
angle in degrees, use the RADIANS function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3736803" role="paragraph" xml-lang="en-US"><item
type="input">=CSC(PI()/4)</item> returns approximately 1.4142135624, the
inverse of the sine of PI/4 radians.</paragraph>
-<paragraph id="par_id6016818" role="paragraph" xml-lang="en-US"><item
type="input">=CSC(RADIANS(30))</item> returns 2, the cosecant of 30
degrees.</paragraph><comment>see also SIN, TAN, COT, SEC, ACOS, ASIN, ATAN,
ATAN2, ACOT</comment>
+<paragraph id="par_id3736803" role="paragraph"><item
type="input">=CSC(PI()/4)</item> returns approximately 1.4142135624, the
inverse of the sine of PI/4 radians.</paragraph>
+<paragraph id="par_id6016818" role="paragraph"><item
type="input">=CSC(RADIANS(30))</item> returns 2, the cosecant of 30
degrees.</paragraph><comment>see also SIN, TAN, COT, SEC, ACOS, ASIN, ATAN,
ATAN2, ACOT</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section66">
-<bookmark xml-lang="en-US" branch="index" id="bm_id9288877">
+<bookmark branch="index" id="bm_id9288877">
<bookmark_value>CSCH function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANTHYP"
id="bm_id9532490" localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_COSECANTHYP" id="bm_id9532490"
localize="false"/>
<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>
+<paragraph id="par_id579916" role="paragraph"><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"/>
-<paragraph id="par_id3108851" role="code"
xml-lang="en-US">CSCH(Number)</paragraph>
-<paragraph id="par_id1394188" role="paragraph" xml-lang="en-US">Returns the
hyperbolic cosecant of <emph>Number</emph>.</paragraph>
+<paragraph id="par_id3108851" role="code">CSCH(Number)</paragraph>
+<paragraph id="par_id1394188" role="paragraph">Returns the hyperbolic cosecant
of <emph>Number</emph>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id5426085" role="paragraph" xml-lang="en-US"><item
type="input">=CSCH(1)</item> returns approximately 0.8509181282, the hyperbolic
cosecant of 1.</paragraph><comment>see also SINH, TANH, COTH, SECH,ACOSH,
ASINH, ATANH, ACOTH</comment>
+<paragraph id="par_id5426085" role="paragraph"><item
type="input">=CSCH(1)</item> returns approximately 0.8509181282, the hyperbolic
cosecant of 1.</paragraph><comment>see also SINH, TANH, COTH, SECH,ACOSH,
ASINH, ATANH, ACOTH</comment>
<embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/>
</section>
<section id="Section48">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145314">
+<bookmark branch="index" id="bm_id3145314">
<bookmark_value>DEGREES function</bookmark_value>
<bookmark_value>converting;radians, into degrees</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/>
<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>
+<paragraph id="par_id3149939" role="paragraph"><ahelp
hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3145600" role="code"
xml-lang="en-US">DEGREES(Number)</paragraph>
-<paragraph id="par_id3149484" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the angle in radians to be converted to
degrees.</paragraph>
+<paragraph id="par_id3145600" role="code">DEGREES(Number)</paragraph>
+<paragraph id="par_id3149484" role="paragraph"><emph>Number</emph> is the
angle in radians to be converted to degrees.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3459578" role="paragraph" xml-lang="en-US"><item
type="input">=DEGREES(PI())</item> returns 180 degrees.</paragraph><comment>see
also RADIANS</comment>
+<paragraph id="par_id3459578" role="paragraph"><item
type="input">=DEGREES(PI())</item> returns 180 degrees.</paragraph><comment>see
also RADIANS</comment>
</section>
<section id="Section47">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3148698">
+<bookmark branch="index" id="bm_id3148698">
<bookmark_value>EXP function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
<h2 id="hd_id3148698">EXP</h2>
-<paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_EXP">Returns <literal>e</literal> raised to the power of a
number.</ahelp> The constant <literal>e</literal> has a value of approximately
2.71828182845904.</paragraph>
+<paragraph id="par_id3150592" role="paragraph"><ahelp
hid="HID_FUNC_EXP">Returns <literal>e</literal> raised to the power of a
number.</ahelp> The constant <literal>e</literal> has a value of approximately
2.71828182845904.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3146786" role="code"
xml-lang="en-US">EXP(Number)</paragraph>
-<paragraph id="par_id3155608" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the power to which e is to be
raised.</paragraph>
+<paragraph id="par_id3146786" role="code">EXP(Number)</paragraph>
+<paragraph id="par_id3155608" role="paragraph"><emph>Number</emph> is the
power to which e is to be raised.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156340" role="paragraph" xml-lang="en-US"><item
type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant
<literal>e</literal> to Calc's accuracy.</paragraph><comment>see also POWER,
LN</comment>
+<paragraph id="par_id3156340" role="paragraph"><item
type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant
<literal>e</literal> to Calc's accuracy.</paragraph><comment>see also POWER,
LN</comment>
</section>
<section id="Section46">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145781">
+<bookmark branch="index" id="bm_id3145781">
<bookmark_value>FACT function</bookmark_value>
<bookmark_value>factorials;numbers</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET"
id="bm_id3153886" localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886"
localize="false"/>
<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>
+<paragraph id="par_id3151109" role="paragraph"><ahelp
hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3154661" role="code"
xml-lang="en-US">FACT(Number)</paragraph>
-<paragraph id="par_id3152952" role="paragraph" xml-lang="en-US">Returns
Number!, the factorial of <emph>Number</emph>, calculated as 1*2*3*4* ... *
Number.</paragraph>
-<paragraph id="par_id3834650" role="paragraph" xml-lang="en-US">=FACT(0)
returns 1 by definition.</paragraph>
-<paragraph id="par_id8429517" role="paragraph" xml-lang="en-US">The factorial
of a negative number returns the "invalid argument" error.</paragraph>
+<paragraph id="par_id3154661" role="code">FACT(Number)</paragraph>
+<paragraph id="par_id3152952" role="paragraph">Returns Number!, the factorial
of <emph>Number</emph>, calculated as 1*2*3*4* ... * Number.</paragraph>
+<paragraph id="par_id3834650" role="paragraph">=FACT(0) returns 1 by
definition.</paragraph>
+<paragraph id="par_id8429517" role="paragraph">The factorial of a negative
number returns the "invalid argument" error.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154476" role="paragraph" xml-lang="en-US"><item
type="input">=FACT(3)</item> returns 6.</paragraph>
-<paragraph id="par_id3147525" role="paragraph" xml-lang="en-US"><item
type="input">=FACT(0)</item> returns 1.</paragraph><comment>see also
FACTDOUBLE, MULTINOMIAL, PRODUCT</comment>
+<paragraph id="par_id3154476" role="paragraph"><item
type="input">=FACT(3)</item> returns 6.</paragraph>
+<paragraph id="par_id3147525" role="paragraph"><item
type="input">=FACT(0)</item> returns 1.</paragraph><comment>see also
FACTDOUBLE, MULTINOMIAL, PRODUCT</comment>
</section>
<section id="Section45">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3159084">
+<bookmark branch="index" id="bm_id3159084">
<bookmark_value>INT function</bookmark_value>
<bookmark_value>numbers;rounding down to next integer</bookmark_value>
<bookmark_value>rounding;down to next integer</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311"
localize="false"/>
<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>
+<paragraph id="par_id3158441" role="paragraph"><ahelp
hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest
integer.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3156146" role="code"
xml-lang="en-US">INT(Number)</paragraph>
-<paragraph id="par_id3154117" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded down to the nearest integer.</paragraph>
-<paragraph id="par_id153508" role="paragraph" xml-lang="en-US">Negative
numbers round down to the integer below.</paragraph>
+<paragraph id="par_id3156146" role="code">INT(Number)</paragraph>
+<paragraph id="par_id3154117" role="paragraph">Returns <emph>Number</emph>
rounded down to the nearest integer.</paragraph>
+<paragraph id="par_id153508" role="paragraph">Negative numbers round down to
the integer below.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3156267" role="paragraph" xml-lang="en-US"><item
type="input">=INT(5.7)</item> returns 5.</paragraph>
-<paragraph id="par_id3147323" role="paragraph" xml-lang="en-US"><item
type="input">=INT(-1.3)</item> returns -2.</paragraph><comment>see also TRUNC,
ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
+<paragraph id="par_id3156267" role="paragraph"><item
type="input">=INT(5.7)</item> returns 5.</paragraph>
+<paragraph id="par_id3147323" role="paragraph"><item
type="input">=INT(-1.3)</item> returns -2.</paragraph><comment>see also TRUNC,
ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
</section>
<section id="Section44">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150938">
+<bookmark branch="index" id="bm_id3150938">
<bookmark_value>EVEN function</bookmark_value>
<bookmark_value>numbers;rounding up/down to even integers</bookmark_value>
<bookmark_value>rounding;up/down to even integers</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
<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>
+<paragraph id="par_id3149988" role="paragraph"><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"/>
-<paragraph id="par_id3150830" role="code"
xml-lang="en-US">EVEN(Number)</paragraph>
-<paragraph id="par_id3153350" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded to the next even integer up, away from
zero.</paragraph>
+<paragraph id="par_id3150830" role="code">EVEN(Number)</paragraph>
+<paragraph id="par_id3153350" role="paragraph">Returns <emph>Number</emph>
rounded to the next even integer up, away from zero.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154361" role="paragraph" xml-lang="en-US"><item
type="input">=EVEN(2.3)</item> returns 4.</paragraph>
-<paragraph id="par_id8477736" role="paragraph" xml-lang="en-US"><item
type="input">=EVEN(2)</item> returns 2.</paragraph>
-<paragraph id="par_id159611" role="paragraph" xml-lang="en-US"><item
type="input">=EVEN(0)</item> returns 0.</paragraph>
-<paragraph id="par_id6097598" role="paragraph" xml-lang="en-US"><item
type="input">=EVEN(-0.5)</item> returns -2.</paragraph><comment>see also
CEILING, FLOOR, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
+<paragraph id="par_id3154361" role="paragraph"><item
type="input">=EVEN(2.3)</item> returns 4.</paragraph>
+<paragraph id="par_id8477736" role="paragraph"><item
type="input">=EVEN(2)</item> returns 2.</paragraph>
+<paragraph id="par_id159611" role="paragraph"><item
type="input">=EVEN(0)</item> returns 0.</paragraph>
+<paragraph id="par_id6097598" role="paragraph"><item
type="input">=EVEN(-0.5)</item> returns -2.</paragraph><comment>see also
CEILING, FLOOR, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
</section>
<section id="Section43">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3147356">
+<bookmark branch="index" id="bm_id3147356">
<bookmark_value>GCD function</bookmark_value>
<bookmark_value>greatest common divisor</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/>
<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>
+<paragraph id="par_id3152465" role="paragraph"><ahelp
hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more
integers.</ahelp></paragraph>
+<paragraph id="par_id2769249" role="paragraph">The greatest common divisor is
the positive largest integer which will divide, without remainder, each of the
given integers.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3154524" role="code" xml-lang="en-US">GCD(<embedvar
href="text/scalc/01/ful_func.xhp#integer255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3154524" role="code">GCD(<embedvar
href="text/scalc/01/ful_func.xhp#integer255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#integer255"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3151285" role="paragraph" xml-lang="en-US"><item
type="input">=GCD(16;32;24) </item>gives the result 8, because 8 is the largest
number that can divide 16, 24 and 32 without a remainder.</paragraph>
-<paragraph id="par_id1604663" role="paragraph" xml-lang="en-US"><item
type="input">=GCD(B1:B3)</item> where cells B1, B2, B3 contain <item
type="input">9</item>, <item type="input">12</item>, <item
type="input">9</item> gives 3.</paragraph>
+<paragraph id="par_id3151285" role="paragraph"><item
type="input">=GCD(16;32;24) </item>gives the result 8, because 8 is the largest
number that can divide 16, 24 and 32 without a remainder.</paragraph>
+<paragraph id="par_id1604663" role="paragraph"><item
type="input">=GCD(B1:B3)</item> where cells B1, B2, B3 contain <item
type="input">9</item>, <item type="input">12</item>, <item
type="input">9</item> gives 3.</paragraph>
</section>
<section id="Section42">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3151221">
+<bookmark branch="index" id="bm_id3151221">
<bookmark_value>GCD_EXCEL2003 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578"
localize="false"/>
+<bookmark branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/>
<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>
+<paragraph id="par_id3153257" role="paragraph"><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"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3156205" role="code"
xml-lang="en-US">GCD_EXCEL2003(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3156205" role="code">GCD_EXCEL2003(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3159192" role="paragraph" xml-lang="en-US"><item
type="input">=GCD_EXCEL2003(5;15;25)</item> returns 5.</paragraph>
+<paragraph id="par_id3159192" role="paragraph"><item
type="input">=GCD_EXCEL2003(5;15;25)</item> returns 5.</paragraph>
</section>
<section id="Section39">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3145213">
+<bookmark branch="index" id="bm_id3145213">
<bookmark_value>LCM function</bookmark_value>
<bookmark_value>least common multiples</bookmark_value>
<bookmark_value>lowest common multiples</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGV" id="bm_id3145225"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_KGV" id="bm_id3145225" localize="false"/>
<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>
+<paragraph id="par_id3146814" role="paragraph"><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"/>
-<paragraph id="par_id3147279" role="code" xml-lang="en-US">LCM(<embedvar
href="text/scalc/01/ful_func.xhp#integer255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3147279" role="code">LCM(<embedvar
href="text/scalc/01/ful_func.xhp#integer255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#integer255"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154914" role="paragraph" xml-lang="en-US">If you enter
the numbers 512; 1024 and 2000 as Integer 1;2 and 3, then 128000 will be
returned.</paragraph>
+<paragraph id="par_id3154914" role="paragraph">If you enter the numbers 512;
1024 and 2000 as Integer 1;2 and 3, then 128000 will be returned.</paragraph>
</section>
<section id="Section38">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154230">
+<bookmark branch="index" id="bm_id3154230">
<bookmark_value>LCM_EXCEL2003 function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222"
localize="false"/>
+<bookmark branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/>
<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>
+<paragraph id="par_id3149036" role="paragraph"><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"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3154395" role="code"
xml-lang="en-US">LCM_EXCEL2003(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3154395" role="code">LCM_EXCEL2003(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3145135" role="paragraph" xml-lang="en-US"><item
type="input">=LCM_EXCEL2003(5;15;25)</item> returns 75.</paragraph>
+<paragraph id="par_id3145135" role="paragraph"><item
type="input">=LCM_EXCEL2003(5;15;25)</item> returns 75.</paragraph>
</section>
<section id="Section37">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3155802">
+<bookmark branch="index" id="bm_id3155802">
<bookmark_value>COMBIN function</bookmark_value>
<bookmark_value>number of combinations</bookmark_value>
</bookmark>
<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>
+<bookmark branch="hid/SC_HID_FUNC_KOMBINATIONEN" id="bm_id3155077"
localize="false"/><comment>should be statistical-->add a link there</comment>
<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>
+<paragraph id="par_id3156172" role="paragraph"><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"/>
-<paragraph id="par_id3150223" role="code" xml-lang="en-US">COMBIN(Count1;
Count2)</paragraph>
-<paragraph id="par_id3150313" role="paragraph"
xml-lang="en-US"><emph>Count1</emph> is the number of items in the
set.</paragraph>
-<paragraph id="par_id3153830" role="paragraph"
xml-lang="en-US"><emph>Count2</emph> is the number of items to choose from the
set.</paragraph>
-<paragraph id="par_id6807458" role="paragraph" xml-lang="en-US">COMBIN returns
the number of ordered ways to choose these items. For example if there are 3
items A, B and C in a set, you can choose 2 items in 3 different ways, namely
AB, AC and BC.</paragraph>
-<paragraph id="par_id7414471" role="paragraph" xml-lang="en-US">COMBIN
implements the formula: Count1!/(Count2!*(Count1-Count2)!)</paragraph>
+<paragraph id="par_id3150223" role="code">COMBIN(Count1; Count2)</paragraph>
+<paragraph id="par_id3150313" role="paragraph"><emph>Count1</emph> is the
number of items in the set.</paragraph>
+<paragraph id="par_id3153830" role="paragraph"><emph>Count2</emph> is the
number of items to choose from the set.</paragraph>
+<paragraph id="par_id6807458" role="paragraph">COMBIN returns the number of
ordered ways to choose these items. For example if there are 3 items A, B and C
in a set, you can choose 2 items in 3 different ways, namely AB, AC and
BC.</paragraph>
+<paragraph id="par_id7414471" role="paragraph">COMBIN implements the formula:
Count1!/(Count2!*(Count1-Count2)!)</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3153517" role="paragraph" xml-lang="en-US"><item
type="input">=COMBIN(3;2)</item> returns 3.</paragraph><comment>see also
COMBINA</comment>
+<paragraph id="par_id3153517" role="paragraph"><item
type="input">=COMBIN(3;2)</item> returns 3.</paragraph><comment>see also
COMBINA</comment>
</section>
<section id="Section36">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150284">
+<bookmark branch="index" id="bm_id3150284">
<bookmark_value>COMBINA function</bookmark_value>
<bookmark_value>number of combinations with repetitions</bookmark_value>
</bookmark>
<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>
+<bookmark branch="hid/SC_HID_FUNC_KOMBINATIONEN2" id="bm_id3150295"
localize="false"/><comment>should be statistical-->add a link there</comment>
<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>
+<paragraph id="par_id3157894" role="paragraph"><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"/>
-<paragraph id="par_id3145765" role="code" xml-lang="en-US">COMBINA(Count1;
Count2)</paragraph>
-<paragraph id="par_id3153372" role="paragraph"
xml-lang="en-US"><emph>Count1</emph> is the number of items in the
set.</paragraph>
-<paragraph id="par_id3155544" role="paragraph"
xml-lang="en-US"><emph>Count2</emph> is the number of items to choose from the
set.</paragraph>
-<paragraph id="par_id1997131" role="paragraph" xml-lang="en-US">COMBINA
returns the number of unique ways to choose these items, where the order of
choosing is irrelevant, and repetition of items is allowed. For example if
there are 3 items A, B and C in a set, you can choose 2 items in 6 different
ways, namely AA, AB, AC, BB, BC and CC.</paragraph>
-<paragraph id="par_id2052064" role="paragraph" xml-lang="en-US">COMBINA
implements the formula: (Count1+Count2-1)! /
(Count2!(Count1-1)!)<comment>i88052</comment></paragraph>
+<paragraph id="par_id3145765" role="code">COMBINA(Count1; Count2)</paragraph>
+<paragraph id="par_id3153372" role="paragraph"><emph>Count1</emph> is the
number of items in the set.</paragraph>
+<paragraph id="par_id3155544" role="paragraph"><emph>Count2</emph> is the
number of items to choose from the set.</paragraph>
+<paragraph id="par_id1997131" role="paragraph">COMBINA returns the number of
unique ways to choose these items, where the order of choosing is irrelevant,
and repetition of items is allowed. For example if there are 3 items A, B and C
in a set, you can choose 2 items in 6 different ways, namely AA, AB, AC, BB, BC
and CC.</paragraph>
+<paragraph id="par_id2052064" role="paragraph">COMBINA implements the formula:
(Count1+Count2-1)! / (Count2!(Count1-1)!)<comment>i88052</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3152904" role="paragraph" xml-lang="en-US"><item
type="input">=COMBINA(3;2)</item> returns 6.</paragraph><comment>see also
COMBIN</comment>
+<paragraph id="par_id3152904" role="paragraph"><item
type="input">=COMBINA(3;2)</item> returns 6.</paragraph><comment>see also
COMBIN</comment>
</section>
<section id="trunc">
@@ -612,237 +612,237 @@
</section>
<section id="Section34">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153601">
+<bookmark branch="index" id="bm_id3153601">
<bookmark_value>LN function</bookmark_value>
<bookmark_value>natural logarithm</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LN" id="bm_id3153613"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_LN" id="bm_id3153613" localize="false"/>
<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>
+<paragraph id="par_id3154974" role="paragraph"><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"/>
-<paragraph id="par_id3155284" role="code"
xml-lang="en-US">LN(Number)</paragraph>
-<paragraph id="par_id3155297" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value whose natural logarithm is to
be calculated.</paragraph>
+<paragraph id="par_id3155284" role="code">LN(Number)</paragraph>
+<paragraph id="par_id3155297" role="paragraph"><emph>Number</emph> is the
value whose natural logarithm is to be calculated.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3153866" role="paragraph" xml-lang="en-US"><item
type="input">=LN(3)</item> returns the natural logarithm of 3 (approximately
1.0986).</paragraph>
-<paragraph id="par_id5747245" role="paragraph" xml-lang="en-US"><item
type="input">=LN(EXP(321))</item> returns 321.</paragraph><comment>see also
LOG, LOG10, EXP</comment>
+<paragraph id="par_id3153866" role="paragraph"><item
type="input">=LN(3)</item> returns the natural logarithm of 3 (approximately
1.0986).</paragraph>
+<paragraph id="par_id5747245" role="paragraph"><item
type="input">=LN(EXP(321))</item> returns 321.</paragraph><comment>see also
LOG, LOG10, EXP</comment>
</section>
<section id="Section33">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3109813">
+<bookmark branch="index" id="bm_id3109813">
<bookmark_value>LOG function</bookmark_value>
<bookmark_value>logarithms</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG" id="bm_id3109824"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_LOG" id="bm_id3109824" localize="false"/>
<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>
+<paragraph id="par_id3109841" role="paragraph"><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"/>
-<paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number [;
Base])</paragraph>
-<paragraph id="par_id3144746" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value whose logarithm is to be
calculated.</paragraph>
-<paragraph id="par_id3152840" role="paragraph"
xml-lang="en-US"><emph>Base</emph> (optional) is the base for the logarithm
calculation. If omitted, Base 10 is assumed.</paragraph>
+<paragraph id="par_id3144732" role="code">LOG(Number [; Base])</paragraph>
+<paragraph id="par_id3144746" role="paragraph"><emph>Number</emph> is the
value whose logarithm is to be calculated.</paragraph>
+<paragraph id="par_id3152840" role="paragraph"><emph>Base</emph> (optional) is
the base for the logarithm calculation. If omitted, Base 10 is
assumed.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3154429" role="paragraph" xml-lang="en-US"><item
type="input">=LOG(10;3)</item> returns the logarithm to base 3 of 10
(approximately 2.0959).</paragraph>
-<paragraph id="par_id5577562" role="paragraph" xml-lang="en-US"><item
type="input">=LOG(7^4;7)</item> returns 4.</paragraph><comment>see also LOG10,
LN, POWER</comment>
+<paragraph id="par_id3154429" role="paragraph"><item
type="input">=LOG(10;3)</item> returns the logarithm to base 3 of 10
(approximately 2.0959).</paragraph>
+<paragraph id="par_id5577562" role="paragraph"><item
type="input">=LOG(7^4;7)</item> returns 4.</paragraph><comment>see also LOG10,
LN, POWER</comment>
</section>
<section id="Section32">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3154187">
+<bookmark branch="index" id="bm_id3154187">
<bookmark_value>LOG10 function</bookmark_value>
<bookmark_value>base-10 logarithm</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG10" id="bm_id3155460"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_LOG10" id="bm_id3155460" localize="false"/>
<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>
+<paragraph id="par_id3155476" role="paragraph"><ahelp
hid="HID_FUNC_LOG10">Returns the base-10 logarithm of a
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3159294" role="code"
xml-lang="en-US">LOG10(Number)</paragraph>
-<paragraph id="par_id3159308" role="paragraph" xml-lang="en-US">Returns the
logarithm to base 10 of <emph>Number</emph>.</paragraph>
+<paragraph id="par_id3159294" role="code">LOG10(Number)</paragraph>
+<paragraph id="par_id3159308" role="paragraph">Returns the logarithm to base
10 of <emph>Number</emph>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3157916" role="paragraph" xml-lang="en-US"><item
type="input">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately
0.69897).</paragraph><comment>see also LOG, LN, POWER</comment>
+<paragraph id="par_id3157916" role="paragraph"><item
type="input">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately
0.69897).</paragraph><comment>see also LOG, LN, POWER</comment>
</section>
<section id="Section30">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3157762">
+<bookmark branch="index" id="bm_id3157762">
<bookmark_value>PI function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PI" id="bm_id3157774"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_PI" id="bm_id3157774" localize="false"/>
<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>
+<paragraph id="par_id3157790" role="paragraph"><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"/>
-<paragraph id="par_id3157822" role="code" xml-lang="en-US">PI()</paragraph>
+<paragraph id="par_id3157822" role="code">PI()</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3152370" role="paragraph" xml-lang="en-US"><item
type="input">=PI()</item> returns 3.14159265358979.</paragraph>
+<paragraph id="par_id3152370" role="paragraph"><item type="input">=PI()</item>
returns 3.14159265358979.</paragraph>
</section>
<section id="Section29">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3152418">
+<bookmark branch="index" id="bm_id3152418">
<bookmark_value>MULTINOMIAL function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL"
id="bm_id3152429" localize="false"/>
+<bookmark branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429"
localize="false"/>
<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>
+<paragraph id="par_id3152454" role="paragraph"><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"/>
-<paragraph id="par_id3155660" role="code"
xml-lang="en-US">MULTINOMIAL(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3155660" role="code">MULTINOMIAL(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3155701" role="paragraph" xml-lang="en-US"><item
type="input">=MULTINOMIAL(F11:H11)</item> returns 1260, if F11 to H11 contain
the values <item type="input">2</item>, <item type="input">3</item> and <item
type="input">4</item>. This corresponds to the formula =(2+3+4)! /
(2!*3!*4!)</paragraph>
+<paragraph id="par_id3155701" role="paragraph"><item
type="input">=MULTINOMIAL(F11:H11)</item> returns 1260, if F11 to H11 contain
the values <item type="input">2</item>, <item type="input">3</item> and <item
type="input">4</item>. This corresponds to the formula =(2+3+4)! /
(2!*3!*4!)</paragraph>
</section>
<section id="Section28">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3155717">
+<bookmark branch="index" id="bm_id3155717">
<bookmark_value>POWER function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POTENZ" id="bm_id3155728"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/>
<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>
+<paragraph id="par_id3159495" role="paragraph"><ahelp
hid="HID_FUNC_POTENZ">Returns a number raised to another
number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3159526" role="code" xml-lang="en-US">POWER(Base;
Exponent)</paragraph>
-<paragraph id="par_id3159540" role="paragraph" xml-lang="en-US">Returns
<emph>Base</emph> raised to the power of <emph>Exponent</emph>.</paragraph>
-<paragraph id="par_id5081637" role="paragraph" xml-lang="en-US">The same
result may be achieved by using the exponentiation operator ^:</paragraph>
-<paragraph id="par_id9759514" role="code" xml-lang="en-US"><item
type="literal">Base^Exponent</item></paragraph>
+<paragraph id="par_id3159526" role="code">POWER(Base; Exponent)</paragraph>
+<paragraph id="par_id3159540" role="paragraph">Returns <emph>Base</emph>
raised to the power of <emph>Exponent</emph>.</paragraph>
+<paragraph id="par_id5081637" role="paragraph">The same result may be achieved
by using the exponentiation operator ^:</paragraph>
+<paragraph id="par_id9759514" role="code"><item
type="literal">Base^Exponent</item></paragraph>
<note id="par_id241599040594931"><literal>=POWER(0,0)</literal> returns
1.</note>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3159594" role="paragraph" xml-lang="en-US"><item
type="input">=POWER(4;3)</item> returns 64, which is 4 to the power of
3.</paragraph>
-<paragraph id="par_id1614429" role="paragraph" xml-lang="en-US">=4^3 also
returns 4 to the power of 3.</paragraph><comment>see also EXP, LOG,
SQRT</comment>
+<paragraph id="par_id3159594" role="paragraph"><item
type="input">=POWER(4;3)</item> returns 64, which is 4 to the power of
3.</paragraph>
+<paragraph id="par_id1614429" role="paragraph">=4^3 also returns 4 to the
power of 3.</paragraph><comment>see also EXP, LOG, SQRT</comment>
</section>
<section id="Section27">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3152651">
+<bookmark branch="index" id="bm_id3152651">
<bookmark_value>SERIESSUM function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SERIESSUM"
id="bm_id3152662" localize="false"/>
+<bookmark branch="hid/SC_HID_AAI_FUNC_SERIESSUM" id="bm_id3152662"
localize="false"/>
<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;c) = c<sub>1</sub>x<sup>n</sup> +
c<sub>2</sub>x<sup>n+m</sup> + c<sub>3</sub>x<sup>n+2m</sup> + ... +
c<sub>i</sub>x<sup>n + (i-1)m</sup>.</paragraph>
+<paragraph id="par_id3152688" role="paragraph"><ahelp hid=".">Sums the first
terms of a power series.</ahelp></paragraph>
+<paragraph id="par_id3152708" role="paragraph">SERIESSUM(x;n;m;c) =
c<sub>1</sub>x<sup>n</sup> + c<sub>2</sub>x<sup>n+m</sup> +
c<sub>3</sub>x<sup>n+2m</sup> + ... + c<sub>i</sub>x<sup>n +
(i-1)m</sup>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_idN11BD9" role="code" xml-lang="en-US">SERIESSUM(X; N; M;
Coefficients)</paragraph>
-<paragraph id="par_id3152737" role="paragraph" xml-lang="en-US"><emph>X</emph>
is the input value for the power series.</paragraph>
-<paragraph id="par_id3144344" role="paragraph" xml-lang="en-US"><emph>N</emph>
is the initial power</paragraph>
-<paragraph id="par_id3144357" role="paragraph" xml-lang="en-US"><emph>M</emph>
is the increment to increase N</paragraph>
-<paragraph id="par_id3144370" role="paragraph"
xml-lang="en-US"><emph>Coefficients</emph> is a series of coefficients. For
each coefficient the series sum is extended by one section.</paragraph>
+<paragraph id="par_idN11BD9" role="code">SERIESSUM(X; N; M;
Coefficients)</paragraph>
+<paragraph id="par_id3152737" role="paragraph"><emph>X</emph> is the input
value for the power series.</paragraph>
+<paragraph id="par_id3144344" role="paragraph"><emph>N</emph> is the initial
power</paragraph>
+<paragraph id="par_id3144357" role="paragraph"><emph>M</emph> is the increment
to increase N</paragraph>
+<paragraph id="par_id3144370" role="paragraph"><emph>Coefficients</emph> is a
series of coefficients. For each coefficient the series sum is extended by one
section.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id431635251540138"><input>=SERIESSUM(A1;
0; 1; {1; 2; 3})</input> calculates the value of 1+2x+3x<sup>2</sup>, where x
is the value in cell A1. If A1 contains 1, the formula returns 6; if A1
contains 2, the formula returns 17; if A1 contains 3, the formula returns 34;
and so on.</paragraph>
<tip id="par_id881635251427220">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SERIESSUM";>SERIESSUM</link>
wiki page for more details about this function.</tip>
</section>
<section id="Section26">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3144386">
+<bookmark branch="index" id="bm_id3144386">
<bookmark_value>PRODUCT function</bookmark_value>
<bookmark_value>numbers;multiplying</bookmark_value>
<bookmark_value>multiplying;numbers</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/>
<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>
+<paragraph id="par_id3144414" role="paragraph"><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"/>
-<paragraph id="par_id3144446" role="code" xml-lang="en-US">PRODUCT(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3144446" role="code">PRODUCT(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3144494" role="paragraph" xml-lang="en-US"><item
type="input">=PRODUCT(2;3;4)</item> returns 24.</paragraph><comment>see also
FACT, SUM</comment>
+<paragraph id="par_id3144494" role="paragraph"><item
type="input">=PRODUCT(2;3;4)</item> returns 24.</paragraph><comment>see also
FACT, SUM</comment>
</section>
<section id="Section25">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3160340">
+<bookmark branch="index" id="bm_id3160340">
<bookmark_value>SUMSQ function</bookmark_value>
<bookmark_value>square number additions</bookmark_value>
<bookmark_value>sums;of square numbers</bookmark_value>
</bookmark>
<comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUADRATESUMME"
id="bm_id3160351" localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_QUADRATESUMME" id="bm_id3160351"
localize="false"/>
<h2 id="hd_id3160340">SUMSQ</h2>
-<paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_QUADRATESUMME">Calculates the sum of the squares of a set of
numbers.</ahelp></paragraph>
+<paragraph id="par_id3160368" role="paragraph"><ahelp
hid="HID_FUNC_QUADRATESUMME">Calculates the sum of the squares of a set of
numbers.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3160402" role="code" xml-lang="en-US">SUMSQ(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+<paragraph id="par_id3160402" role="code">SUMSQ(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3160449" role="paragraph" xml-lang="en-US">If you enter
the numbers 2; 3 and 4 in the Number 1; 2 and 3 arguments, 29 is returned as
the result.</paragraph>
+<paragraph id="par_id3160449" role="paragraph">If you enter the numbers 2; 3
and 4 in the Number 1; 2 and 3 arguments, 29 is returned as the
result.</paragraph>
</section>
<section id="Section24">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3158247">
+<bookmark branch="index" id="bm_id3158247">
<bookmark_value>MOD function</bookmark_value>
<bookmark_value>remainders of divisions</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_REST" id="bm_id3158259"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_REST" id="bm_id3158259" localize="false"/>
<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>
+<paragraph id="par_id3158276" role="paragraph"><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"/>
-<paragraph id="par_id3158308" role="code" xml-lang="en-US">MOD(Dividend;
Divisor)</paragraph>
-<paragraph id="par_id3158321" role="paragraph" xml-lang="en-US">For integer
arguments this function returns Dividend modulo Divisor, that is the remainder
when <emph>Dividend</emph> is divided by <emph>Divisor</emph>.</paragraph>
-<paragraph id="par_id3158341" role="paragraph" xml-lang="en-US">This function
is implemented as <item type="literal">Dividend - Divisor *
INT(Dividend/Divisor)</item> , and this formula gives the result if the
arguments are not integer.</paragraph>
+<paragraph id="par_id3158308" role="code">MOD(Dividend; Divisor)</paragraph>
+<paragraph id="par_id3158321" role="paragraph">For integer arguments this
function returns Dividend modulo Divisor, that is the remainder when
<emph>Dividend</emph> is divided by <emph>Divisor</emph>.</paragraph>
+<paragraph id="par_id3158341" role="paragraph">This function is implemented as
<item type="literal">Dividend - Divisor * INT(Dividend/Divisor)</item> , and
this formula gives the result if the arguments are not integer.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3158374" role="paragraph" xml-lang="en-US"><item
type="input">=MOD(22;3)</item> returns 1, the remainder when 22 is divided by
3.</paragraph>
-<paragraph id="par_id1278420" role="paragraph" xml-lang="en-US"><item
type="input">=MOD(11.25;2.5)</item> returns 1.25.</paragraph><comment>see also
QUOTIENT, INT</comment>
+<paragraph id="par_id3158374" role="paragraph"><item
type="input">=MOD(22;3)</item> returns 1, the remainder when 22 is divided by
3.</paragraph>
+<paragraph id="par_id1278420" role="paragraph"><item
type="input">=MOD(11.25;2.5)</item> returns 1.25.</paragraph><comment>see also
QUOTIENT, INT</comment>
</section>
<section id="Section23">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3144592">
+<bookmark branch="index" id="bm_id3144592">
<bookmark_value>QUOTIENT function</bookmark_value>
<bookmark_value>divisions</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_QUOTIENT"
id="bm_id3144603" localize="false"/>
+<bookmark branch="hid/SC_HID_AAI_FUNC_QUOTIENT" id="bm_id3144603"
localize="false"/>
<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>
+<paragraph id="par_id3144627" role="paragraph"><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"/>
-<paragraph id="par_id3144659" role="code" xml-lang="en-US">QUOTIENT(Numerator;
Denominator)</paragraph>
-<paragraph id="par_id9038972" role="paragraph" xml-lang="en-US">Returns the
integer part of <emph>Numerator</emph> divided by
<emph>Denominator</emph>.</paragraph>
-<paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is
equivalent to <item type="literal">INT(numerator/denominator)</item> for
same-sign numerator and denominator, except that it may report errors with
different error codes. More generally, it is equivalent to <item
type="literal">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>.</paragraph>
+<paragraph id="par_id3144659" role="code">QUOTIENT(Numerator;
Denominator)</paragraph>
+<paragraph id="par_id9038972" role="paragraph">Returns the integer part of
<emph>Numerator</emph> divided by <emph>Denominator</emph>.</paragraph>
+<paragraph id="par_id7985168" role="paragraph">QUOTIENT is equivalent to <item
type="literal">INT(numerator/denominator)</item> for same-sign numerator and
denominator, except that it may report errors with different error codes. More
generally, it is equivalent to <item
type="literal">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3144687" role="paragraph" xml-lang="en-US"><item
type="input">=QUOTIENT(11;3)</item> returns 3. The remainder of 2 is
lost.</paragraph><comment>see also MOD, INT</comment>
+<paragraph id="par_id3144687" role="paragraph"><item
type="input">=QUOTIENT(11;3)</item> returns 3. The remainder of 2 is
lost.</paragraph><comment>see also MOD, INT</comment>
</section>
<section id="Section22">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3144702">
+<bookmark branch="index" id="bm_id3144702">
<bookmark_value>RADIANS function</bookmark_value>
<bookmark_value>converting;degrees, into radians</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAD" id="bm_id3158008"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_RAD" id="bm_id3158008" localize="false"/>
<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>
+<paragraph id="par_id3158025" role="paragraph"><ahelp
hid="HID_FUNC_RAD">Converts degrees to radians.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3158055" role="code"
xml-lang="en-US">RADIANS(Number)</paragraph>
-<paragraph id="par_id3158069" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the angle in degrees to be converted to
radians.</paragraph>
+<paragraph id="par_id3158055" role="code">RADIANS(Number)</paragraph>
+<paragraph id="par_id3158069" role="paragraph"><emph>Number</emph> is the
angle in degrees to be converted to radians.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3939634" role="paragraph" xml-lang="en-US"><item
type="input">=RADIANS(90)</item> returns 1.5707963267949, which is PI/2 to
Calc's accuracy.</paragraph><comment>see also DEGREES</comment>
+<paragraph id="par_id3939634" role="paragraph"><item
type="input">=RADIANS(90)</item> returns 1.5707963267949, which is PI/2 to
Calc's accuracy.</paragraph><comment>see also DEGREES</comment>
</section>
<section id="Section67">
@@ -850,26 +850,26 @@
</section>
<section id="Section21">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3158121">
+<bookmark branch="index" id="bm_id3158121">
<bookmark_value>ROUND function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RUNDEN" id="bm_id3158133"
localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/>
<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>
+<paragraph id="par_id3158150" role="paragraph"><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"/>
-<paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number [;
Count])</paragraph>
-<paragraph id="par_id3158196" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded to <emph>Count</emph> decimal places. If Count is
omitted or zero, the function rounds to the nearest integer. If Count is
negative, the function rounds to the nearest 10, 100, 1000, etc.</paragraph>
-<paragraph id="par_id599688" role="paragraph" xml-lang="en-US">This function
rounds to the nearest number. See ROUNDDOWN and ROUNDUP for
alternatives.</paragraph>
+<paragraph id="par_id3158182" role="code">ROUND(Number [; Count])</paragraph>
+<paragraph id="par_id3158196" role="paragraph">Returns <emph>Number</emph>
rounded to <emph>Count</emph> decimal places. If Count is omitted or zero, the
function rounds to the nearest integer. If Count is negative, the function
rounds to the nearest 10, 100, 1000, etc.</paragraph>
+<paragraph id="par_id599688" role="paragraph">This function rounds to the
nearest number. See ROUNDDOWN and ROUNDUP for alternatives.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3145876" role="paragraph" xml-lang="en-US"><item
type="input">=ROUND(2.348;2)</item> returns 2.35</paragraph>
-<paragraph id="par_id3145899" role="paragraph" xml-lang="en-US"><item
type="input">=ROUND(-32.4834;3)</item> returns -32.483. Change the cell format
to see all decimals.</paragraph>
-<paragraph id="par_id1371501" role="paragraph" xml-lang="en-US"><item
type="input">=ROUND(2.348;0)</item> returns 2.</paragraph>
-<paragraph id="par_id4661702" role="paragraph" xml-lang="en-US"><item
type="input">=ROUND(2.5)</item> returns 3.</paragraph>
-<paragraph id="par_id7868892" role="paragraph" xml-lang="en-US"><item
type="input">=ROUND(987.65;-2)</item> returns 1000.</paragraph><comment>see
also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
+<paragraph id="par_id3145876" role="paragraph"><item
type="input">=ROUND(2.348;2)</item> returns 2.35</paragraph>
+<paragraph id="par_id3145899" role="paragraph"><item
type="input">=ROUND(-32.4834;3)</item> returns -32.483. Change the cell format
to see all decimals.</paragraph>
+<paragraph id="par_id1371501" role="paragraph"><item
type="input">=ROUND(2.348;0)</item> returns 2.</paragraph>
+<paragraph id="par_id4661702" role="paragraph"><item
type="input">=ROUND(2.5)</item> returns 3.</paragraph>
+<paragraph id="par_id7868892" role="paragraph"><item
type="input">=ROUND(987.65;-2)</item> returns 1000.</paragraph><comment>see
also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
</section>
<section id="rounddown">
@@ -878,111 +878,111 @@
</section>
<section id="Section19">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3163268">
+<bookmark branch="index" id="bm_id3163268">
<bookmark_value>ROUNDUP function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AUFRUNDEN"
id="bm_id3163280" localize="false"/>
+<bookmark branch="hid/SC_HID_FUNC_AUFRUNDEN" id="bm_id3163280"
localize="false"/>
<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>
+<paragraph id="par_id3163297" role="paragraph"><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"/>
-<paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number [;
Count])</paragraph>
-<paragraph id="par_id3163342" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded up (away from zero) to <emph>Count</emph> decimal
places. If Count is omitted or zero, the function rounds up to an integer. If
Count is negative, the function rounds up to the next 10, 100, 1000,
etc.</paragraph>
-<paragraph id="par_id9573961" role="paragraph" xml-lang="en-US">This function
rounds away from zero. See ROUNDDOWN and ROUND for alternatives.</paragraph>
+<paragraph id="par_id3163328" role="code">ROUNDUP(Number [; Count])</paragraph>
+<paragraph id="par_id3163342" role="paragraph">Returns <emph>Number</emph>
rounded up (away from zero) to <emph>Count</emph> decimal places. If Count is
omitted or zero, the function rounds up to an integer. If Count is negative,
the function rounds up to the next 10, 100, 1000, etc.</paragraph>
+<paragraph id="par_id9573961" role="paragraph">This function rounds away from
zero. See ROUNDDOWN and ROUND for alternatives.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3144786" role="paragraph" xml-lang="en-US"><item
type="input">=ROUNDUP(1.1111;2)</item> returns 1.12.</paragraph>
-<paragraph id="par_id7700430" role="paragraph" xml-lang="en-US"><item
type="input">=ROUNDUP(1.2345;1)</item> returns 1.3.</paragraph>
-<paragraph id="par_id1180455" role="paragraph" xml-lang="en-US"><item
type="input">=ROUNDUP(45.67;0)</item> returns 46.</paragraph>
-<paragraph id="par_id3405560" role="paragraph" xml-lang="en-US"><item
type="input">=ROUNDUP(-45.67)</item> returns -46.</paragraph>
-<paragraph id="par_id3409527" role="paragraph" xml-lang="en-US"><item
type="input">=ROUNDUP(987.65;-2)</item> returns 1000.</paragraph><comment>see
also INT, TRUNC, ROUND, ROUNDDOWN, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
+<paragraph id="par_id3144786" role="paragraph"><item
type="input">=ROUNDUP(1.1111;2)</item> returns 1.12.</paragraph>
+<paragraph id="par_id7700430" role="paragraph"><item
type="input">=ROUNDUP(1.2345;1)</item> returns 1.3.</paragraph>
+<paragraph id="par_id1180455" role="paragraph"><item
type="input">=ROUNDUP(45.67;0)</item> returns 46.</paragraph>
+<paragraph id="par_id3405560" role="paragraph"><item
type="input">=ROUNDUP(-45.67)</item> returns -46.</paragraph>
+<paragraph id="par_id3409527" role="paragraph"><item
type="input">=ROUNDUP(987.65;-2)</item> returns 1000.</paragraph><comment>see
also INT, TRUNC, ROUND, ROUNDDOWN, CEILING, FLOOR, EVEN, ODD, MROUND</comment>
</section>
<section id="Section63">
-<bookmark xml-lang="en-US" branch="index" id="bm_id5256537">
+<bookmark branch="index" id="bm_id5256537">
<bookmark_value>SEC function</bookmark_value>
</bookmark>
-e
... etc. - the rest is truncated
