diff options
| author | Alain Romedenne <alain.romedenne@libreoffice.org> | 2021-03-31 16:26:12 +0200 |
|---|---|---|
| committer | Rafael Lima <rafael.palma.lima@gmail.com> | 2021-04-01 20:06:51 +0200 |
| commit | c48d8ad018dbe18632e3b0454874d4e0b4fb1757 (patch) | |
| tree | ee0efb283f7cf38c8862e9dec589fb001567ca1c | |
| parent | BASIC Toc cleanup (diff) | |
| download | help-c48d8ad018dbe18632e3b0454874d4e0b4fb1757.tar.gz help-c48d8ad018dbe18632e3b0454874d4e0b4fb1757.zip | |
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>
| -rw-r--r-- | source/text/scalc/01/04060110.xhp | 18 |
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"> |