INTEGRATION: CWS hc680pp1 (1.4.6); FILE MERGED

2005/09/30 15:31:40 ufi 1.4.6.5: RESYNC: (1.4-1.5); FILE MERGED
2005/08/12 12:34:24 ufi 1.4.6.4: comment
2005/07/20 08:41:09 ufi 1.4.6.3: before build
2005/06/02 09:56:40 fpe 1.4.6.2:  regular update
2005/04/29 14:11:00 fpe 1.4.6.1: Regular Update

1 files changed, 58 insertions, 68 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp
index 4bae25051e..c8a2a3bcb4 100644
--- a/helpcontent2/source/text/scalc/01/04060106.xhp
+++ b/helpcontent2/source/text/scalc/01/04060106.xhp
@@ -5,9 +5,9 @@
  *
  *  $RCSfile: 04060106.xhp,v $
  *
- *  $Revision: 1.5 $
+ *  $Revision: 1.6 $
  *
- *  last change: $Author: rt $ $Date: 2005-09-07 17:27:59 $
+ *  last change: $Author: kz $ $Date: 2005-10-05 11:57:21 $
  *
  *  The Contents of this file are made available subject to
  *  the terms of GNU Lesser General Public License Version 2.1.
@@ -42,7 +42,7 @@
 </topic>
 <history>
 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-10-12T12:42:19">UFI: fixed #i25926#, added missing head2 lines, 
+<lastedited date="2005-08-09T13:40:39">UFI: fixed #i25926#, added missing head2 lines, 
 also fixed #i24074#, also fixed #i18230#
 discovered all internal links were empty, so deleted them with FPEs approval.; dedr: reviewed</lastedited>
 </history>
@@ -88,13 +88,13 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/>
 <paragraph role="heading" id="hd_id3153114" xml-lang="en-US" level="2" l10n="U" oldref="50">ACOS</paragraph>
