source/text/scalc/01/04060106.xhp | 10 ++++++++--
source/text/scalc/01/func_networkdays.xhp | 1 +
2 files changed, 9 insertions(+), 2 deletions(-)
New commits:
commit 93981b80416b6d71e79dccf36f946a62d6b3da5d
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Dec 11 07:28:36 2019 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Dec 11 11:51:52 2019 +0100
tdf#129171 more on _XCL and _EXCEL2003
Change-Id: I8892d7534f4a67e4756209f0bbee3cb95d36c59a
Reviewed-on: https://gerrit.libreoffice.org/84928
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 b56ed3cda..a5d890e09 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1538,10 +1538,12 @@
<section id="Section9.1">
<bookmark xml-lang="en-US" branch="index" id="bm_id2957404">
<bookmark_value>FLOOR.PRECISE function</bookmark_value>
+ <bookmark_value>FLOOR.XCL function</bookmark_value>
<bookmark_value>rounding;down to nearest multiple of
significance</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MS" id="bm_id2957415"
localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_PRECISE"
id="bm_id2957215" localize="false"/>
<h2 id="hd_id2957404">FLOOR.PRECISE</h2>
<paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of
Significance, regardless of sign of Significance</ahelp></paragraph>
@@ -1550,7 +1552,7 @@
<paragraph id="par_id2957464" role="code"
xml-lang="en-US">FLOOR.PRECISE(Number; Significance)</paragraph>
<paragraph id="par_id2957478" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded
down.</paragraph>
<paragraph id="par_id2957497" role="paragraph"
xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the
number is to be rounded down.</paragraph>
-
+<embed href="text/scalc/01/04060106.xhp#floor_warn"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2963945" role="paragraph" xml-lang="en-US"><item
type="input">=FLOOR.PRECISE( -11;-2)</item> returns -12</paragraph><comment>see
also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
</section>
@@ -1558,10 +1560,12 @@
<section id="Section9">
<bookmark xml-lang="en-US" branch="index" id="bm_id3157404">
<bookmark_value>FLOOR function</bookmark_value>
+ <bookmark_value>FLOOR.MATH function</bookmark_value>
<bookmark_value>rounding;down to nearest multiple of
significance</bookmark_value>
</bookmark>
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE"
id="bm_id3157415" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MATH"
id="bm_id3167415" localize="false"/>
<h2 id="hd_id3157404">FLOOR</h2>
<paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of
Significance.</ahelp></paragraph>
@@ -1571,7 +1575,9 @@
<paragraph id="par_id3157478" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded
down.</paragraph>
<paragraph id="par_id3157497" role="paragraph"
xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the
number is to be rounded down.</paragraph>
<paragraph id="par_id3157517" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is
given and not equal to zero, and if Number and Significance are negative, then
rounding is done based on the absolute value of Number, i.e. negative numbers
are rounded towards zero. If the Mode value is equal to zero or is not given,
negative numbers are rounded away from zero.</paragraph>
-<warning id="par_id3163894">If the spreadsheet is exported to Microsoft Excel,
the FLOOR function is exported as the equivalent FLOOR.MATH function that
exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel
versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL
that is exported as the FLOOR function compatible with all Excel versions. Note
that FLOOR.XCL always rounds towards zero.</warning>
+<section id="floor_warn">
+ <warning id="par_id3163894">If the spreadsheet is exported to Microsoft
Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function
that exists since Excel 2013. If you plan to use the spreadsheet with earlier
Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or
FLOOR.XCL that is exported as the FLOOR function compatible with all Excel
versions. Note that FLOOR.XCL always rounds towards zero.</warning>
+</section>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item
type="input">=FLOOR( -11;-2)</item> returns -12</paragraph>
diff --git a/source/text/scalc/01/func_networkdays.xhp
b/source/text/scalc/01/func_networkdays.xhp
index 5eeac272c..f22da61b0 100644
--- a/source/text/scalc/01/func_networkdays.xhp
+++ b/source/text/scalc/01/func_networkdays.xhp
@@ -29,6 +29,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3151254">
<bookmark_value>NETWORKDAYS function</bookmark_value>
+ <bookmark_value>NETWORKDAYS_EXCEL2003 function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_NETWORKDAYS"
id="bm_id3153696" localize="false"/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
