summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-12-11 07:28:36 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-12-11 11:53:46 +0100
commit12599e24adf517ba6ce1a73915a8d31d887856b8 (patch)
tree03a1803f8c211e859f7f1a3788aa6304c68ac7ce
parenteeb3bd854d8868e7dba8dadd9756e2db4fcce95f (diff)
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.hallot@libreoffice.org> (cherry picked from commit 93981b80416b6d71e79dccf36f946a62d6b3da5d) Reviewed-on: https://gerrit.libreoffice.org/84932
-rw-r--r--source/text/scalc/01/04060106.xhp10
-rw-r--r--source/text/scalc/01/func_networkdays.xhp1
2 files changed, 9 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index b56ed3cda7..a5d890e09d 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 5eeac272c8..f22da61b03 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"/>