-<paragraph role="paragraph" id="par_id3145163" xml-lang="en-US" l10n="U" oldref="51"><ahelp hid="HID_FUNC_ARCCOS">Returns the arc cosine of a number.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145163" xml-lang="en-US" l10n="CHG" oldref="51"><ahelp hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a number.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3153565" xml-lang="en-US" level="3" l10n="U" oldref="52">Syntax:</paragraph>
 <paragraph role="code" id="par_id3150020" xml-lang="en-US" l10n="U" oldref="53">ACOS(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3159134" xml-lang="en-US" l10n="U" oldref="54">
-<emph>Number</emph> is the value, whose arc cosine value is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3159134" xml-lang="en-US" l10n="CHG" oldref="54">
+<emph>Number</emph> is the value, whose inverse trigonometric cosine value is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3149882" xml-lang="en-US" level="3" l10n="U" oldref="55">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3150128" xml-lang="en-US" l10n="U" oldref="56">The arc cosine of -1 returns the value 3.14.</paragraph>
+<paragraph role="paragraph" id="par_id3150128" xml-lang="en-US" l10n="CHG" oldref="56">The inverse trigonometric cosine of -1 returns the value 3.14.</paragraph>
 </section>
 <section id="Section60">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145355"><bookmark_value>ACOSH function</bookmark_value>
@@ -140,13 +140,13 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
 <paragraph role="heading" id="hd_id3145084" xml-lang="en-US" level="2" l10n="U" oldref="90">ASIN</paragraph>
-<paragraph role="paragraph" id="par_id3156296" xml-lang="en-US" l10n="U" oldref="91"><ahelp hid="HID_FUNC_ARCSIN">Returns the arcsine of a number.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156296" xml-lang="en-US" l10n="CHG" oldref="91"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3149716" xml-lang="en-US" level="3" l10n="U" oldref="92">Syntax:</paragraph>
 <paragraph role="code" id="par_id3156305" xml-lang="en-US" l10n="U" oldref="93">ASIN (Number)</paragraph>
-<paragraph role="paragraph" id="par_id3150964" xml-lang="en-US" l10n="U" oldref="94">
-<emph>Number</emph> is the value whose arcsine is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3150964" xml-lang="en-US" l10n="CHG" oldref="94">
+<emph>Number</emph> is the value whose inverse trigonometric sine is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3149448" xml-lang="en-US" level="3" l10n="U" oldref="95">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3156100" xml-lang="en-US" l10n="U" oldref="96">The arcsine of -1 returns the value -1.57.</paragraph>
+<paragraph role="paragraph" id="par_id3156100" xml-lang="en-US" l10n="CHG" oldref="96">The inverse trigonometric sine of -1 returns the value -1.57.</paragraph>
 </section>
 <section id="Section56">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3151266"><bookmark_value>ASINH function</bookmark_value>
@@ -166,20 +166,20 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/>
 <paragraph role="heading" id="hd_id3155996" xml-lang="en-US" level="2" l10n="U" oldref="110">ATAN</paragraph>
-<paragraph role="paragraph" id="par_id3149985" xml-lang="en-US" l10n="U" oldref="111"><ahelp hid="HID_FUNC_ARCTAN">Returns the arctangent of a number.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149985" xml-lang="en-US" l10n="CHG" oldref="111"><ahelp hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a number.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3151294" xml-lang="en-US" level="3" l10n="U" oldref="112">Syntax:</paragraph>
 <paragraph role="code" id="par_id3150261" xml-lang="en-US" l10n="U" oldref="113">ATAN(Number)</paragraph>
-<paragraph role="paragraph" id="par_id3147267" xml-lang="en-US" l10n="U" oldref="114">
-<emph>Number</emph> is the value whose arctangent value is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3147267" xml-lang="en-US" l10n="CHG" oldref="114">
+<emph>Number</emph> is the value whose inverse trigonometric tangent value is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3154054" xml-lang="en-US" level="3" l10n="U" oldref="115">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3143229" xml-lang="en-US" l10n="U" oldref="116">The arctangent of -1 returns the value -0.79.</paragraph>
+<paragraph role="paragraph" id="par_id3143229" xml-lang="en-US" l10n="CHG" oldref="116">The inverse trigonometric tangent of -1 returns the value -0.79.</paragraph>
 </section>
 <section id="Section54">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>ATAN2 function</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
 <paragraph role="heading" id="hd_id3153983" xml-lang="en-US" level="2" l10n="U" oldref="120">ATAN2</paragraph>
-<paragraph role="paragraph" id="par_id3154297" xml-lang="en-US" l10n="U" oldref="121"><ahelp hid="HID_FUNC_ARCTAN2">Returns the arctangent of the specified x and y coordinates.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154297" xml-lang="en-US" l10n="CHG" oldref="121"><ahelp hid="HID_FUNC_ARCTAN2">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3149758" xml-lang="en-US" level="3" l10n="U" oldref="122">Syntax:</paragraph>
 <paragraph role="code" id="par_id3156013" xml-lang="en-US" l10n="U" oldref="123">ATAN2(Number x; number y)</paragraph>
 <paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="U" oldref="124">
@@ -187,7 +187,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <paragraph role="paragraph" id="par_id3152798" xml-lang="en-US" l10n="U" oldref="125">
 <emph>Number y</emph> is the value for the y coordinate.</paragraph>
 <paragraph role="heading" id="hd_id3145663" xml-lang="en-US" level="3" l10n="U" oldref="126">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3154692" xml-lang="en-US" l10n="U" oldref="127">Entering the value 45 for the x coordinate and the value 90 for the y coordinate will return an arctangent of 1.11.</paragraph>
+<paragraph role="paragraph" id="par_id3154692" xml-lang="en-US" l10n="CHG" oldref="127">Entering the value 45 for the x coordinate and the value 90 for the y coordinate will return an inverse trigonometric tangent of 1.11.</paragraph>
 </section>
 <section id="Section53">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3155398"><bookmark_value>ATANH function</bookmark_value>
@@ -273,15 +273,13 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
 <paragraph role="heading" id="hd_id3148698" xml-lang="en-US" level="2" l10n="U" oldref="198">EXP</paragraph>
-<paragraph role="paragraph" id="par_id3150592" xml-lang="en-US" l10n="U" oldref="199"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150592" xml-lang="en-US" l10n="CHG" oldref="199"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
 <paragraph role="heading" id="hd_id3150351" xml-lang="en-US" level="3" l10n="U" oldref="200">Syntax:</paragraph>
 <paragraph role="code" id="par_id3146786" xml-lang="en-US" l10n="U" oldref="201">EXP(number)</paragraph>
 <paragraph role="paragraph" id="par_id3155608" xml-lang="en-US" l10n="U" oldref="202">
 <emph>Number</emph> is the power to which e is to be raised.</paragraph>
 <paragraph role="heading" id="hd_id3154418" xml-lang="en-US" level="3" l10n="U" oldref="203">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3156340" xml-lang="en-US" l10n="U" oldref="204">The result for e raised to the power -4 is 0.02.</paragraph>
-<paragraph role="paragraph" id="par_id3154835" xml-lang="en-US" l10n="U" oldref="205">The result for e raised to the power 0.5 is 1.65.</paragraph>
-<paragraph role="paragraph" id="par_id3153675" xml-lang="en-US" l10n="U" oldref="206">The result for e raised to the power 1 is 2.72.</paragraph>
 </section>
 <section id="Section46">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145781"><bookmark_value>FACT function</bookmark_value>
@@ -316,11 +314,11 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
 <paragraph role="heading" id="hd_id3150938" xml-lang="en-US" level="2" l10n="U" oldref="227">EVEN</paragraph>
-<paragraph role="paragraph" id="par_id3149988" xml-lang="en-US" l10n="U" oldref="228"><ahelp hid="HID_FUNC_GERADE">Returns a number rounded up to the nearest even integer.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149988" xml-lang="en-US" l10n="CHG" oldref="228"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the nearest even integer and a negative number down to the nearest even integer.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3148401" xml-lang="en-US" level="3" l10n="U" oldref="229">Syntax:</paragraph>
 <paragraph role="code" id="par_id3150830" xml-lang="en-US" l10n="U" oldref="230">EVEN(number)</paragraph>
-<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US" l10n="U" oldref="231">
-<emph>Number</emph> is the number that is to be rounded up to the nearest even integer.</paragraph>
+<paragraph role="paragraph" id="par_id3153350" xml-lang="en-US" l10n="CHG" oldref="231">
+<emph>Number</emph> is the number that is to be rounded.</paragraph>
 <paragraph role="heading" id="hd_id3155508" xml-lang="en-US" level="3" l10n="U" oldref="232">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3154361" xml-lang="en-US" l10n="U" oldref="233">If you enter the number 0.01, 2 will be returned as the result.</paragraph>
 <paragraph role="paragraph" id="par_id3150679" xml-lang="en-US" l10n="U" oldref="234">If you enter the number -2.1, -4 will be returned as the result.</paragraph>
@@ -446,32 +444,29 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_KUERZEN" id="bm_id3157849" localize="false"/>
 <paragraph role="heading" id="hd_id3156086" xml-lang="en-US" level="2" l10n="U" oldref="291">TRUNC</paragraph>
-<paragraph role="paragraph" id="par_id3157866" xml-lang="en-US" l10n="U" oldref="292"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number to an integer (number) by removing the fractional part of the number according to the precision specified in <emph>num_digits</emph>.</ahelp></paragraph>
-<paragraph role="warning" id="par_id3148548" xml-lang="en-US" l10n="CHG" oldref="557">The decimal places correspond to the number of decimal places that are specified in <link href="text/shared/optionen/01060500.xhp">Tools - Options - %PRODUCTNAME Calc - Calculate</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3157866" xml-lang="en-US" l10n="CHG" oldref="292"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places of the number according to the precision specified in <emph>count</emph>.</ahelp></paragraph>
+<paragraph role="warning" id="par_id3148548" xml-lang="en-US" l10n="CHG" oldref="557">The visible decimal places are specified in <link href="text/shared/optionen/01060500.xhp">Tools - Options - %PRODUCTNAME Calc - Calculate</link>.</paragraph>
 <paragraph role="heading" id="hd_id3148499" xml-lang="en-US" level="3" l10n="U" oldref="293">Syntax:</paragraph>
 <paragraph role="code" id="par_id3148511" xml-lang="en-US" l10n="U" oldref="294">TRUNC(number; count)</paragraph>
 <paragraph role="paragraph" id="par_id3150796" xml-lang="en-US" l10n="U" oldref="295">
 <emph>Number</emph> is the number whose decimal places are to be cut off.</paragraph>
-<paragraph role="paragraph" id="par_id3150816" xml-lang="en-US" l10n="U" oldref="296">
-<emph>Count</emph> is the number whose decimal places are not cut off.</paragraph>
+<paragraph role="paragraph" id="par_id3150816" xml-lang="en-US" l10n="CHG" oldref="296">
+<emph>Count</emph> is the number of places after the decimal delimiter that are not to be truncated.</paragraph>
 <paragraph role="heading" id="hd_id3152555" xml-lang="en-US" level="3" l10n="U" oldref="297">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3152569" xml-lang="en-US" l10n="U" oldref="298">If you enter the number 34.5678 and the count 1, 34.5 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3153639" xml-lang="en-US" l10n="U" oldref="299">If you enter the number -15.769 and the count 3, -15.77 will be returned as the result.</paragraph>
 </section>
 <section id="Section34">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153601"><bookmark_value>LN function</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_LN" id="bm_id3153613" localize="false"/>
 <paragraph role="heading" id="hd_id3153601" xml-lang="en-US" level="2" l10n="U" oldref="301">LN</paragraph>
-<paragraph role="paragraph" id="par_id3154974" xml-lang="en-US" l10n="U" oldref="302"><ahelp hid="HID_FUNC_LN">Returns the natural logarithm based on the constant e (2.71828182845904) of a number.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154974" xml-lang="en-US" l10n="CHG" oldref="302"><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 role="heading" id="hd_id3154993" xml-lang="en-US" level="3" l10n="U" oldref="303">Syntax:</paragraph>
 <paragraph role="code" id="par_id3155284" xml-lang="en-US" l10n="U" oldref="304">LN(number)</paragraph>
 <paragraph role="paragraph" id="par_id3155297" xml-lang="en-US" l10n="U" oldref="305">
 <emph>Number</emph> is the value whose natural logarithm is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3153852" xml-lang="en-US" level="3" l10n="U" oldref="306">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3153866" xml-lang="en-US" l10n="U" oldref="307">The natural logarithm to the base e of the value 3 will return 1.1 as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3159355" xml-lang="en-US" l10n="U" oldref="308">The natural logarithm to the base e of the value 13 will return 2.56 as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3159370" xml-lang="en-US" l10n="U" oldref="309">The natural logarithm to the base e of the value 1000 will return 6.91 as the result.</paragraph>
+<paragraph role="paragraph" id="par_id3153866" xml-lang="en-US" l10n="CHG" oldref="307">The natural logarithm to the base e of the value 3 will return the rounded value of 1.1 as the result.</paragraph>
 </section>
 <section id="Section33">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3109813"><bookmark_value>LOG function</bookmark_value>
@@ -502,28 +497,26 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <emph>Number</emph> is the value whose logarithm to the base 10 is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3159328" xml-lang="en-US" level="3" l10n="U" oldref="327">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3157916" xml-lang="en-US" l10n="U" oldref="328">The logarithm to the base 10 of the value 3 will return 0.48 as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3157931" xml-lang="en-US" l10n="U" oldref="329">The logarithm to the base 10 of the value 10 will return 1 as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3157946" xml-lang="en-US" l10n="U" oldref="330">The logarithm to the base 10 of the value 0.02 will return -1.7 as the result.</paragraph>
 </section>
 <section id="Section31">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152518"><bookmark_value>CEILING function</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/>
 <paragraph role="heading" id="hd_id3152518" xml-lang="en-US" level="2" l10n="U" oldref="332">CEILING</paragraph>
-<paragraph role="paragraph" id="par_id3153422" xml-lang="en-US" l10n="U" oldref="558"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number to the nearest integer or multiple of significance.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153422" xml-lang="en-US" l10n="CHG" oldref="558"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3153440" xml-lang="en-US" level="3" l10n="U" oldref="334">Syntax:</paragraph>
-<paragraph role="code" id="par_id3153454" xml-lang="en-US" l10n="U" oldref="335">CEILING(number; increment; mode)</paragraph>
+<paragraph role="code" id="par_id3153454" xml-lang="en-US" l10n="CHG" oldref="335">CEILING(Number; Significance; Mode)</paragraph>
 <paragraph role="paragraph" id="par_id3153467" xml-lang="en-US" l10n="U" oldref="336">
 <emph>Number</emph> is the number that is to be rounded up.</paragraph>
-<paragraph role="paragraph" id="par_id3155000" xml-lang="en-US" l10n="U" oldref="337">
-<emph>Increment</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
-<paragraph role="paragraph" id="par_id3155020" xml-lang="en-US" l10n="U" oldref="559">
-<emph>Mode</emph> is an optional value. If it is indicated and is not equal to zero and if the number and increment are negative, rounding up is carried out based on that value. Please note that this input gets lost in an import to MS Excel since Excel does not recognize any third parameter in functions.</paragraph>
-<paragraph role="warning" id="par_id3163792" xml-lang="en-US" l10n="U" oldref="629">If both parameters <emph>Number</emph> and <emph>Significance</emph> are negative and the Mode value is equal to zero or is not given, the results in $[officename] and Excel will differ after the import has been completed.</paragraph>
+<paragraph role="paragraph" id="par_id3155000" xml-lang="en-US" l10n="CHG" oldref="337">
+<emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph>
+<paragraph role="paragraph" id="par_id3155020" xml-lang="en-US" l10n="CHG" oldref="559">
+<emph>Mode</emph> is an optional value. If the <emph>Mode</emph> value is given and not equal to zero, and if <emph>Number</emph> and <emph>Significance</emph> are negative, then rounding is done based on the absolute value of <emph>Number</emph>. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter.</paragraph>
+<paragraph role="warning" id="par_id3163792" xml-lang="en-US" l10n="CHG" oldref="629">If both parameters <emph>Number</emph> and <emph>Significance</emph> are negative and the Mode value is equal to zero or is not given, the results in $[officename] and Excel will differ after the import has been completed. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc.</paragraph>
 <paragraph role="heading" id="hd_id3145697" xml-lang="en-US" level="3" l10n="U" oldref="338">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3145710" xml-lang="en-US" l10n="U" oldref="339">If you enter the number 3.4 and the increment 1, 4 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3145725" xml-lang="en-US" l10n="U" oldref="340">If you enter the number -6 and the increment -5, -5 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3145740" xml-lang="en-US" l10n="U" oldref="341">If you enter the number -0.6 and the increment -0.4, -0.4 will be returned as the result.</paragraph>
+<paragraph role="paragraph" id="par_id3145710" xml-lang="en-US" l10n="CHG" oldref="339">=CEILING( -11; -2) returns -10</paragraph>
+<paragraph role="paragraph" id="par_id3145725" xml-lang="en-US" l10n="CHG" oldref="340">=CEILING( -11; -2; 0) returns -10</paragraph>
+<paragraph role="paragraph" id="par_id3145740" xml-lang="en-US" l10n="CHG" oldref="341">=CEILING( -11; -2; 1) returns -12</paragraph>
 </section>
 <section id="Section30">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3157762"><bookmark_value>PI function</bookmark_value>
@@ -652,7 +645,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/>
 <paragraph role="heading" id="hd_id3158121" xml-lang="en-US" level="2" l10n="U" oldref="398">ROUND</paragraph>
-<paragraph role="paragraph" id="par_id3158150" xml-lang="en-US" l10n="U" oldref="399"><ahelp hid="HID_FUNC_RUNDEN">Returns a number rounded to a certain number of decimal places according to valid mathematical criteria.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3158150" xml-lang="en-US" l10n="CHG" oldref="399"><ahelp hid="HID_FUNC_RUNDEN">Returns a number rounded to a certain number of decimal places.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3158169" xml-lang="en-US" level="3" l10n="U" oldref="400">Syntax:</paragraph>
 <paragraph role="code" id="par_id3158182" xml-lang="en-US" l10n="U" oldref="401">ROUND(number; count)</paragraph>
 <paragraph role="paragraph" id="par_id3158196" xml-lang="en-US" l10n="U" oldref="402">
@@ -661,7 +654,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <emph>count</emph> (optional) is the number of the places to which the value is to be rounded. If the <emph>count</emph> parameter is negative, numbers before the decimal are rounded.</paragraph>
 <paragraph role="heading" id="hd_id3145863" xml-lang="en-US" level="3" l10n="U" oldref="404">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3145876" xml-lang="en-US" l10n="U" oldref="405">If you enter the number 17.546 in the <emph>number</emph> field, with 1 specified as the number of rounding places, 17.5 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3145899" xml-lang="en-US" l10n="U" oldref="406">If you enter the number -32.483 in the <emph>number</emph> field, with 3 specified as the number of rounding places, -32.48 will be returned as the result.</paragraph>
+<paragraph role="paragraph" id="par_id3145899" xml-lang="en-US" l10n="CHG" oldref="406">=ROUND(-32.4834; 3) returns -32.483. Change the cell format to see all decimals.</paragraph>
 </section>
 <section id="Section20">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145991"><bookmark_value>ROUNDDOWN function</bookmark_value>
@@ -673,8 +666,8 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <paragraph role="code" id="par_id3146051" xml-lang="en-US" l10n="U" oldref="27">ROUNDDOWN(number; count)</paragraph>
 <paragraph role="paragraph" id="par_id3146064" xml-lang="en-US" l10n="U" oldref="28">
 <emph>number</emph> is the number to be rounded down.</paragraph>
-<paragraph role="paragraph" id="par_id3163136" xml-lang="en-US" l10n="U" oldref="29">
-<emph>count</emph> (optional) is the number of digits to be rounded down to. If the <emph>count</emph> parameter is negative, rounding is to the digits preceding the decimal point.</paragraph>
+<paragraph role="paragraph" id="par_id3163136" xml-lang="en-US" l10n="CHG" oldref="29">
+<emph>count</emph> (optional) is the number of the places to which the value is to be rounded. If the <emph>count</emph> parameter is negative, numbers before the decimal are rounded.</paragraph>
 <paragraph role="heading" id="hd_id3163164" xml-lang="en-US" level="3" l10n="U" oldref="30">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3163178" xml-lang="en-US" l10n="U" oldref="31">Entering the value 567.567 and the value 2 in the <emph>count</emph> field will return 567.56.</paragraph>
 </section>
@@ -688,8 +681,8 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <paragraph role="code" id="par_id3163328" xml-lang="en-US" l10n="U" oldref="143">ROUNDUP(number; count)</paragraph>
 <paragraph role="paragraph" id="par_id3163342" xml-lang="en-US" l10n="U" oldref="144">
 <emph>number</emph> is the number to be rounded up.</paragraph>
-<paragraph role="paragraph" id="par_id3163361" xml-lang="en-US" l10n="U" oldref="145">
-<emph>count</emph> (optional) is the number of digits to which rounding up is to be done.</paragraph>
+<paragraph role="paragraph" id="par_id3163361" xml-lang="en-US" l10n="CHG" oldref="145">
+<emph>count</emph> (optional) is the number of the places to which the value is to be rounded. If the <emph>count</emph> parameter is negative, numbers before the decimal are rounded.</paragraph>
 <paragraph role="heading" id="hd_id3163381" xml-lang="en-US" level="3" l10n="U" oldref="146">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3144786" xml-lang="en-US" l10n="U" oldref="147">Entering the value 123.343 and the value 2 in the <emph>count</emph> field will return the value 123.35.</paragraph>
 </section>
@@ -720,8 +713,6 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <emph>Number</emph> is the number whose hyperbolic sine is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3163491" xml-lang="en-US" level="3" l10n="U" oldref="423">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3163504" xml-lang="en-US" l10n="U" oldref="424">If you enter the value -5, -74.2 will be returned as the hyperbolic sine.</paragraph>
-<paragraph role="paragraph" id="par_id3163520" xml-lang="en-US" l10n="U" oldref="425">If you enter the value 0, 0 will be returned as the hyperbolic sine.</paragraph>
-<paragraph role="paragraph" id="par_id3163534" xml-lang="en-US" l10n="U" oldref="426">If you enter the value 90, 6.10E038 will be returned as the hyperbolic sine.</paragraph>
 </section>
 <section id="Section16">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3163596"><bookmark_value>SUM function</bookmark_value>
@@ -756,12 +747,12 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <paragraph role="code" id="par_id3152028" xml-lang="en-US" l10n="U" oldref="439">SUMIF(range; criteria; sum_range)</paragraph>
 <paragraph role="paragraph" id="par_id3152043" xml-lang="en-US" l10n="U" oldref="440">
 <emph>Range</emph> is the range to which the criteria are to be applied.</paragraph>
-<paragraph role="paragraph" id="par_id3152062" xml-lang="en-US" l10n="U" oldref="441">
-<emph>Criteria</emph> is the cell in which the search criterion is shown, or the search criterion itself.</paragraph>
+<paragraph role="paragraph" id="par_id3152062" xml-lang="en-US" l10n="CHG" oldref="441">
+<emph>Criteria</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes.</paragraph>
 <paragraph role="paragraph" id="par_id3152083" xml-lang="en-US" l10n="U" oldref="442">
 <emph>Sum_range</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the <emph>Range</emph> are summed.</paragraph>
 <paragraph role="heading" id="hd_id3152110" xml-lang="en-US" level="3" l10n="U" oldref="443">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3152148" xml-lang="en-US" l10n="U" oldref="626">An example can be found under SUM().</paragraph>
+<paragraph role="paragraph" id="par_id3152148" xml-lang="en-US" l10n="CHG" oldref="626">To sum up only negative numbers: SUMIF(A1:A10;"&lt;0")</paragraph>
 </section>
 <section id="Section14">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value>
@@ -790,7 +781,6 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 <emph>Number</emph> is the number whose hyperbolic tangent is to be calculated.</paragraph>
 <paragraph role="heading" id="hd_id3165527" xml-lang="en-US" level="3" l10n="U" oldref="461">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3165541" xml-lang="en-US" l10n="U" oldref="462">If you enter the value -5, the system returns the hyperbolic tangent -1.</paragraph>
-<paragraph role="paragraph" id="par_id3165556" xml-lang="en-US" l10n="U" oldref="463">If you enter the value 45, the system returns the hyperbolic tangent 1.</paragraph>
 <paragraph role="paragraph" id="par_id3165571" xml-lang="en-US" l10n="U" oldref="464">If you enter the value 90, the system returns the hyperbolic tangent 1.</paragraph>
 </section>
 <section id="Section12">
@@ -917,7 +907,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/>
 <paragraph role="heading" id="hd_id3143672" xml-lang="en-US" level="2" l10n="U" oldref="564">CONVERT</paragraph>
-<paragraph role="paragraph" id="par_id3143708" xml-lang="en-US" l10n="CHG" oldref="565"><ahelp hid="HID_FUNC_UMRECHNEN">This function allows you to convert a currency value of a European currency into Euros.</ahelp><comment>UFI: deleted the path to calc.xhp because it is invalid for SO8 (of course no feature mail...)</comment></paragraph>
+<paragraph role="paragraph" id="par_id3143708" xml-lang="en-US" l10n="CHG" oldref="565"><ahelp hid="HID_FUNC_UMRECHNEN">This function allows you to convert a European currency value into Euros.</ahelp></paragraph>
 <paragraph role="paragraph" id="par_id3143731" xml-lang="en-US" l10n="U" oldref="566">
 <emph>Syntax:</emph>
 </paragraph>
@@ -931,7 +921,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </paragraph>
 <paragraph role="paragraph" id="par_id3143837" xml-lang="en-US" l10n="U" oldref="571">=CONVERT(100;"ATS";"EUR") converts 100 Austrian Schilling into Euro.</paragraph>
 <paragraph role="paragraph" id="par_id3143853" xml-lang="en-US" l10n="U" oldref="572">=CONVERT(100;"EUR";"DEM") converts 100 Euro into German Mark.</paragraph>
-<paragraph role="paragraph" id="par_id3143869" xml-lang="en-US" l10n="CHG" oldref="573">The table shows you the names of the currencies and the rates of exchange with the Euro set by the European Commission. The basis of calculation is 1 Euro.<comment>UFI: deleted outdated link</comment></paragraph>
+<paragraph role="paragraph" id="par_id3143869" xml-lang="en-US" l10n="CHG" oldref="573">The table shows you the names of the currencies and the rates of exchange with the Euro set by the European Commission. The basis of calculation is 1 Euro.</paragraph>
 <table id="tbl_id3143894">
 <tablerow>
 <tablecell colspan="" rowspan="">
@@ -1109,11 +1099,11 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_UNGERADE" id="bm_id3157188" localize="false"/>
 <paragraph role="heading" id="hd_id3157177" xml-lang="en-US" level="2" l10n="U" oldref="502">ODD</paragraph>
-<paragraph role="paragraph" id="par_id3157205" xml-lang="en-US" l10n="U" oldref="503"><ahelp hid="HID_FUNC_UNGERADE">Returns a number rounded up to the nearest odd integer.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3157205" xml-lang="en-US" l10n="CHG" oldref="503"><ahelp hid="HID_FUNC_UNGERADE">Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3157223" xml-lang="en-US" level="3" l10n="U" oldref="504">Syntax:</paragraph>
 <paragraph role="code" id="par_id3157237" xml-lang="en-US" l10n="U" oldref="505">ODD(number)</paragraph>
-<paragraph role="paragraph" id="par_id3157250" xml-lang="en-US" l10n="U" oldref="506">
-<emph>Number</emph> is the number that is to be rounded up.</paragraph>
+<paragraph role="paragraph" id="par_id3157250" xml-lang="en-US" l10n="CHG" oldref="506">
+<emph>Number</emph> is the number that is to be rounded.</paragraph>
 <paragraph role="heading" id="hd_id3157270" xml-lang="en-US" level="3" l10n="U" oldref="507">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3157283" xml-lang="en-US" l10n="U" oldref="508">If you enter the number 1.01, 3 will be returned as the result.</paragraph>
 <paragraph role="paragraph" id="par_id3157298" xml-lang="en-US" l10n="U" oldref="509">If you enter the number -3.01, -5 will be returned as the result.</paragraph>
@@ -1124,20 +1114,20 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/>
 <paragraph role="heading" id="hd_id3157404" xml-lang="en-US" level="2" l10n="U" oldref="512">FLOOR</paragraph>
-<paragraph role="paragraph" id="par_id3157432" xml-lang="en-US" l10n="U" oldref="513"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of significance.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3157432" xml-lang="en-US" l10n="U" oldref="513"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3157451" xml-lang="en-US" level="3" l10n="U" oldref="514">Syntax:</paragraph>
 <paragraph role="code" id="par_id3157464" xml-lang="en-US" l10n="U" oldref="515">FLOOR(Number; Significance; Mode)</paragraph>
 <paragraph role="paragraph" id="par_id3157478" xml-lang="en-US" l10n="U" oldref="516">
 <emph>Number</emph> is the number that is to be rounded down.</paragraph>
 <paragraph role="paragraph" id="par_id3157497" xml-lang="en-US" l10n="U" oldref="517">
 <emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph>
-<paragraph role="paragraph" id="par_id3157517" xml-lang="en-US" l10n="U" oldref="561">
-<emph>Mode</emph> is an optional value. If it is indicated and is not equal to zero, if the number and increment are negative, rounding up is carried out based on that value. It is also possible that this value is ignored after completing an import to MS Excel as Excel does not know any third parameter.</paragraph>
-<paragraph role="warning" id="par_id3163894" xml-lang="en-US" l10n="U" oldref="630">If both parameters <emph>Number</emph> and <emph>Significance</emph> are negative, and if the <emph>Mode</emph> value is equal to zero or is not specified, then the results in $[officename] Calc and Excel will differ after exporting.</paragraph>
+<paragraph role="paragraph" id="par_id3157517" xml-lang="en-US" l10n="CHG" oldref="561">
+<emph>Mode</emph> is an optional value. If the <emph>Mode</emph> value is given and not equal to zero, and if <emph>Number</emph> and <emph>Significance</emph> are negative, then rounding is done based on the absolute value of the number. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter.</paragraph>
+<paragraph role="warning" id="par_id3163894" xml-lang="en-US" l10n="CHG" oldref="630">If both parameters <emph>Number</emph> and <emph>Significance</emph> are negative, and if the <emph>Mode</emph> value is equal to zero or is not specified, then the results in $[officename] Calc and Excel will differ after exporting. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc.</paragraph>
 <paragraph role="heading" id="hd_id3163932" xml-lang="en-US" level="3" l10n="U" oldref="518">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3163945" xml-lang="en-US" l10n="U" oldref="519">If you enter the number 3.4 and the <emph>Significance</emph> 1, 3 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3163966" xml-lang="en-US" l10n="U" oldref="520">If you enter the number -6 and the <emph>Significance </emph>-5, -10 will be returned as the result.</paragraph>
-<paragraph role="paragraph" id="par_id3163988" xml-lang="en-US" l10n="U" oldref="521">If you enter the number -0.6 and the <emph>Significance</emph> -0.4, -0.8 will be returned as the result.</paragraph>
+<paragraph role="paragraph" id="par_id3163945" xml-lang="en-US" l10n="CHG" oldref="519">=FLOOR( -11; -2) returns -12</paragraph>
+<paragraph role="paragraph" id="par_id3163966" xml-lang="en-US" l10n="CHG" oldref="520">=FLOOR( -11; -2; 0) returns -12</paragraph>
+<paragraph role="paragraph" id="par_id3163988" xml-lang="en-US" l10n="CHG" oldref="521">=FLOOR( -11; -2; 1) returns -10</paragraph>
 </section>
 <section id="Section8">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3164086"><bookmark_value>SIGN function</bookmark_value>