[Libreoffice-commits] help.git: source/text

[Olivier Hallot (via logerrit)]

 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.hallot at libreoffice.org>
AuthorDate: Wed Dec 11 07:28:36 2019 -0300
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at 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"/>