summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-06-27 22:09:38 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-06-30 09:15:49 +0000
commit74944d4f7fb26dd0db7a94cebf8c66d3023b4aa6 (patch)
tree762d41783e1a90b2bbefbb21e5bc88c4314af604
parent5a0344117e741d078b564f54f07333946a6567c4 (diff)
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>
-rw-r--r--source/text/scalc/01/04060106.xhp47
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>