tdf#140553 =FIXED documentation

Change-Id: Id1326425a51e9c687c322e61a17d47ab9072eb4d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113364
Tested-by: Jenkins
Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk>
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>

1 files changed, 12 insertions, 6 deletions

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 0c8859a615..8aadf252a8 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">