source/text/scalc/01/04060110.xhp | 18 ++++++++++++------
1 file changed, 12 insertions(+), 6 deletions(-)
New commits:
commit c48d8ad018dbe18632e3b0454874d4e0b4fb1757
Author: Alain Romedenne <alain.romede...@libreoffice.org>
AuthorDate: Wed Mar 31 16:26:12 2021 +0200
Commit: Rafael Lima <rafael.palma.l...@gmail.com>
CommitDate: Thu Apr 1 20:06:51 2021 +0200
tdf#140553 =FIXED documentation
Change-Id: Id1326425a51e9c687c322e61a17d47ab9072eb4d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113364
Tested-by: Jenkins
Reviewed-by: Steve Fanning <stevemfann...@yahoo.co.uk>
Reviewed-by: Rafael Lima <rafael.palma.l...@gmail.com>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 0c8859a61..8aadf252a 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -289,17 +289,23 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FEST" id="bm_id3149450"
localize="false"/>
<h2 id="hd_id3149268">FIXED</h2>
-<paragraph id="par_id3155833" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal
places and optional thousands separators.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id641617285271044" xml-lang="en-US"><ahelp
hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal
places and optional thousands separators.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id131617201754247"> </paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number;
Decimals [; NoThousandsSeparators])</paragraph>
-<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US">
<emph>Number</emph> refers to the number to be formatted.</paragraph>
-<paragraph id="par_id3156322" role="paragraph" xml-lang="en-US">
<emph>Decimals</emph> refers to the number of decimal places to be
displayed.</paragraph>
-<paragraph id="par_id3150877" role="paragraph" xml-lang="en-US">
<emph>NoThousandsSeparators</emph> (optional) determines whether the thousands
separator is used. If the parameter is a number not equal to 0, the thousands
separator is suppressed. If the parameter is equal to 0 or if it is missing
altogether, the thousands separators of your <link
href="text/shared/optionen/01140000.xhp" name="current locale setting">current
locale setting</link> are displayed.</paragraph>
+<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number;
[Decimals = 2 [; NoThousandsSeparators = FALSE]])</paragraph>
+
+<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is rounded to <literal>Decimals</literal> places (after the
decimal separator) and the result formatted as text, using <link
href="text/shared/optionen/01140000.xhp" name="current locale
setting">locale-specific settings</link>.</paragraph>
+<paragraph id="par_id3156322" role="paragraph" xml-lang="en-US">
<emph>Decimals</emph> (optional) refers to the number of decimal places to be
displayed. If <literal>Decimals</literal> is negative,
<literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places
to the left from the decimal point. If <literal>Decimals</literal> is a
fraction, it is truncated actually ignoring what is the closest
integer.</paragraph>
+<paragraph id="par_id3150877" role="paragraph" xml-lang="en-US">
<emph>NoThousandsSeparators</emph> (optional) determines whether the thousands
separator is used. If it is <literal>TRUE</literal> or non-zero, then group
separators are omitted from the resulting string. If the parameter is equal to
0 or if it is missing altogether, the thousands separators of your <link
href="text/shared/optionen/01140000.xhp" name="current locale setting">current
locale setting</link> are displayed.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3145208" role="paragraph" xml-lang="en-US"> <item
type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text
string. </paragraph>
-<paragraph id="par_id5282143" role="paragraph" xml-lang="en-US"> <item
type="input">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text
string.</paragraph>
+<paragraph id="par_id5282143" role="paragraph" xml-lang="en-US"> <item
type="input">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text
string.</paragraph>
+<paragraph role="paragraph" id="par_id21617202293406" xml-lang="en-US"> <item
type="input">=FIXED(12345.6789;-2)</item> returns 12,300 as a text
string.</paragraph>
+<paragraph role="paragraph" id="par_id161617202295558" xml-lang="en-US"> <item
type="input">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text
string.</paragraph>
+<paragraph role="paragraph" id="par_id451617286696878" xml-lang="en-US"> <item
type="input">=FIXED(12345.789;3/4)</item> returns 12,346 as a text
string.</paragraph>
+<paragraph role="paragraph" id="par_id371617286698199" xml-lang="en-US"> <item
type="input">=FIXED(12345.789,8/5)</item> returns 12,345.8 as a text
string.</paragraph>
</section>
<section id="jis">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
