source/text/scalc/01/04060106.xhp | 47 ++++++++++++++++++++++++++++++++++++++
1 file changed, 47 insertions(+)
New commits:
commit 74944d4f7fb26dd0db7a94cebf8c66d3023b4aa6
Author: Olivier Hallot <olivier.hal...@edx.srv.br>
Date: Fri Jun 27 22:09:38 2014 -0300
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 <caol...@redhat.com>
Tested-by: Caolán McNamara <caol...@redhat.com>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 1b7a807..9329c36 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
