Fix fdo#80438: help entries of Excel new functions

write help entrie for FLOOR.PRECISE, CEILING.PRECISE and ISO.CEILING spreadsheet functions

Change-Id: I922fefbc84a7c7842a4510242e1dd477475810a5
Reviewed-on: https://gerrit.libreoffice.org/9948
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

1 files changed, 47 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 1b7a807c27..9329c36630 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -725,6 +725,38 @@ oldref="338">Example</paragraph>
 <item type="input">=CEILING(-11;-2;1)</item> returns -12</paragraph><comment>see also FLOOR, EVEN, ODD, MROUND,   
 INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
 </section>
+<section id="Section31.1">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2952518"><bookmark_value>CEILING.PRECISE function</bookmark_value>
+<bookmark_value>rounding;up to multiples of significance</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id2952530" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2952518" role="heading" level="2" l10n="U" oldref="332">CEILING.PRECISE</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953422" role="paragraph" l10n="CHG" oldref="558"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953440" role="heading" level="3" l10n="U" oldref="334">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953454" role="code" l10n="CHG" oldref="335">CEILING.PRECISE(Number; Significance)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953467" role="paragraph" l10n="U" oldref="336"><emph>Number</emph> (required) is the number that is to be rounded up.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955000" role="paragraph" l10n="CHG" oldref="337"><emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2945697" role="heading" level="3" l10n="U" oldref="338">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2945710" role="paragraph" l10n="CHG" oldref="339">
+<item type="input">=CEILING.PRECISE(-11;-2)</item> returns -10</paragraph>
+<comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
+</section>
+<section id="Section31.2">
+<bookmark xml-lang="en-US" branch="index" id="bm_id8952518"><bookmark_value>ISO.CEILING function</bookmark_value>
+<bookmark_value>rounding;up to multiples of significance</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_ISO" id="bm_id8952530" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id8952518" role="heading" level="2" l10n="U" oldref="332">ISO.CEILING</paragraph>
+<paragraph xml-lang="en-US" id="par_id8953422" role="paragraph" l10n="CHG" oldref="558"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id8953440" role="heading" level="3" l10n="U" oldref="334">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id8953454" role="code" l10n="CHG" oldref="335">ISO.CEILING(Number; Significance)</paragraph>
+<paragraph xml-lang="en-US" id="par_id8953467" role="paragraph" l10n="U" oldref="336"><emph>Number</emph> (required) is the number that is to be rounded up.</paragraph>
+<paragraph xml-lang="en-US" id="par_id8955000" role="paragraph" l10n="CHG" oldref="337"><emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id8945697" role="heading" level="3" l10n="U" oldref="338">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id8945710" role="paragraph" l10n="CHG" oldref="339">
+<item type="input">=ISO.CEILING(-11;-2)</item> returns -10</paragraph>
+<comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
+</section>
 <section id="Section30">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3157762"><bookmark_value>PI function</bookmark_value>
 </bookmark>
@@ -1306,6 +1338,21 @@ oldref="507">Example</paragraph>
 <item type="input">=ODD(-3.1)</item> returns -5.</paragraph><comment>see also CEILING, FLOOR, EVEN, MROUND,   
 INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
 </section>
+<section id="Section9.1">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2957404"><bookmark_value>FLOOR.PRECISE 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"/>
+<paragraph xml-lang="en-US" id="hd_id2957404" role="heading" level="2" l10n="U" oldref="512">FLOOR.PRECISE</paragraph>
+<paragraph xml-lang="en-US" id="par_id2957432" role="paragraph" l10n="U" oldref="513"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2957451" role="heading" level="3" l10n="U" oldref="514">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2957464" role="code" l10n="U" oldref="515">FLOOR.PRECISE(Number; Significance)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2957478" role="paragraph" l10n="U" oldref="516"><emph>Number</emph> is the number that is to be rounded down.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2957497" role="paragraph" l10n="U" oldref="517"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2963932" role="heading" level="3" l10n="U" oldref="518">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2963945" role="paragraph" l10n="CHG" oldref="519"> <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>
 <section id="Section9">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3157404"><bookmark_value>FLOOR function</bookmark_value>
 <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>