aboutsummaryrefslogtreecommitdiff
path: root/source/en-GB/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/en-GB/helpcontent2/source/text/scalc/01.po72
1 files changed, 54 insertions, 18 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index 25ca8cf8d37..f772e1df051 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/01.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-03-29 16:02+0200\n"
+"POT-Creation-Date: 2021-04-06 14:45+0200\n"
"PO-Revision-Date: 2020-12-31 12:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: English (United Kingdom) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/en_GB/>\n"
@@ -21049,50 +21049,50 @@ msgctxt ""
msgid "FIXED"
msgstr "FIXED"
-#. KsG3t
+#. k4v7r
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
-"par_id3155833\n"
+"par_id641617285271044\n"
"help.text"
msgid "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as a text string with a specified number of decimal places and optional thousands separators.</ahelp>"
+msgstr ""
-#. CEftz
+#. vGkWA
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3147567\n"
"help.text"
-msgid "FIXED(Number; Decimals [; NoThousandsSeparators])"
+msgid "FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])"
msgstr ""
-#. 5cYW8
+#. Lu9oq
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3151272\n"
"help.text"
-msgid "<emph>Number</emph> refers to the number to be formatted."
-msgstr "<emph>Number</emph> refers to the number to be formatted."
+msgid "<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>."
+msgstr ""
-#. hSSQr
+#. 5zSz5
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3156322\n"
"help.text"
-msgid "<emph>Decimals</emph> refers to the number of decimal places to be displayed."
-msgstr "<emph>Decimals</emph> refers to the number of decimal places to be displayed."
+msgid "<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."
+msgstr ""
-#. HQVFQ
+#. MccEk
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3150877\n"
"help.text"
-msgid "<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."
-msgstr "<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 omitted, the thousands separators of your <link href=\"text/shared/optionen/01140000.xhp\" name=\"current locale setting\">current locale setting</link> are displayed."
+msgid "<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."
+msgstr ""
#. nDs7Q
#: 04060110.xhp
@@ -21103,14 +21103,50 @@ msgctxt ""
msgid "<item type=\"input\">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text string."
msgstr "<item type=\"input\">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text string."
-#. ZsPhE
+#. eo6wB
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id5282143\n"
"help.text"
-msgid "<item type=\"input\">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text string."
-msgstr "<item type=\"input\">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text string."
+msgid "<item type=\"input\">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string."
+msgstr ""
+
+#. U8QaS
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id21617202293406\n"
+"help.text"
+msgid "<item type=\"input\">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string."
+msgstr ""
+
+#. iqSth
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id161617202295558\n"
+"help.text"
+msgid "<item type=\"input\">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string."
+msgstr ""
+
+#. NmXWD
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id451617286696878\n"
+"help.text"
+msgid "<item type=\"input\">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string."
+msgstr ""
+
+#. wHPtQ
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id371617286698199\n"
+"help.text"
+msgid "<item type=\"input\">=FIXED(12345.789,8/5)</item> returns 12,345.8 as a text string."
+msgstr ""
#. zxsGX
#: 04060110.xhp