source/text/scalc/01/04060106.xhp | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 4c58b1b195d7df86ea6ccee322478064f7f8a10a
Author: Eike Rathke <er...@redhat.com>
Date: Tue Aug 9 20:58:39 2016 +0200
clarify on CEILING,CEILING.MATH,CEILING.XCL and FLOOR,FLOOR.MATH,FLOOR.XCL
Change-Id: I557b2be54fad33e540017e093d3261e430e9a152
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 9640ead..639f7e0 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -687,8 +687,8 @@
<paragraph id="par_id3153454" role="code" xml-lang="en-US">CEILING(Number;
Significance; Mode)</paragraph>
<paragraph id="par_id3153467" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded
up.</paragraph>
<paragraph id="par_id3155000" role="paragraph"
xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the
value is to be rounded up.</paragraph>
-<paragraph id="par_id3155020" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is
given and not equal to zero, and if Number and Significance are negative, then
rounding is done based on the absolute value of Number. This parameter is
ignored when exporting to MS Excel as Excel does not know any third
parameter.</paragraph>
-<paragraph id="par_id3163792" role="warning" xml-lang="en-US">If both
parameters Number and Significance 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 id="par_id3155020" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is
given and not equal to zero, and if Number and Significance are negative, then
rounding is done based on the absolute value of Number, i.e. negative numbers
are rounded away from zero. If the Mode value is equal to zero or is not given,
negative numbers are rounded towards zero.</paragraph>
+<paragraph id="par_id3163792" role="warning" xml-lang="en-US">If the
spreadsheet is exported to MS Excel, the CEILING function is exported as the
equivalent CEILING.MATH function that exists since Excel 2013. If you plan to
use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE
that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING
function compatible with all Excel versions. Note that CEILING.XCL always
rounds away from zero.</paragraph>
<paragraph id="hd_id3145697" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3145710" role="paragraph" xml-lang="en-US"><item
type="input">=CEILING(-11;-2)</item> returns -10</paragraph>
@@ -1380,8 +1380,8 @@
<paragraph id="par_id3157464" role="code" xml-lang="en-US">FLOOR(Number;
Significance; Mode)</paragraph>
<paragraph id="par_id3157478" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded
down.</paragraph>
<paragraph id="par_id3157497" role="paragraph"
xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the
number is to be rounded down.</paragraph>
-<paragraph id="par_id3157517" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is
given and not equal to zero, and if Number and Significance are negative, then
rounding is done based on the absolute value of the number. This parameter is
ignored when exporting to MS Excel as Excel does not know any third
parameter.</paragraph>
-<paragraph id="par_id3163894" role="warning" xml-lang="en-US">If both
parameters Number and Significance are negative, and if the Mode 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 id="par_id3157517" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is
given and not equal to zero, and if Number and Significance are negative, then
rounding is done based on the absolute value of Number, i.e. negative numbers
are rounded towards zero. If the Mode value is equal to zero or is not given,
negative numbers are rounded away from zero.</paragraph>
+<paragraph id="par_id3163894" role="warning" xml-lang="en-US">If the
spreadsheet is exported to MS Excel, the FLOOR function is exported as the
equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use
the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that
exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function
compatible with all Excel versions. Note that FLOOR.XCL always rounds towards
zero.</paragraph>
<paragraph id="hd_id3163932" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item
type="input">=FLOOR( -11;-2)</item> returns -12</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
