update translations for master

and force-fix errors using pocheck Change-Id: I9f37f1bad2c1005d8b63991fb1a66cd2f14e259b
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-04-15 14:08:14 +0200
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-04-15 14:12:29 +0200
commit: 1cf550347fdb87391903b533dd1c47135875a9d7 (patch)
tree: 42aeb67f0d164abb01f73d6ddc7c1d8927a253a3 /source/en-GB/helpcontent2
parent: 0a73e51795ef412006c59d3723f265fed445dea1 (diff)
13 files changed, 1471 insertions, 994 deletions
diff --git a/source/en-GB/helpcontent2/source/auxiliary.po b/source/en-GB/helpcontent2/source/auxiliary.po
index 971a33a4bb7..3b30ebb0891 100644
--- a/source/en-GB/helpcontent2/source/auxiliary.po
+++ b/source/en-GB/helpcontent2/source/auxiliary.po
@@ -4,7 +4,7 @@ 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: 2020-03-31 10:34+0200\n"
-"PO-Revision-Date: 2020-02-05 07:19+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/auxiliary/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1563447496.000000\n"
 
 #. fEEXD
@@ -248,7 +248,7 @@ msgctxt ""
 "08101\n"
 "node.text"
 msgid "Subtotals"
-msgstr ""
+msgstr "Subtotals"
 
 #. CzARM
 #: scalc.tree
diff --git a/source/en-GB/helpcontent2/source/text/sbasic/python.po b/source/en-GB/helpcontent2/source/text/sbasic/python.po
index 81be0081cef..01b15026ab1 100644
--- a/source/en-GB/helpcontent2/source/text/sbasic/python.po
+++ b/source/en-GB/helpcontent2/source/text/sbasic/python.po
@@ -4,7 +4,7 @@ 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: 2020-02-10 17:54+0100\n"
-"PO-Revision-Date: 2020-02-05 20:05+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicpython/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1565599713.000000\n"
 
 #. naSFZ
@@ -329,7 +329,7 @@ msgctxt ""
 "N0374\n"
 "help.text"
 msgid "At time of development you can interrupt Python script execution using <link href=\"https://berma.pagesperso-orange.fr/index2.html\" name=\"Xray extension\">Xray extension</link> in order to inspect properties and methods of UNO objects. The APSO extension debugger allows object introspection using either Xray either MRI extensions."
-msgstr ""
+msgstr "At time of development you can interrupt Python script execution using <link href=\"https://berma.pagesperso-orange.fr/index2.html\" name=\"Xray extension\">Xray extension</link> in order to inspect properties and methods of UNO objects. The APSO extension debugger allows object introspection using either Xray either MRI extensions."
 
 #. F8dF9
 #: python_2_basic.xhp
diff --git a/source/en-GB/helpcontent2/source/text/sbasic/shared.po b/source/en-GB/helpcontent2/source/text/sbasic/shared.po
index 94ed5ba868f..28169be1a65 100644
--- a/source/en-GB/helpcontent2/source/text/sbasic/shared.po
+++ b/source/en-GB/helpcontent2/source/text/sbasic/shared.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: 2020-04-03 11:46+0200\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
 "PO-Revision-Date: 2020-02-29 17:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/en_GB/>\n"
@@ -2788,15 +2788,6 @@ msgctxt ""
 msgid "The <literal>Function</literal> is called using the following syntax:"
 msgstr ""
 
-#. yBxwK
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3146914\n"
-"help.text"
-msgid "Variable=FunctionName(Parameter1, Parameter2,...)"
-msgstr "Variable=FunctionName(Parameter1, Parameter2,...)"
-
 #. 33Sss
 #: 01020300.xhp
 msgctxt ""
@@ -2869,15 +2860,6 @@ msgctxt ""
 msgid "If you want to pass a parameter by value insert the key word <literal>ByVal</literal> in front of the parameter when you call a <literal>Sub</literal>, a <literal>Function</literal> or a <literal>Property</literal>, for example:"
 msgstr ""
 
-#. Vzu4F
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150042\n"
-"help.text"
-msgid "Function ReadOnlyParms(ByVal p2, ByVal p2)"
-msgstr ""
-
 #. pojXe
 #: 01020300.xhp
 msgctxt ""
@@ -2887,24 +2869,6 @@ msgctxt ""
 msgid "' your code goes here"
 msgstr ""
 
-#. MGPNc
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id131584367516784\n"
-"help.text"
-msgid "End Function"
-msgstr ""
-
-#. bz6EJ
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id801584367475787\n"
-"help.text"
-msgid "result = ReadOnlyParms(parm1, parm2)"
-msgstr ""
-
 #. WF4ND
 #: 01020300.xhp
 msgctxt ""
@@ -2932,15 +2896,6 @@ msgctxt ""
 msgid "Functions, procedures or properties can be defined with optional parameters, for example:"
 msgstr ""
 
-#. qBTxH
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id761584366669997\n"
-"help.text"
-msgid "Sub Rounding(number, Optional decimals, Optional format)"
-msgstr ""
-
 #. JKj8y
 #: 01020300.xhp
 msgctxt ""
@@ -2950,15 +2905,6 @@ msgctxt ""
 msgid "' your code goes here"
 msgstr ""
 
-#. NtvTc
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id251584366745722\n"
-"help.text"
-msgid "End Sub"
-msgstr ""
-
 #. EHCCS
 #: 01020300.xhp
 msgctxt ""
@@ -2986,15 +2932,6 @@ msgctxt ""
 msgid "Declaring Variables Outside a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>"
 msgstr ""
 
-#. Q3jEW
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150208\n"
-"help.text"
-msgid "Global VarName As TYPENAME"
-msgstr "Global VarName As TYPENAME"
-
 #. 5JwAY
 #: 01020300.xhp
 msgctxt ""
@@ -3004,15 +2941,6 @@ msgctxt ""
 msgid "The variable is valid as long as the %PRODUCTNAME session lasts."
 msgstr ""
 
-#. CSDs2
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3153198\n"
-"help.text"
-msgid "Public VarName As TYPENAME"
-msgstr "Public VarName As TYPENAME"
-
 #. 9akEs
 #: 01020300.xhp
 msgctxt ""
@@ -3022,15 +2950,6 @@ msgctxt ""
 msgid "The variable is valid in all modules."
 msgstr "The variable is valid in all modules."
 
-#. ADEKE
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3158212\n"
-"help.text"
-msgid "Private VarName As TYPENAME"
-msgstr "Private VarName As TYPENAME"
-
 #. qeJQx
 #: 01020300.xhp
 msgctxt ""
@@ -3040,15 +2959,6 @@ msgctxt ""
 msgid "The variable is only valid in this module."
 msgstr "The variable is only valid in this module."
 
-#. WQdbC
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150886\n"
-"help.text"
-msgid "Dim VarName As TYPENAME"
-msgstr "Dim VarName As TYPENAME"
-
 #. 85TYe
 #: 01020300.xhp
 msgctxt ""
@@ -3130,15 +3040,6 @@ msgctxt ""
 msgid "Saving Variable Content after Exiting a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>"
 msgstr ""
 
-#. qV9Bm
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3156288\n"
-"help.text"
-msgid "Static VarName As TYPENAME"
-msgstr "Static VarName As TYPENAME"
-
 #. hAB34
 #: 01020300.xhp
 msgctxt ""
@@ -17512,32 +17413,32 @@ msgctxt ""
 msgid "Error-Handling Functions"
 msgstr "Error-Handling Functions"
 
-#. zqvGA
+#. yMyAz
 #: 03050000.xhp
 msgctxt ""
 "03050000.xhp\n"
 "hd_id3143271\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link>"
-msgstr "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link>"
+msgid "<variable id=\"ErrHandlingh1\"><link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link></variable>"
+msgstr ""
 
-#. BfMGz
+#. KsiEx
 #: 03050000.xhp
 msgctxt ""
 "03050000.xhp\n"
 "par_id3145068\n"
 "help.text"
-msgid "Use the following statements and functions to define the way $[officename] Basic reacts to run-time errors."
-msgstr "Use the following statements and functions to define the way $[officename] Basic reacts to run-time errors."
+msgid "Use the following statements and functions to define the way %PRODUCTNAME Basic reacts to run-time errors."
+msgstr ""
 
-#. acGyE
+#. 9XGsZ
 #: 03050000.xhp
 msgctxt ""
 "03050000.xhp\n"
 "par_id3148946\n"
 "help.text"
-msgid "$[officename] Basic offers several methods to prevent the termination of a program when a run-time error occurs."
-msgstr "$[officename] Basic offers several methods to prevent the termination of a program when a run-time error occurs."
+msgid "%PRODUCTNAME Basic offers several methods to prevent the termination of a program when a run-time error occurs."
+msgstr ""
 
 #. C2vFE
 #: 03050100.xhp
@@ -17944,6 +17845,15 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntax:"
 
+#. fGsdv
+#: 03050500.xhp
+msgctxt ""
+"03050500.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/On-Error_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">On Error Statement diagram</alt></image>"
+msgstr ""
+
 #. 7FXhq
 #: 03050500.xhp
 msgctxt ""
@@ -22993,14 +22903,14 @@ msgctxt ""
 msgid "For...Next Statement"
 msgstr "For...Next Statement"
 
-#. YGeU7
+#. Byex6
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "bm_id3149205\n"
 "help.text"
-msgid "<bookmark_value>For statement</bookmark_value>  <bookmark_value>To statement</bookmark_value>  <bookmark_value>Step statement</bookmark_value>  <bookmark_value>Next statement</bookmark_value>"
-msgstr "<bookmark_value>For statement</bookmark_value>  <bookmark_value>To statement</bookmark_value>  <bookmark_value>Step statement</bookmark_value>  <bookmark_value>Next statement</bookmark_value>"
+msgid "<bookmark_value>For statement</bookmark_value>  <bookmark_value>For Each statement</bookmark_value>  <bookmark_value>In keyword</bookmark_value>  <bookmark_value>Next keyword</bookmark_value>  <bookmark_value>Step keyword</bookmark_value>  <bookmark_value>To keyword</bookmark_value>  <bookmark_value>Step keyword</bookmark_value>"
+msgstr ""
 
 #. LVP76
 #: 03090202.xhp
@@ -23011,14 +22921,14 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03090202.xhp\" name=\"For...Next Statement\">For...Next Statement</link>"
 msgstr "<link href=\"text/sbasic/shared/03090202.xhp\" name=\"For...Next Statement\">For...Next Statement</link>"
 
-#. P6gje
+#. AFEvH
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3143267\n"
 "help.text"
-msgid "Repeats the statements between the For...Next block a specified number of times."
-msgstr "Repeats the statements between the For...Next block a specified number of times."
+msgid "Repeats the statements between the <literal>For...Next</literal> block a specified number of times."
+msgstr ""
 
 #. h79GC
 #: 03090202.xhp
@@ -23029,50 +22939,59 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntax:"
 
-#. 7GuT6
+#. UqJyC
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3148473\n"
+"par_id491585753339474\n"
 "help.text"
-msgid "For counter=start To end [Step step]"
-msgstr "For counter=start To end [Step step]"
+msgid "<image src=\"media/helpimg/sbasic/For-Next_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">For Statement diagram</alt></image>"
+msgstr ""
 
-#. Qn7bF
+#. SuZFA
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3156024\n"
 "help.text"
-msgid "statement block"
-msgstr "statement block"
+msgid "statement-block"
+msgstr ""
 
-#. 5H2nw
+#. CCuTr
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3146796\n"
+"par_id3159414\n"
 "help.text"
-msgid "[Exit For]"
-msgstr "[Exit For]"
+msgid "statement-block"
+msgstr ""
 
-#. oPL7W
+#. bcKDQ
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3159414\n"
+"par_id491585653339474\n"
 "help.text"
-msgid "statement block"
-msgstr "statement block"
+msgid "<image src=\"media/helpimg/sbasic/For-Each_statement.svg\" id=\"img_id4156297484514\"><alt id=\"alt_id15152797484514\">For Each Statement diagram</alt></image>"
+msgstr ""
 
-#. 7DuFn
+#. YbrKJ
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3153897\n"
+"bas_id821586521234861\n"
 "help.text"
-msgid "Next [counter]"
-msgstr "Next [counter]"
+msgid "statement-block"
+msgstr ""
+
+#. 75jXr
+#: 03090202.xhp
+msgctxt ""
+"03090202.xhp\n"
+"bas_id501586521235517\n"
+"help.text"
+msgid "statement-block"
+msgstr ""
 
 #. hE24y
 #: 03090202.xhp
@@ -23083,41 +23002,41 @@ msgctxt ""
 msgid "Variables:"
 msgstr "Variables:"
 
-#. H4t3c
+#. iPLzw
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3150358\n"
 "help.text"
-msgid "<emph>Counter:</emph> Loop counter initially assigned the value to the right of the equal sign (start). Only numeric variables are valid. The loop counter increases or decreases according to the variable Step until End is passed."
-msgstr "<emph>Counter:</emph> Loop counter initially assigned the value to the right of the equal sign (start). Only numeric variables are valid. The loop counter increases or decreases according to the variable Step until End is passed."
+msgid "<emph>counter:</emph> Loop <literal>counter</literal> initially assigned the value to the right of the equal sign (<literal>start</literal>). Only numeric variables are valid. The loop counter increases or decreases according to the variable <literal>step</literal> until <literal>end</literal> is passed."
+msgstr ""
 
-#. PBGU7
+#. crpJL
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3152455\n"
 "help.text"
-msgid "<emph>Start:</emph> Numeric variable that defines the initial value at the beginning of the loop."
-msgstr "<emph>Start:</emph> Numeric variable that defines the initial value at the beginning of the loop."
+msgid "<emph>start:</emph> Numeric variable that defines the initial value at the beginning of the loop."
+msgstr ""
 
-#. B53Sh
+#. u8ZEL
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3151043\n"
 "help.text"
-msgid "<emph>End:</emph> Numeric variable that defines the final value at the end of the loop."
-msgstr "<emph>End:</emph> Numeric variable that defines the final value at the end of the loop."
+msgid "<emph>end:</emph> Numeric variable that defines the final value at the end of the loop."
+msgstr ""
 
-#. RN6Cp
+#. TmxSC
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3156281\n"
 "help.text"
-msgid "<emph>Step:</emph> Sets the value by which to increase or decrease the loop counter. If Step is not specified, the loop counter is incremented by 1. In this case, End must be greater than Start. If you want to decrease Counter, End must be less than Start, and Step must be assigned a negative value."
-msgstr "<emph>Step:</emph> Sets the value by which to increase or decrease the loop counter. If Step is not specified, the loop counter is incremented by 1. In this case, End must be greater than Start. If you want to decrease Counter, End must be less than Start and Step must be assigned a negative value."
+msgid "<emph>step:</emph> Sets the value by which to increase or decrease the loop counter. If <literal>step</literal> is not specified, the loop counter is incremented by 1. In this case, <literal>end</literal> must be greater than <literal>start</literal>. If you want to decrease <literal>counter</literal>, <literal>end</literal> must be less than <literal>start</literal>, and <literal>step</literal> must be assigned a negative value."
+msgstr ""
 
 #. VMWd9
 #: 03090202.xhp
@@ -23128,14 +23047,14 @@ msgctxt ""
 msgid "The <emph>For...Next</emph> loop repeats all of the statements in the loop for the number of times that is specified by the parameters."
 msgstr "The <emph>For...Next</emph> loop repeats all of the statements in the loop for the number of times that is specified by the parameters."
 
-#. MzbXT
+#. 6pQ2G
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3147287\n"
 "help.text"
-msgid "As the counter variable is decreased, $[officename] Basic checks if the end value has been reached. As soon as the counter passes the end value, the loop automatically ends."
-msgstr "As the counter variable is decreased, $[officename] Basic checks it against the end value. As soon as the counter passes the end value, the loop automatically ends."
+msgid "As the <literal>counter</literal> variable is decreased, %PRODUCTNAME Basic checks if the <literal>end</literal> value has been reached. As soon as the <literal>counter</literal> passes the <literal>end</literal> value, the loop automatically terminates."
+msgstr ""
 
 #. hFEyc
 #: 03090202.xhp
@@ -23155,14 +23074,14 @@ msgctxt ""
 msgid "If you specify an increment of 0, the statements between <emph>For</emph> and <emph>Next</emph> are repeated continuously."
 msgstr "If you specify an increment of 0, the statements between <emph>For</emph> and <emph>Next</emph> are repeated for ever."
 
-#. wMUFA
+#. Xxfcy
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3155854\n"
 "help.text"
-msgid "When counting down the counter variable, $[officename] Basic checks for overflow or underflow. The loop ends when Counter exceeds End (positive Step value) or is less than End (negative Step value)."
-msgstr "When counting down the counter variable, $[officename] Basic checks for overflow or underflow. The loop ends when Counter exceeds End (positive Step value) or is less than End (negative Step value)."
+msgid "When counting down the counter variable, %PRODUCTNAME Basic checks for overflow or underflow. The loop ends when <literal>counter</literal> exceeds <literal>end</literal> (positive Step value) or is less than <literal>end</literal> (negative Step value)."
+msgstr ""
 
 #. DNpBx
 #: 03090202.xhp
@@ -23173,167 +23092,113 @@ msgctxt ""
 msgid "Use the <emph>Exit For</emph> statement to exit the loop unconditionally. This statement must be within a <emph>For...Next</emph> loop. Use the <emph>If...Then</emph> statement to test the exit condition as follows:"
 msgstr "Use the <emph>Exit For</emph> statement to exit the loop unconditionally. This statement must be within a <emph>For...Next</emph> loop. Use the <emph>If...Then</emph> statement to test the exit condition as follows:"
 
-#. vYTyG
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3153190\n"
-"help.text"
-msgid "For..."
-msgstr "For..."
-
-#. AeEhE
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3149482\n"
-"help.text"
-msgid "statements"
-msgstr "statements"
-
-#. qvVwR
+#. M36BA
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3147124\n"
+"bas_id621586522583437\n"
 "help.text"
-msgid "If condition = True Then Exit For"
-msgstr "If condition = True Then Exit For"
+msgid "statement-block"
+msgstr ""
 
-#. FuKCd
+#. k56rG
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3153159\n"
+"bas_id711586522584013\n"
 "help.text"
-msgid "statements"
-msgstr "statements"
-
-#. LoD97
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3154096\n"
-"help.text"
-msgid "Next"
-msgstr "Next"
+msgid "statement-block"
+msgstr ""
 
-#. KfKRR
+#. C2e3R
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3156286\n"
 "help.text"
-msgid "Note: In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited."
-msgstr "Note: In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited."
+msgid "In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited."
+msgstr ""
 
-#. McR4Z
+#. Xo6Nj
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "hd_id3148457\n"
 "help.text"
-msgid "Example"
-msgstr "Example"
+msgid "Examples"
+msgstr ""
 
-#. 3hXfC
+#. mdCY2
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
 "par_id3151074\n"
 "help.text"
-msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that are first filled with various contents:"
-msgstr "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ) that contain various values:"
-
-#. k2qGE
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3155767\n"
-"help.text"
-msgid "sEntry(0) = \"Jerry\""
-msgstr "sEntry(0) = \"Jerry\""
-
-#. jfGrU
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3153711\n"
-"help.text"
-msgid "sEntry(1) = \"Patty\""
-msgstr "sEntry(1) = \"Patty\""
+msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that is filled with various contents:"
+msgstr ""
 
-#. LBHzA
+#. uEoLD
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3148993\n"
+"par_id561586524231943\n"
 "help.text"
-msgid "sEntry(2) = \"Kurt\""
-msgstr "sEntry(2) = \"Kurt\""
+msgid "This explores the content of an array to display each item it contains."
+msgstr ""
 
-#. hBFon
+#. TGDLQ
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3156382\n"
+"bas_id511586523090639\n"
 "help.text"
-msgid "sEntry(3) = \"Thomas\""
-msgstr "sEntry(3) = \"Thomas\""
+msgid "Sub list_iteration"
+msgstr ""
 
-#. 2Afje
+#. biVQS
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3155174\n"
+"bas_id391586523091799\n"
 "help.text"
-msgid "sEntry(4) = \"Michael\""
-msgstr "sEntry(4) = \"Michael\""
+msgid "cutlery = Array(\"fork\", \"knife\", \"spoon\")"
+msgstr ""
 
-#. SGKJB
+#. AupdW
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3166448\n"
+"bas_id811586523092655\n"
 "help.text"
-msgid "sEntry(5) = \"David\""
-msgstr "sEntry(5) = \"David\""
-
-#. 856Y8
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3149255\n"
-"help.text"
-msgid "sEntry(6) = \"Cathy\""
-msgstr "sEntry(6) = \"Cathy\""
+msgid "For Each item in cutlery"
+msgstr ""
 
-#. qAQBw
+#. BdxhG
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3149565\n"
+"bas_id271586523092911\n"
 "help.text"
-msgid "sEntry(7) = \"Susie\""
-msgstr "sEntry(7) = \"Susie\""
+msgid "Print item"
+msgstr ""
 
-#. zUTiM
+#. Pjkxm
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3145148\n"
+"bas_id941586523093415\n"
 "help.text"
-msgid "sEntry(8) = \"Edward\""
-msgstr "sEntry(8) = \"Edward\""
+msgid "Next ' item"
+msgstr ""
 
-#. AsMRN
+#. ArG25
 #: 03090202.xhp
 msgctxt ""
 "03090202.xhp\n"
-"par_id3145229\n"
+"bas_id301586523093607\n"
 "help.text"
-msgid "sEntry(9) = \"Christine\""
-msgstr "sEntry(9) = \"Christine\""
+msgid "End Sub"
+msgstr ""
 
 #. GD68h
 #: 03090203.xhp
@@ -24118,14 +23983,14 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03090401.xhp\" name=\"Call Statement\">Call Statement</link>"
 msgstr "<link href=\"text/sbasic/shared/03090401.xhp\" name=\"Call Statement\">Call Statement</link>"
 
-#. wneEE
+#. nPKzF
 #: 03090401.xhp
 msgctxt ""
 "03090401.xhp\n"
 "par_id3153394\n"
 "help.text"
-msgid "Transfers the control of the program to a subroutine, a function, or a DLL procedure."
-msgstr "Transfers the control of the program to a subroutine, a function, or a DLL procedure."
+msgid "Transfers the control of the program to a subroutine, a function, or a procedure of a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">Dynamic Link Library (DLL)</link>. The keyword, type and number of parameters is dependent on the routine that is being called."
+msgstr ""
 
 #. MdeJS
 #: 03090401.xhp
@@ -24163,32 +24028,50 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parameters:"
 
-#. dbwfN
+#. C2MXB
 #: 03090401.xhp
 msgctxt ""
 "03090401.xhp\n"
 "par_id3148473\n"
 "help.text"
-msgid "<emph>name:</emph> Name of the subroutine, the function, or the DLL that you want to call"
+msgid "<emph>name:</emph> Name of the subroutine, the function, or the <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">DLL</link> that you want to call"
 msgstr ""
 
-#. iFYrJ
+#. 23rrr
 #: 03090401.xhp
 msgctxt ""
 "03090401.xhp\n"
 "par_id3148946\n"
 "help.text"
-msgid "<emph>param:</emph> Parameters to pass to the procedure. The keyword, type and number of parameters is dependent on the routine that is being called."
+msgid "<emph>param:</emph> Keyword parameter name to pass to the routine, followed by its <emph>value</emph>. The name must match the routine declaration. Keywords are optional and can be used in any order."
 msgstr ""
 
-#. 4LVmZ
+#. r9JSP
+#: 03090401.xhp
+msgctxt ""
+"03090401.xhp\n"
+"par_id871586190690812\n"
+"help.text"
+msgid "<emph>value:</emph> Positional parameter value. The type is dependent on the routine that is being called"
+msgstr ""
+
+#. gANH7
+#: 03090401.xhp
+msgctxt ""
+"03090401.xhp\n"
+"par_id421586006407428\n"
+"help.text"
+msgid "When mixing positional and keyword parameters, make sure positional parameters are following the routine declaration order."
+msgstr ""
+
+#. xFXk8
 #: 03090401.xhp
 msgctxt ""
 "03090401.xhp\n"
 "par_id3154216\n"
 "help.text"
-msgid "A keyword is optional when you call a procedure. If a function is executed as an expression, the parameters must be enclosed by brackets in the statement. If a DLL is called, it must first be specified in the <emph>Declare-Statement</emph>."
-msgstr "A keyword is optional when you call a procedure. If a function is executed as an expression, the parameters must be enclosed by brackets ( ) in the statement. If a DLL is called, it must first be specified in the <emph>Declare Statement</emph>."
+msgid "When a function is used as an expression, enclosing parameters with brackets becomes necessary. Using a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Declare Statement\">Declare statement</link> is compulsory prior to call a DLL."
+msgstr ""
 
 #. QZZ8c
 #: 03090401.xhp
@@ -25900,14 +25783,14 @@ msgctxt ""
 msgid "<bookmark_value>CVErr function</bookmark_value>"
 msgstr "<bookmark_value>CVErr function</bookmark_value>"
 
-#. hpChf
+#. zHAeD
 #: 03100080.xhp
 msgctxt ""
 "03100080.xhp\n"
 "par_idN1054B\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link>"
-msgstr "<link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link>"
+msgid "<variable id=\"CvErrh1\"><link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link></variable>"
+msgstr ""
 
 #. 3B8u2
 #: 03100080.xhp
@@ -28681,14 +28564,14 @@ msgctxt ""
 msgid "<bookmark_value>IsError function</bookmark_value>"
 msgstr "<bookmark_value>IsError function</bookmark_value>"
 
-#. CG3nf
+#. FDXnr
 #: 03102450.xhp
 msgctxt ""
 "03102450.xhp\n"
 "par_idN1054E\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link>"
-msgstr "<link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link>"
+msgid "<variable id=\"IsErrorh1\"><link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link></variable>"
+msgstr ""
 
 #. yQg58
 #: 03102450.xhp
@@ -29374,14 +29257,14 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntax:"
 
-#. 6bD7g
+#. ZR3gW
 #: 03103100.xhp
 msgctxt ""
 "03103100.xhp\n"
-"par_id3154285\n"
+"par_id41586012988213\n"
 "help.text"
-msgid "[Let] VarName=Expression"
-msgstr "[Let] VarName=Expression"
+msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Let Statement diagram</alt></image>"
+msgstr ""
 
 #. X4WmE
 #: 03103100.xhp
@@ -29392,14 +29275,14 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parameters:"
 
-#. GDfsk
+#. DpLuj
 #: 03103100.xhp
 msgctxt ""
 "03103100.xhp\n"
 "par_id3147560\n"
 "help.text"
-msgid "<emph>VarName:</emph> Variable that you want to assign a value to. Value and variable type must be compatible."
-msgstr "<emph>VarName:</emph> Variable that you want to assign a value to. Value and variable type must be compatible."
+msgid "<emph>variable:</emph> Variable that you want to assign a value to. Value and variable type must be compatible."
+msgstr ""
 
 #. ZCswn
 #: 03103100.xhp
@@ -30103,14 +29986,14 @@ msgctxt ""
 msgid "Set Statement"
 msgstr "Set Statement"
 
-#. zHGh5
+#. GzHJQ
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "bm_id3154422\n"
 "help.text"
-msgid "<bookmark_value>Set statement</bookmark_value>  <bookmark_value>Nothing object</bookmark_value>"
-msgstr "<bookmark_value>Set statement</bookmark_value>  <bookmark_value>Nothing object</bookmark_value>"
+msgid "<bookmark_value>Set statement</bookmark_value>  <bookmark_value>New keyword</bookmark_value>  <bookmark_value>Nothing object</bookmark_value>"
+msgstr ""
 
 #. eramH
 #: 03103700.xhp
@@ -30121,14 +30004,14 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03103700.xhp\" name=\"Set Statement\">Set Statement</link>"
 msgstr "<link href=\"text/sbasic/shared/03103700.xhp\" name=\"Set Statement\">Set Statement</link>"
 
-#. EZQ7H
+#. qNuUW
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "par_id3159149\n"
 "help.text"
-msgid "Sets an object reference on a variable or a Property."
-msgstr "Sets an object reference on a variable or a Property."
+msgid "Sets an object reference on a variable."
+msgstr ""
 
 #. MkkED
 #: 03103700.xhp
@@ -30139,14 +30022,23 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntax:"
 
-#. VNH9y
+#. DiSYW
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Set Statement diagram</alt></image>"
+msgstr ""
+
+#. P5Xm2
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "par_id3154217\n"
 "help.text"
-msgid "Set ObjectVar = Object"
-msgstr "Set ObjectVar = Object"
+msgid "Set variable = object"
+msgstr ""
 
 #. r4fJx
 #: 03103700.xhp
@@ -30157,32 +30049,41 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parameters:"
 
-#. CMGdW
+#. K6c5D
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "par_id3156281\n"
 "help.text"
-msgid "<emph>ObjectVar:</emph> a variable or a property that requires an object reference."
-msgstr "<emph>ObjectVar:</emph> a variable or a property that requires an object reference."
+msgid "<emph>variable:</emph> a variable or a property that requires an object reference."
+msgstr ""
 
-#. F7X5E
+#. kSZDp
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "par_id3159252\n"
 "help.text"
-msgid "<emph>Object:</emph> Object that the variable or the property refers to."
-msgstr "<emph>Object:</emph> Object to which the variable or the property refers."
+msgid "<emph>object:</emph> Object that the variable refers to."
+msgstr ""
 
-#. 27u9f
+#. goUzz
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "par_idN10623\n"
 "help.text"
-msgid "<emph>Nothing</emph> - Assign the <emph>Nothing</emph> object to a variable to remove a previous assignment."
-msgstr "<emph>Nothing</emph> - Assign the <emph>Nothing</emph> object to a variable to remove a previous assignment."
+msgid "<emph>Nothing</emph> - Assign <emph>Nothing</emph> to a variable to remove a previous assignment."
+msgstr ""
+
+#. PUiZf
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id101586014505785\n"
+"help.text"
+msgid "The keyword <emph>Set</emph> is optional."
+msgstr ""
 
 #. SGsRz
 #: 03103700.xhp
@@ -30193,6 +30094,15 @@ msgctxt ""
 msgid "Example:"
 msgstr "Example:"
 
+#. dt2A8
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id841586014507226\n"
+"help.text"
+msgid "Use <emph>New</emph> only to assign a <link href=\"text/sbasic/shared/classmodule\" name=\"ClassModule\">class module</link> instance to a variable."
+msgstr ""
+
 #. ukqdX
 #: 03103800.xhp
 msgctxt ""
@@ -40174,6 +40084,186 @@ msgctxt ""
 msgid "See also <link href=\"text/sbasic/shared/00000002.xhp\" name=\"external\">URL Notation</link>"
 msgstr "See also <link href=\"text/sbasic/shared/00000002.xhp\" name=\"external\">URL Notation</link>"
 
+#. PRG9t
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"tit\n"
+"help.text"
+msgid "Resume Statement"
+msgstr ""
+
+#. sMcg4
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0001\n"
+"help.text"
+msgid "<bookmark_value>Resume statement</bookmark_value>"
+msgstr ""
+
+#. LTupm
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0002\n"
+"help.text"
+msgid "<variable id=\"resumeh1\"><link href=\"text/sbasic/shared/Resume.xhp\" name=\"Resume statement\">Resume Statement</link></variable>"
+msgstr ""
+
+#. AVhyb
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0003\n"
+"help.text"
+msgid "Resets error information and indicates what to execute next."
+msgstr ""
+
+#. FhZm3
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/Resume_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Resume Statement diagram</alt></image>"
+msgstr ""
+
+#. KAJEM
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id481586090298901\n"
+"help.text"
+msgid "<emph>0: </emph>Resets error information and re-executes the instruction that caused the error. <emph>0</emph> is optional."
+msgstr ""
+
+#. RTTux
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id331586090532804\n"
+"help.text"
+msgid "<emph>label: </emph>Resets error information and executes the instruction at the given label."
+msgstr ""
+
+#. 7RP8z
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id331586090432804\n"
+"help.text"
+msgid "<emph>Next: </emph>Resets error information and executes the instruction following the one that caused the error."
+msgstr ""
+
+#. 3Jge7
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id441586333320983\n"
+"help.text"
+msgid "Error information is built with <literal>Erl</literal>, <literal>Err</literal> and <literal>Error$</literal> functions."
+msgstr ""
+
+#. PoXod
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id741586333516110\n"
+"help.text"
+msgid "<literal>Erl</literal>: Module line number where error occurs."
+msgstr ""
+
+#. aX9ZN
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id81586333580520\n"
+"help.text"
+msgid "<literal>Err</literal>: Error number."
+msgstr ""
+
+#. ctA2t
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id721586333586263\n"
+"help.text"
+msgid "<literal>Error[$]</literal>: Error description."
+msgstr ""
+
+#. fDJgb
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id941586091561618\n"
+"help.text"
+msgid "Using <emph>Resume</emph> to reset error information prevents the propagation of the handled condition to calling routines."
+msgstr ""
+
+#. coy5D
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"hd_id441586092960246\n"
+"help.text"
+msgid "Examples:"
+msgstr ""
+
+#. 4dyMX
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id961586248539108\n"
+"help.text"
+msgid "Typical error handling routines are: alerting the user, fixing the error, logging error information or re-throwing custom errors that provide explanations with resolution instructions. Use <literal>Resume label</literal> when requiring such mechanisms."
+msgstr ""
+
+#. VCDS3
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id451586093122848\n"
+"help.text"
+msgid "' routine code goes here"
+msgstr ""
+
+#. BFzfG
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id515860931234846\n"
+"help.text"
+msgid "Error 91 ' example error"
+msgstr ""
+
+#. uFVnv
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id361586093126654\n"
+"help.text"
+msgid "' routine cleanup code goes here"
+msgstr ""
+
+#. UNbMJ
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id61586095819168\n"
+"help.text"
+msgid "Use <literal>Resume Next</literal>, for example, when reporting anomalies encountered for an iterating process that must not be interrupted. In which case multiple handling routines may be required."
+msgstr ""
+
+#. AeVfB
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id461586091018138\n"
+"help.text"
+msgid "Using <literal>Resume</literal> without parameters to re-execute the faulty instruction can fit certain situations. However that may cause a never ending loop."
+msgstr ""
+
 #. MqMrx
 #: classmodule.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/scalc/00.po b/source/en-GB/helpcontent2/source/text/scalc/00.po
index f4a7308ffee..b23d1bba0c4 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/00.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/00.po
@@ -4,7 +4,7 @@ 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: 2020-03-31 10:35+0200\n"
-"PO-Revision-Date: 2020-02-06 08:13+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1554887221.000000\n"
 
 #. E9tti
@@ -302,7 +302,7 @@ msgctxt ""
 "par_id3149784\n"
 "help.text"
 msgid "Choose <menuitem>Sheet - Insert Cells</menuitem>."
-msgstr ""
+msgstr "Choose <menuitem>Sheet - Insert Cells</menuitem>."
 
 #. pybbE
 #: 00000404.xhp
@@ -311,7 +311,7 @@ msgctxt ""
 "par_id3154514\n"
 "help.text"
 msgid "Choose <menuitem>View - Toolbars</menuitem> and select the <emph>Insert Cells</emph> toolbar:"
-msgstr ""
+msgstr "Choose <menuitem>View - Toolbars</menuitem> and select the <emph>Insert Cells</emph> toolbar:"
 
 #. 7HGeD
 #: 00000404.xhp
@@ -410,7 +410,7 @@ msgctxt ""
 "par_id3149033\n"
 "help.text"
 msgid "<variable id=\"eitab\">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"eitab\">Choose <menuitem>Sheet - Insert Sheet</menuitem>.</variable>"
 
 #. HjKoP
 #: 00000404.xhp
@@ -419,7 +419,7 @@ msgctxt ""
 "par_idN1082F\n"
 "help.text"
 msgid "<variable id=\"eitabfile\">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"eitabfile\">Choose <menuitem>Sheet - Insert Sheet from File</menuitem>.</variable>"
 
 #. hfGrg
 #: 00000404.xhp
@@ -428,7 +428,7 @@ msgctxt ""
 "par_id3155115\n"
 "help.text"
 msgid "Choose <menuitem>Insert - Function</menuitem>."
-msgstr ""
+msgstr "Choose <menuitem>Insert - Function</menuitem>."
 
 #. anHWr
 #: 00000404.xhp
@@ -446,7 +446,7 @@ msgctxt ""
 "par_id3153269\n"
 "help.text"
 msgid "On the <emph>Formula</emph> bar, click"
-msgstr ""
+msgstr "On the <emph>Formula</emph> bar, click"
 
 #. HZ9Dn
 #: 00000404.xhp
@@ -581,7 +581,7 @@ msgctxt ""
 "par_id3155383\n"
 "help.text"
 msgid "<variable id=\"funktionsliste\">Choose <menuitem>Insert - Function List</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"funktionsliste\">Choose <menuitem>Insert - Function List</menuitem>.</variable>"
 
 #. UQGrR
 #: 00000404.xhp
@@ -590,7 +590,7 @@ msgctxt ""
 "par_id3153250\n"
 "help.text"
 msgid "<variable id=\"einamen\">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"einamen\">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable>"
 
 #. ASCUT
 #: 00000404.xhp
@@ -599,7 +599,7 @@ msgctxt ""
 "par_id3146776\n"
 "help.text"
 msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External data</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External data</menuitem>.</variable>"
 
 #. ECgNS
 #: 00000404.xhp
@@ -608,7 +608,7 @@ msgctxt ""
 "par_id3143222\n"
 "help.text"
 msgid "Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>."
-msgstr ""
+msgstr "Choose <menuitem>Sheet - Named Ranges and Expressions - Define</menuitem>."
 
 #. GM3WX
 #: 00000404.xhp
@@ -626,7 +626,7 @@ msgctxt ""
 "par_id3145214\n"
 "help.text"
 msgid "<variable id=\"einaei\">Choose <menuitem>Sheet - Named Ranges and Expressions - Insert</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"einaei\">Choose <menuitem>Sheet - Named Ranges and Expressions - Insert</menuitem>.</variable>"
 
 #. LGQgh
 #: 00000404.xhp
@@ -635,7 +635,7 @@ msgctxt ""
 "par_id3153558\n"
 "help.text"
 msgid "<variable id=\"einaueb\">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"einaueb\">Choose <menuitem>Sheet - Named Ranges and Expressions - Create</menuitem>.</variable>"
 
 #. ptGPX
 #: 00000404.xhp
@@ -644,7 +644,7 @@ msgctxt ""
 "par_id3153483\n"
 "help.text"
 msgid "<variable id=\"einabesch\">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable>"
-msgstr ""
+msgstr "<variable id=\"einabesch\">Choose <menuitem>Sheet - Named Ranges and Expressions - Labels</menuitem>.</variable>"
 
 #. p2LBA
 #: 00000405.xhp
@@ -1247,7 +1247,7 @@ msgctxt ""
 "par_id641584647437810\n"
 "help.text"
 msgid "<variable id=\"datasortascending\">Choose <menuitem>Data - Sort Ascending</menuitem></variable>"
-msgstr ""
+msgstr "<variable id=\"datasortascending\">Choose <menuitem>Data - Sort Ascending</menuitem></variable>"
 
 #. GHhdg
 #: 00000412.xhp
@@ -1256,7 +1256,7 @@ msgctxt ""
 "par_id711584647447316\n"
 "help.text"
 msgid "<variable id=\"datasortdescending\">Choose <menuitem>Data - Sort Descending</menuitem></variable>"
-msgstr ""
+msgstr "<variable id=\"datasortdescending\">Choose <menuitem>Data - Sort Descending</menuitem></variable>"
 
 #. oEATB
 #: 00000412.xhp
@@ -1274,7 +1274,7 @@ msgctxt ""
 "par_id3154516\n"
 "help.text"
 msgid "<variable id=\"onthestandardbar\">On <emph>Standard</emph> bar, click</variable>"
-msgstr ""
+msgstr "<variable id=\"onthestandardbar\">On the <emph>Standard</emph> bar, click</variable>"
 
 #. GDBeV
 #: 00000412.xhp
@@ -1283,7 +1283,7 @@ msgctxt ""
 "par_id3148663\n"
 "help.text"
 msgid "<image id=\"img_id3150543\" src=\"cmd/sc_sortup.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150543\">Icon Sort Ascending</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3150543\" src=\"cmd/sc_sortup.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150543\">Icon Sort Ascending</alt></image>"
 
 #. vv2Zk
 #: 00000412.xhp
@@ -1301,7 +1301,7 @@ msgctxt ""
 "par_id3153969\n"
 "help.text"
 msgid "<image id=\"img_id3125863\" src=\"cmd/sc_sortdown.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3125863\">Icon Sort Descending</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3125863\" src=\"cmd/sc_sortdown.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3125863\">Icon Sort Descending</alt></image>"
 
 #. AHMAB
 #: 00000412.xhp
@@ -1760,7 +1760,7 @@ msgctxt ""
 "par_id651551701041690\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 3.3."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 3.3."
 
 #. f7Pu4
 #: avail_release.xhp
@@ -1769,7 +1769,7 @@ msgctxt ""
 "par_id651551401041690\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 3.4."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 3.4."
 
 #. ctCQZ
 #: avail_release.xhp
@@ -1778,7 +1778,7 @@ msgctxt ""
 "par_id651551401041635\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 3.5."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 3.5."
 
 #. s2cEc
 #: avail_release.xhp
@@ -1787,7 +1787,7 @@ msgctxt ""
 "par_id651551401041636\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 3.6."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 3.6."
 
 #. VJxhP
 #: avail_release.xhp
@@ -1796,7 +1796,7 @@ msgctxt ""
 "par_id651551401041640\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 4.0."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 4.0."
 
 #. CBpb7
 #: avail_release.xhp
@@ -1805,7 +1805,7 @@ msgctxt ""
 "par_id651551401041641\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 4.1."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 4.1."
 
 #. 2cFVC
 #: avail_release.xhp
@@ -1814,7 +1814,7 @@ msgctxt ""
 "par_id651551401041642\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 4.2."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 4.2."
 
 #. iV7XA
 #: avail_release.xhp
@@ -1823,7 +1823,7 @@ msgctxt ""
 "par_id651551401041643\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 4.3."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 4.3."
 
 #. ZwQHj
 #: avail_release.xhp
@@ -1832,7 +1832,7 @@ msgctxt ""
 "par_id651551401041644\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 4.4."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 4.4."
 
 #. jcAXr
 #: avail_release.xhp
@@ -1841,7 +1841,7 @@ msgctxt ""
 "par_id651551401041650\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 5.0."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 5.0."
 
 #. zV2VV
 #: avail_release.xhp
@@ -1850,7 +1850,7 @@ msgctxt ""
 "par_id651551401041651\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 5.1."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 5.1."
 
 #. DJsbg
 #: avail_release.xhp
@@ -1859,7 +1859,7 @@ msgctxt ""
 "par_id651551401041652\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 5.2."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 5.2."
 
 #. UBjho
 #: avail_release.xhp
@@ -1868,7 +1868,7 @@ msgctxt ""
 "par_id651551401041653\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 5.3."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 5.3."
 
 #. oGbPE
 #: avail_release.xhp
@@ -1877,7 +1877,7 @@ msgctxt ""
 "par_id651551401041654\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 5.4."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 5.4."
 
 #. 75SZe
 #: avail_release.xhp
@@ -1886,7 +1886,7 @@ msgctxt ""
 "par_id651551401041660\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 6.0."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 6.0."
 
 #. qEaTq
 #: avail_release.xhp
@@ -1895,7 +1895,7 @@ msgctxt ""
 "par_id651551401041661\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 6.1."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 6.1."
 
 #. WpAdt
 #: avail_release.xhp
@@ -1904,7 +1904,7 @@ msgctxt ""
 "par_id651551401041662\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 6.2."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 6.2."
 
 #. FyJfT
 #: avail_release.xhp
@@ -1913,7 +1913,7 @@ msgctxt ""
 "par_id651551401041663\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 6.3."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 6.3."
 
 #. 3TzRz
 #: avail_release.xhp
@@ -1922,7 +1922,7 @@ msgctxt ""
 "par_id651551401041664\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 6.4."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 6.4."
 
 #. DWBCQ
 #: avail_release.xhp
@@ -1931,7 +1931,7 @@ msgctxt ""
 "par_id651551401041665\n"
 "help.text"
 msgid "This function is available since %PRODUCTNAME 7.0."
-msgstr ""
+msgstr "This function is available since %PRODUCTNAME 7.0."
 
 #. LSPBz
 #: sheet_menu.xhp
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index 1b5e5ac66ca..b822ca09b6f 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: 2020-04-03 11:46+0200\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
 "PO-Revision-Date: 2020-03-03 11:15+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/en_GB/>\n"
@@ -6199,14 +6199,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>"
 
-#. XhTVX
+#. BiDCz
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3145362\n"
 "help.text"
-msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"
-msgstr "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"
+msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])"
+msgstr ""
 
 #. oHAVz
 #: 04060103.xhp
@@ -6991,14 +6991,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>"
 
-#. tusey
+#. fBGBA
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3149756\n"
 "help.text"
-msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"
-msgstr "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"
+msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])"
+msgstr ""
 
 #. Uyj29
 #: 04060103.xhp
@@ -7081,14 +7081,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>"
 
-#. bJZPP
+#. 7ixum
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3153373\n"
 "help.text"
-msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"
-msgstr "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"
+msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])"
+msgstr ""
 
 #. JeeVp
 #: 04060103.xhp
@@ -7144,14 +7144,14 @@ msgctxt ""
 msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?"
 msgstr "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3), what is the duration?"
 
-#. ggYzf
+#. ADc8t
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3154902\n"
 "help.text"
-msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"
-msgstr "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"
+msgid "<input>=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</input> returns 4.2 years."
+msgstr ""
 
 #. TjeEJ
 #: 04060103.xhp
@@ -12661,420 +12661,6 @@ msgctxt ""
 msgid "<item type=\"input\">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897)."
 msgstr "<item type=\"input\">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897)."
 
-#. fnS8m
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3152518\n"
-"help.text"
-msgid "<bookmark_value>CEILING function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>CEILING function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-
-#. FtjnD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3152518\n"
-"help.text"
-msgid "CEILING"
-msgstr "CEILING"
-
-#. BDPUw
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-
-#. fhdEu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153454\n"
-"help.text"
-msgid "CEILING(Number; Significance; Mode)"
-msgstr "CEILING(Number; Significance; Mode)"
-
-#. PyYGM
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153467\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr "<emph>Number</emph> is the number that is to be rounded up."
-
-#. GQVYD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155000\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Significance</emph> is the number that the value is to be rounded up to a multiple of."
-
-#. dEi4T
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155020\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-
-#. MUqdA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163792\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
-msgstr "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
-
-#. B5jSx
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING(-11;-2)</item> returns -10"
-
-#. H6Ai9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145725\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;0)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING(-11;-2;0)</item> returns -10"
-
-#. X8Ebc
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145740\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;1)</item> returns -12"
-msgstr "<item type=\"input\">=CEILING(-11;-2;1)</item> returns -12"
-
-#. NWAdq
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2952518\n"
-"help.text"
-msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>CEILING.PRECISE function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-
-#. TL2Mo
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2952518\n"
-"help.text"
-msgid "CEILING.PRECISE"
-msgstr "CEILING.PRECISE"
-
-#. uP3ef
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-
-#. af8Jy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953454\n"
-"help.text"
-msgid "CEILING.PRECISE(Number; Significance)"
-msgstr "CEILING.PRECISE(Number; Significance)"
-
-#. c2S3Q
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>Number</emph> (required) is the number that is to be rounded up."
-
-#. De3wj
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Significance</emph> (optional) is the number that the value is to be rounded up to a multiple of."
-
-#. ATzN5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2945710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10"
-
-#. CyR3Z
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id911516997198644\n"
-"help.text"
-msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
-msgstr "<bookmark_value>CEILING.MATH function</bookmark_value>"
-
-#. 47WTb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id91516997330445\n"
-"help.text"
-msgid "CEILING.MATH"
-msgstr "CEILING.MATH"
-
-#. fj22A
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id81516997342088\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-
-#. dEs2U
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id841516997669932\n"
-"help.text"
-msgid "CEILING.MATH(Number; Significance; Mode)"
-msgstr "CEILING.MATH(Number; Significance; Mode)"
-
-#. mVrcG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id651516997706287\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr "<emph>Number</emph> is the number that is to be rounded up."
-
-#. eWEoz
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id491516997725772\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Significance</emph> is the number that the value is to be rounded up to a multiple of."
-
-#. DhhJP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id451516997742909\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-
-#. pNkWd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id291516998575663\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
-msgstr "This function exists for interoperability with Microsoft Excel 2013 or newer."
-
-#. AWN7C
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id111516997803684\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9"
-msgstr "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9"
-
-#. VRy7N
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id1001516997821483\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9"
-msgstr "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9"
-
-#. Cqx7f
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id641516997837754\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12"
-msgstr "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12"
-
-#. 5eFKb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id921516998608939\n"
-"help.text"
-msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
-msgstr "<bookmark_value>CEILING.XCL function</bookmark_value>"
-
-#. 7CEZC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id411516998838823\n"
-"help.text"
-msgid "CEILING.XCL"
-msgstr "CEILING.XCL"
-
-#. vYMF6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id811516998845826\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>"
-
-#. hh5aZ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id251516998856873\n"
-"help.text"
-msgid "CEILING.XCL(Number; Significance)"
-msgstr "CEILING.XCL(Number; Significance)"
-
-#. cwEnK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998874263\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded."
-msgstr "<emph>Number</emph> is the number that is to be rounded."
-
-#. RLTcE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id151516998882622\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded."
-msgstr "<emph>Significance</emph> is the value that the number is to be rounded to a multiple of."
-
-#. FZWHB
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id341516998889754\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions."
-msgstr "This function exists for interoperability with Microsoft Excel 2007 or older versions."
-
-#. UuVCG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id91516998917254\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3"
-msgstr "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3"
-
-#. mD3Gy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id761516998929693\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8"
-msgstr "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8"
-
-#. C59zA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998958873\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12"
-msgstr "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12"
-
-#. VwPyC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id8952518\n"
-"help.text"
-msgid "<bookmark_value>ISO.CEILING function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>ISO.CEILING function</bookmark_value>  <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-
-#. DhoD5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id8952518\n"
-"help.text"
-msgid "ISO.CEILING"
-msgstr "ISO.CEILING"
-
-#. a8Z2B
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-
-#. iGoz8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953454\n"
-"help.text"
-msgid "ISO.CEILING(Number; Significance)"
-msgstr "ISO.CEILING(Number; Significance)"
-
-#. p7ssP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>Number</emph> (required) is the number that is to be rounded up."
-
-#. FBHry
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Significance</emph> (optional) is the number that the value is to be rounded up to a multiple of."
-
-#. M8dYu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8945710\n"
-"help.text"
-msgid "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10"
-
 #. tQjUA
 #: 04060106.xhp
 msgctxt ""
@@ -15037,168 +14623,6 @@ msgctxt ""
 msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5."
 msgstr "<item type=\"input\">=ODD(-3.1)</item> returns -5."
 
-#. CR7gG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2957404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value>  <bookmark_value>FLOOR.XCL function</bookmark_value>  <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr "<bookmark_value>FLOOR.PRECISE function</bookmark_value>  <bookmark_value>FLOOR.XCL function</bookmark_value>  <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-
-#. ticPN
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2957404\n"
-"help.text"
-msgid "FLOOR.PRECISE"
-msgstr "FLOOR.PRECISE"
-
-#. eZWE9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-
-#. BKB8E
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957464\n"
-"help.text"
-msgid "FLOOR.PRECISE(Number; Significance)"
-msgstr "FLOOR.PRECISE(Number; Significance)"
-
-#. Mt3KY
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>Number</emph> is the number that is to be rounded down."
-
-#. oe3sn
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>Significance</emph> is the value that the number is to be rounded down to a multiple of."
-
-#. FCZhS
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2963945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12"
-
-#. aDgE5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3157404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR function</bookmark_value>  <bookmark_value>FLOOR.MATH function</bookmark_value>  <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr "<bookmark_value>FLOOR function</bookmark_value>  <bookmark_value>FLOOR.MATH function</bookmark_value>  <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-
-#. BAZE3
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3157404\n"
-"help.text"
-msgid "FLOOR"
-msgstr "FLOOR"
-
-#. WHyYX
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number down to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number down to the nearest multiple of Significance.</ahelp>"
-
-#. DDbJ6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157464\n"
-"help.text"
-msgid "FLOOR(Number; Significance; Mode)"
-msgstr "FLOOR(Number; Significance; Mode)"
-
-#. cEAXh
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>Number</emph> is the number that is to be rounded down."
-
-#. zEGez
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>Significance</emph> is the value that the number is to be rounded down to a multiple of."
-
-#. dDExC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157517\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero."
-msgstr "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero."
-
-#. Z6Cnd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163894\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
-msgstr "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
-
-#. 4FuF8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR( -11;-2)</item> returns -12"
-
-#. R4ppE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163966\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;0)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR( -11;-2;0)</item> returns -12"
-
-#. aWzUK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163988\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;1)</item> returns -10"
-msgstr "<item type=\"input\">=FLOOR( -11;-2;1)</item> returns -10"
-
 #. itiAQ
 #: 04060106.xhp
 msgctxt ""
@@ -16585,41 +16009,41 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns."
 msgstr "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns."
 
-#. dEKAU
+#. JUTAD
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3150798\n"
 "help.text"
-msgid "MMULT(Array; Array)"
-msgstr "MMULT(Array; Array)"
+msgid "MMULT(Array 1; Array 2)"
+msgstr ""
 
-#. noXqv
+#. DqghH
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3150812\n"
 "help.text"
-msgid "<emph>Array</emph> at first place represents the first array used in the array product."
-msgstr "<emph>Array</emph> at first place is the first array used in the array product."
+msgid "<emph>Array 1</emph> represents the first array used in the array product."
+msgstr ""
 
-#. 5qGeT
+#. FDfwg
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3152553\n"
 "help.text"
-msgid "<emph>Array</emph> at second place represents the second array with the same number of rows."
-msgstr "<emph>Array</emph> at second place is the second array, which must have the same number of rows as the first."
+msgid "<emph>Array 2</emph> represents the second array with the same number of rows."
+msgstr ""
 
-#. RoWHa
+#. CuGxm
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3146826\n"
 "help.text"
-msgid "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
-msgstr "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
+msgid "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
+msgstr ""
 
 #. vPBWq
 #: 04060107.xhp
@@ -18313,15 +17737,6 @@ msgctxt ""
 msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518."
 msgstr "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518."
 
-#. FWJTB
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
-"hd_id275141466817507\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>"
-msgstr ""
-
 #. mtLKD
 #: 04060109.xhp
 msgctxt ""
@@ -33784,6 +33199,15 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>"
 msgstr "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>"
 
+#. ELVTS
+#: 04060181.xhp
+msgctxt ""
+"04060181.xhp\n"
+"par_id21585771564740\n"
+"help.text"
+msgid "CHISQINV(Probability; Degrees of Freedom)"
+msgstr ""
+
 #. KibGe
 #: 04060181.xhp
 msgctxt ""
@@ -35764,6 +35188,15 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST."
 msgstr "<ahelp hid=\".\">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST."
 
+#. WT29Z
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id211585771824267\n"
+"help.text"
+msgid "GAMMA(Number)"
+msgstr ""
+
 #. 2DdQa
 #: 04060182.xhp
 msgctxt ""
@@ -36637,14 +36070,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>"
 
-#. fNMzN
+#. 5uQ3c
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id3155388\n"
 "help.text"
-msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation)"
-msgstr "HYPGEOMDIST(X; NSample; Successes; NPopulation)"
+msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])"
+msgstr ""
 
 #. ingyW
 #: 04060182.xhp
@@ -36682,6 +36115,15 @@ msgctxt ""
 msgid "<emph>NPopulation </emph>is the size of the total population."
 msgstr "<emph>NPopulation </emph>is the size of the total population."
 
+#. oDuYV
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id231585952506847\n"
+"help.text"
+msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter."
+msgstr ""
+
 #. WUiB6
 #: 04060182.xhp
 msgctxt ""
@@ -55987,6 +55429,528 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 
+#. s6GFW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"tit\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. EWCte
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id971586216771519\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. M92qb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id3152518\n"
+"help.text"
+msgid "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. XR3RK
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id3152518\n"
+"help.text"
+msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>"
+msgstr ""
+
+#. E9m3Y
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>"
+msgstr ""
+
+#. PfT3s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id601586207136514\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. s9tRF
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3163792\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgstr ""
+
+#. mZwNV
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153454\n"
+"help.text"
+msgid "CEILING(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. XHjhc
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. XEqxw
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. AosjB
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155020\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)."
+msgstr ""
+
+#. Ka9pC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id281586208138400\n"
+"help.text"
+msgid "<input>=CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ztdNi
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208142416\n"
+"help.text"
+msgid "<input>=CEILING(3.45, 3)</input> returns 6."
+msgstr ""
+
+#. XGfA3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208146984\n"
+"help.text"
+msgid "<input>=CEILING(-1.234)</input> returns -1."
+msgstr ""
+
+#. ss5WP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491586208152183\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44."
+msgstr ""
+
+#. FY9XN
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291586208158119\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46."
+msgstr ""
+
+#. rZ78k
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id2952518\n"
+"help.text"
+msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. 5DWRd
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id2952518\n"
+"help.text"
+msgid "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\" name=\"CEILING.PRECISE\">CEILING.PRECISE</link></variable>"
+msgstr ""
+
+#. aTD6P
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. BjuBa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586642494759\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. EErBR
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id631586642933797\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function."
+msgstr ""
+
+#. yYT7X
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953454\n"
+"help.text"
+msgid "CEILING.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. FaYeD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. 6Vtow
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id461586211894475\n"
+"help.text"
+msgid "This function calculates identical results to the ISO.CEILING function"
+msgstr ""
+
+#. 8WiRx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id201586213398634\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4."
+msgstr ""
+
+#. kkosx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586213406243\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. WV9bx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id911516997198644\n"
+"help.text"
+msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
+msgstr ""
+
+#. 7xeKu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id91516997330445\n"
+"help.text"
+msgid "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\" name=\"CEILING.MATH\">CEILING.MATH</link></variable>"
+msgstr ""
+
+#. AzJvD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id81516997342088\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. QLGe7
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id911586642319078\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. Km7yb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id841516997669932\n"
+"help.text"
+msgid "CEILING.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. EAezJ
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491516997725772\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. EiWLa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id451516997742909\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)."
+msgstr ""
+
+#. aYczG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. je22s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id331586208590009\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45)</input> returns 4."
+msgstr ""
+
+#. 6BkMe
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id481586208595809\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6."
+msgstr ""
+
+#. Eby7i
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id641586208600665\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-1.234)</input> returns -1."
+msgstr ""
+
+#. fH4Yt
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586208604536\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44."
+msgstr ""
+
+#. MGVBD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id971586208611345\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46."
+msgstr ""
+
+#. EzE9t
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id921516998608939\n"
+"help.text"
+msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
+msgstr ""
+
+#. CRMmT
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id411516998838823\n"
+"help.text"
+msgid "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\" name=\"CEILING.XCL\">CEILING.XCL</link></variable>"
+msgstr ""
+
+#. 2tuD3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811516998845826\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. tAyJj
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id361586213828675\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. 2CKjm
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id881586213934118\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function."
+msgstr ""
+
+#. GspBr
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id251516998856873\n"
+"help.text"
+msgid "CEILING.XCL(Number; Significance)"
+msgstr ""
+
+#. eTSgx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151516998882622\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. 6n7qn
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id421586214128242\n"
+"help.text"
+msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4."
+msgstr ""
+
+#. SZYUC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586214132234\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. pz8Go
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811586214136666\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46."
+msgstr ""
+
+#. GMzhD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id8952518\n"
+"help.text"
+msgid "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. q22aC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id8952518\n"
+"help.text"
+msgid "<variable id=\"ISO.CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\" name=\"ISO.CEILING\">ISO.CEILING</link></variable>"
+msgstr ""
+
+#. 5beBC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. SFZNu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id101586214229587\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. qu8FG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id821586214265060\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function."
+msgstr ""
+
+#. LZzHU
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953454\n"
+"help.text"
+msgid "ISO.CEILING(Number[; Significance])"
+msgstr ""
+
+#. hwhCW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. FSFdP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id801586214431463\n"
+"help.text"
+msgid "<input>=ISO.CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ENMYD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id181586214438808\n"
+"help.text"
+msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44."
+msgstr ""
+
 #. GuEcB
 #: func_color.xhp
 msgctxt ""
@@ -56950,14 +56914,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_TAGE360\">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_TAGE360\">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp>"
 
-#. ow4Jg
+#. Vndiw
 #: func_days360.xhp
 msgctxt ""
 "func_days360.xhp\n"
 "par_id3155313\n"
 "help.text"
-msgid "DAYS360(\"Date1\"; \"Date2\"; Type)"
-msgstr "DAYS360(\"Date1\"; \"Date2\"; Type)"
+msgid "DAYS360(Date1; Date2[; Type])"
+msgstr ""
 
 #. 5qfGz
 #: func_days360.xhp
@@ -57607,6 +57571,429 @@ msgctxt ""
 msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
 msgstr "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
 
+#. aACGP
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"tit\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. RuCRw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id391586285373874\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. hkrkw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id3157404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. KoqGL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id3157404\n"
+"help.text"
+msgid "<variable id=\"FLOORh1\"><link href=\"text/scalc/01/func_floor.xhp#floor\" name=\"FLOOR\">FLOOR</link></variable>"
+msgstr ""
+
+#. VSV8H
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. 345Fr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586285977707\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. 2haGU
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157464\n"
+"help.text"
+msgid "FLOOR(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. ERf3D
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. 8w8tL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. qCpHR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157517\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)."
+msgstr ""
+
+#. 5kHtR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3163894\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
+msgstr ""
+
+#. EU85r
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586287595376\n"
+"help.text"
+msgid "<input>=FLOOR(3.45)</input> returns 3."
+msgstr ""
+
+#. vuJc5
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287600048\n"
+"help.text"
+msgid "<input>=FLOOR(3.45, 3)</input> returns 3."
+msgstr ""
+
+#. uTWTb
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586287604519\n"
+"help.text"
+msgid "<input>=FLOOR(-1.234)</input> returns -2."
+msgstr ""
+
+#. 8ZGDc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id741586287608968\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 0)</input> returns -46."
+msgstr ""
+
+#. gXsTm
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id431586287616089\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 1)</input> returns -44."
+msgstr ""
+
+#. zzTLr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id811586290952465\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.MATH function</bookmark_value>"
+msgstr ""
+
+#. rEELD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id1001586287279297\n"
+"help.text"
+msgid "<variable id=\"FLOOR.MATHh1\"><link href=\"text/scalc/01/func_floor.xhp#floormath\" name=\"FLOOR.MATH\">FLOOR.MATH</link></variable>"
+msgstr ""
+
+#. BBjwd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id721586287302689\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. UJLZc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287323417\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. 4weAd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id851586287535879\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. 4DFyG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id161586287421523\n"
+"help.text"
+msgid "FLOOR.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. Un6FB
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586287448716\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. L9MKT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586287494401\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero)."
+msgstr ""
+
+#. wCd8C
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id101586287621816\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45)</input> returns 3."
+msgstr ""
+
+#. p27MD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id771586287627784\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45,-3)</input> returns 3."
+msgstr ""
+
+#. Fehfx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586287632392\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-1.234)</input> returns -2."
+msgstr ""
+
+#. eQfea
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id631586287637256\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46."
+msgstr ""
+
+#. XXqpS
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id371586287641888\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44."
+msgstr ""
+
+#. 9MJem
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id2957404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. niyQj
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id2957404\n"
+"help.text"
+msgid "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\" name=\"FLOOR.PRECISE\">FLOOR.PRECISE</link></variable>"
+msgstr ""
+
+#. DgQBx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. NHMnz
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586641501175\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. ni9y2
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957464\n"
+"help.text"
+msgid "FLOOR.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. pirHp
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. smFCw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586291388900\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(3.45)</input> returns 3."
+msgstr ""
+
+#. Q9vnd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id831586291395477\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. HnS5F
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id171586291849333\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.XCL function</bookmark_value>"
+msgstr ""
+
+#. LMEET
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id791586291468176\n"
+"help.text"
+msgid "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\" name=\"FLOOR.XCL\">FLOOR.XCL</link></variable>"
+msgstr ""
+
+#. WMsAT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id521586291476023\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. jrymG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id401586291488768\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. BFXRR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586291503319\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function."
+msgstr ""
+
+#. WA7uC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id491586291532177\n"
+"help.text"
+msgid "FLOOR.XCL(Number; Significance)"
+msgstr ""
+
+#. aRww7
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586291578755\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. HXuMo
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id531586291622306\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(3.45,2)</input> returns 2."
+msgstr ""
+
+#. gFyGC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id361586291628003\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. EU7xy
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id801586291641099\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44."
+msgstr ""
+
 #. 2YcR7
 #: func_forecastetsadd.xhp
 msgctxt ""
diff --git a/source/en-GB/helpcontent2/source/text/scalc/02.po b/source/en-GB/helpcontent2/source/text/scalc/02.po
index 2b317c36559..8dd815dda40 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/02.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/02.po
@@ -4,7 +4,7 @@ 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: 2020-01-07 14:09+0100\n"
-"PO-Revision-Date: 2020-02-10 17:41+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc02/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Weblate 3.9.1\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1547597608.000000\n"
 
 #. aSE5T
@@ -320,7 +320,7 @@ msgctxt ""
 "tit\n"
 "help.text"
 msgid "Name Box"
-msgstr ""
+msgstr "Name Box"
 
 #. JJA9o
 #: 06010000.xhp
@@ -374,7 +374,7 @@ msgctxt ""
 "par_id3152596\n"
 "help.text"
 msgid "To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4. You can also enter full name of a sheet; the tooltip then changes to \"Go To Sheet\", and pressing Enter switches to that sheet."
-msgstr ""
+msgstr "To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4. You can also enter full name of a sheet; the tooltip then changes to \"Go To Sheet\", and pressing Enter switches to that sheet."
 
 #. VFke2
 #: 06030000.xhp
diff --git a/source/en-GB/helpcontent2/source/text/sdraw/01.po b/source/en-GB/helpcontent2/source/text/sdraw/01.po
index 3df91a3272f..95fcfa08e79 100644
--- a/source/en-GB/helpcontent2/source/text/sdraw/01.po
+++ b/source/en-GB/helpcontent2/source/text/sdraw/01.po
@@ -4,7 +4,7 @@ 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: 2020-02-17 12:22+0100\n"
-"PO-Revision-Date: 2020-02-10 17:42+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsdraw01/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1563447592.000000\n"
 
 #. 4JVcT
@@ -374,7 +374,7 @@ msgctxt ""
 "par_id581566156032977\n"
 "help.text"
 msgid "<ahelp hid=\".\">Opens a sub-menu for page navigation.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Opens a sub-menu for page navigation.</ahelp>"
 
 #. XRJhq
 #: new_page.xhp
diff --git a/source/en-GB/helpcontent2/source/text/sdraw/guide.po b/source/en-GB/helpcontent2/source/text/sdraw/guide.po
index d14b9b398a9..4ea74080fcc 100644
--- a/source/en-GB/helpcontent2/source/text/sdraw/guide.po
+++ b/source/en-GB/helpcontent2/source/text/sdraw/guide.po
@@ -4,7 +4,7 @@ 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: 2020-01-22 13:00+0100\n"
-"PO-Revision-Date: 2020-02-18 14:15+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsdrawguide/en_GB/>\n"
 "Language: en-GB\n"
@@ -2678,7 +2678,7 @@ msgctxt ""
 "par_id0930200803002463\n"
 "help.text"
 msgid "Right-click the object to open the context menu. Choose <menuitem>Position and Size - Rotation</menuitem> to enter an exact rotation value."
-msgstr ""
+msgstr "Right-click the object to open the context menu. Choose <menuitem>Position and Size - Rotation</menuitem> to enter an exact rotation value."
 
 #. G5NAB
 #: rotate_object.xhp
diff --git a/source/en-GB/helpcontent2/source/text/shared/02.po b/source/en-GB/helpcontent2/source/text/shared/02.po
index 559ddb257c3..102943e56ed 100644
--- a/source/en-GB/helpcontent2/source/text/shared/02.po
+++ b/source/en-GB/helpcontent2/source/text/shared/02.po
@@ -4,7 +4,7 @@ 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: 2020-03-31 10:35+0200\n"
-"PO-Revision-Date: 2020-02-25 12:15+0000\n"
+"PO-Revision-Date: 2020-04-07 11:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textshared02/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1563449207.000000\n"
 
 #. Edm6o
@@ -2831,7 +2831,7 @@ msgctxt ""
 "par_id3150084\n"
 "help.text"
 msgid "<ahelp hid=\".\">If a control field has the property \"Enabled\" (<emph>Yes</emph>), the form user can use the control field.</ahelp> Otherwise (<emph>No</emph>), it is disabled and greyed out."
-msgstr ""
+msgstr "<ahelp hid=\".\">If a control field has the property \"Enabled\" (<emph>Yes</emph>), the form user can use the control field.</ahelp> Otherwise (<emph>No</emph>), it is disabled and greyed out."
 
 #. tYDLf
 #: 01170101.xhp
@@ -10499,7 +10499,7 @@ msgctxt ""
 "tit\n"
 "help.text"
 msgid "Styles (icon)"
-msgstr ""
+msgstr "Styles (icon)"
 
 #. PUeB4
 #: 01230000.xhp
@@ -10508,7 +10508,7 @@ msgctxt ""
 "hd_id3154228\n"
 "help.text"
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><link href=\"text/swriter/01/05140000.xhp\" name=\"text documents\">Styles</link></caseinline><caseinline select=\"CALC\"><link href=\"text/scalc/01/05100000.xhp\" name=\"spreadsheets\">Styles</link></caseinline><defaultinline><link href=\"text/simpress/01/05100000.xhp\" name=\"presentations/drawing documents\">Styles</link></defaultinline></switchinline>"
-msgstr ""
+msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><link href=\"text/swriter/01/05140000.xhp\" name=\"text documents\">Styles</link></caseinline><caseinline select=\"CALC\"><link href=\"text/scalc/01/05100000.xhp\" name=\"spreadsheets\">Styles</link></caseinline><defaultinline><link href=\"text/simpress/01/05100000.xhp\" name=\"presentations/drawing documents\">Styles</link></defaultinline></switchinline>"
 
 #. 8NLAN
 #: 01230000.xhp
@@ -13514,7 +13514,7 @@ msgctxt ""
 "par_id3155805\n"
 "help.text"
 msgid "<image src=\"cmd/sc_gotoendofdoc.png\" id=\"img_id3153394\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153394\">Icon Last Page</alt></image>"
-msgstr ""
+msgstr "<image src=\"cmd/sc_gotoendofdoc.png\" id=\"img_id3153394\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153394\">Icon Last Page</alt></image>"
 
 #. E7V4E
 #: 10040000.xhp
@@ -13703,7 +13703,7 @@ msgctxt ""
 "par_id3154380\n"
 "help.text"
 msgid "<variable id=\"selektionsortieren\">Data of the currently selected field are always sorted. A field is always selected as soon as you place the cursor in the field. To sort within tables, you can also click the corresponding column header.</variable>"
-msgstr ""
+msgstr "<variable id=\"selektionsortieren\">Data of the currently selected field are always sorted. A field is always selected as soon as you place the cursor in the field. To sort within tables, you can also click the corresponding column header.</variable>"
 
 #. WrDm4
 #: 12010000.xhp
@@ -13712,7 +13712,7 @@ msgctxt ""
 "par_id3150504\n"
 "help.text"
 msgid "<variable id=\"dialogsortieren\">To sort more than one data field, choose <emph>Data - Sort</emph>, then choose the <link href=\"text/shared/02/12100100.xhp\" name=\"Sort Criteria\">Sort Criteria</link> tab, where you can combine several sort criteria.</variable>"
-msgstr ""
+msgstr "<variable id=\"dialogsortieren\">To sort more than one data field, choose <emph>Data - Sort</emph>, then choose the <link href=\"text/shared/02/12100100.xhp\" name=\"Sort Criteria\">Sort Criteria</link> tab, where you can combine several sort criteria.</variable>"
 
 #. QAjRs
 #: 12020000.xhp
@@ -17411,7 +17411,7 @@ msgctxt ""
 "par_id3149346\n"
 "help.text"
 msgid "<switchinline select=\"appl\"><caseinline select=\"IMPRESS\">Double-click this field to open the <link href=\"text/simpress/01/05120000.xhp\" name=\"Available Master Slides\"><emph>Available Master Slides</emph></link> dialog in which you can select the style for the current slide. You can select a different paper format or background.</caseinline></switchinline>"
-msgstr ""
+msgstr "<switchinline select=\"appl\"><caseinline select=\"IMPRESS\">Double-click this field to open the <link href=\"text/simpress/01/05120000.xhp\" name=\"Available Master Slides\"><emph>Available Master Slides</emph></link> dialogue box in which you can select the style for the current slide. You can select a different paper format or background.</caseinline></switchinline>"
 
 #. DLgbQ
 #: 20020000.xhp
@@ -17420,7 +17420,7 @@ msgctxt ""
 "par_id3147008\n"
 "help.text"
 msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\">Double-click this field to open the <link href=\"text/simpress/01/05120000.xhp\" name=\"Available Master Slides\"><emph>Available Master Slides</emph></link> dialog in which you select the style for the current page. You can select a different paper format or background.</caseinline></switchinline>"
-msgstr ""
+msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\">Double-click this field to open the <link href=\"text/simpress/01/05120000.xhp\" name=\"Available Master Slides\"><emph>Available Master Slides</emph></link> dialogue box in which you select the style for the current page. You can select a different paper format or background.</caseinline></switchinline>"
 
 #. AMiFU
 #: 20030000.xhp
diff --git a/source/en-GB/helpcontent2/source/text/shared/guide.po b/source/en-GB/helpcontent2/source/text/shared/guide.po
index c7fee3828e3..536276239e0 100644
--- a/source/en-GB/helpcontent2/source/text/shared/guide.po
+++ b/source/en-GB/helpcontent2/source/text/shared/guide.po
@@ -4,7 +4,7 @@ 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: 2020-03-13 12:06+0100\n"
-"PO-Revision-Date: 2020-02-18 14:15+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedguide/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1563450099.000000\n"
 
 #. iharT
@@ -7169,7 +7169,7 @@ msgctxt ""
 "par_idN105C1\n"
 "help.text"
 msgid "Data from any <link href=\"text/shared/explorer/database/dabadoc.xhp\">database file</link> can be registered to the installed instance of %PRODUCTNAME. To register means to tell %PRODUCTNAME where the data is located, how it is organized, how to get that data, and more. Once the database is registered, you can use the menu command <emph>View - Data source</emph> to access the data records from your text documents and spreadsheets."
-msgstr ""
+msgstr "Data from any <link href=\"text/shared/explorer/database/dabadoc.xhp\">database file</link> can be registered to the installed instance of %PRODUCTNAME. To register means to tell %PRODUCTNAME where the data is located, how it is organised, how to get that data, and more. Once the database is registered, you can use the menu command <emph>View - Data source</emph> to access the data records from your text documents and spreadsheets."
 
 #. ADK4M
 #: data_register.xhp
@@ -13703,7 +13703,7 @@ msgctxt ""
 "par_id3155535\n"
 "help.text"
 msgid "To view a selection of all characters, choose <menuitem>Insert - Special Character</menuitem>."
-msgstr ""
+msgstr "To view a selection of all characters, choose <menuitem>Insert - Special Character</menuitem>."
 
 #. fFAT9
 #: insert_specialchar.xhp
@@ -13712,7 +13712,7 @@ msgctxt ""
 "par_id3147275\n"
 "help.text"
 msgid "In the large selection field double-click on the desired character, which is inserted in the current document."
-msgstr ""
+msgstr "In the large selection field double-click on the desired character, which is inserted in the current document."
 
 #. p7XqC
 #: insert_specialchar.xhp
@@ -15485,7 +15485,7 @@ msgctxt ""
 "bm_id3083278\n"
 "help.text"
 msgid "<bookmark_value>languages; selecting for text</bookmark_value>      <bookmark_value>documents; languages</bookmark_value>      <bookmark_value>characters; language selection</bookmark_value>      <bookmark_value>character styles;language selection</bookmark_value>      <bookmark_value>text; language selection</bookmark_value>      <bookmark_value>paragraph styles; languages</bookmark_value>      <bookmark_value>drawings; languages</bookmark_value>      <bookmark_value>defaults;languages</bookmark_value>      <bookmark_value>spellcheck; default languages</bookmark_value>      <bookmark_value>spelling; default languages</bookmark_value>      <bookmark_value>dictionaries, see also languages</bookmark_value>"
-msgstr ""
+msgstr "<bookmark_value>languages; selecting for text</bookmark_value>      <bookmark_value>documents; languages</bookmark_value>      <bookmark_value>characters; language selection</bookmark_value>      <bookmark_value>character styles;language selection</bookmark_value>      <bookmark_value>text; language selection</bookmark_value>      <bookmark_value>paragraph styles; languages</bookmark_value>      <bookmark_value>drawings; languages</bookmark_value>      <bookmark_value>defaults;languages</bookmark_value>      <bookmark_value>spellcheck; default languages</bookmark_value>      <bookmark_value>spelling; default languages</bookmark_value>      <bookmark_value>dictionaries, see also languages</bookmark_value>"
 
 #. AoAWf
 #: language_select.xhp
@@ -17312,7 +17312,7 @@ msgctxt ""
 "par_id3150297\n"
 "help.text"
 msgid "<link href=\"text/shared/01/06010000.xhp\" name=\"Spelling\">Spelling</link>"
-msgstr ""
+msgstr "<link href=\"text/shared/01/06010000.xhp\" name=\"Spelling\">Spelling</link>"
 
 #. RdJY7
 #: microsoft_terms.xhp
@@ -18581,7 +18581,7 @@ msgctxt ""
 "hd_id131543693200115\n"
 "help.text"
 msgid "<variable id=\"openpgph1\"><link href=\"text/shared/guide/openpgp.xhp\" name=\"openpgp\">Encrypting Documents with OpenPGP</link></variable>"
-msgstr ""
+msgstr "<variable id=\"openpgph1\"><link href=\"text/shared/guide/openpgp.xhp\" name=\"openpgp\">Encrypting Documents with OpenPGP</link></variable>"
 
 #. pDG6n
 #: openpgp.xhp
@@ -20129,7 +20129,7 @@ msgctxt ""
 "par_id381566315781439\n"
 "help.text"
 msgid "<ahelp hid=\".\">Generate QR Code for any text or URL.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Generate QR Code for any text or URL.</ahelp>"
 
 #. SzeNM
 #: qrcode.xhp
@@ -20174,7 +20174,7 @@ msgctxt ""
 "hd_id701566317347416\n"
 "help.text"
 msgid "Error correction"
-msgstr ""
+msgstr "Error correction"
 
 #. VezeF
 #: qrcode.xhp
@@ -20183,7 +20183,7 @@ msgctxt ""
 "par_id281566317365617\n"
 "help.text"
 msgid "The error correction value for the QR Code that is to be created. The error correction of a QR code is a measure that helps a QR code to recover if it is damaged."
-msgstr ""
+msgstr "The error correction value for the QR Code that is to be created. The error correction of a QR code is a measure that helps a QR code to recover if it is damaged."
 
 #. iHFHY
 #: qrcode.xhp
@@ -23765,7 +23765,7 @@ msgctxt ""
 "par_id041620170723504381\n"
 "help.text"
 msgid "If you have opened the %PRODUCTNAME start center and have not yet opened a document or application, the Template Manager may be accessed differently. <keycode>Ctrl-Shift-N</keycode> will still open the Template Manager, but it may also be accessed by choosing Templates from the left sidebar, and then choosing Manage Templates."
-msgstr ""
+msgstr "If you have opened the %PRODUCTNAME start centre and have not yet opened a document or application, the Template Manager may be accessed differently. <keycode>Ctrl-Shift-N</keycode> will still open the Template Manager, but it may also be accessed by choosing Templates from the left sidebar, and then choosing Manage Templates."
 
 #. oD5Ec
 #: template_manager.xhp
diff --git a/source/en-GB/helpcontent2/source/text/simpress/guide.po b/source/en-GB/helpcontent2/source/text/simpress/guide.po
index 43bf86c67ed..dd8107ac7c3 100644
--- a/source/en-GB/helpcontent2/source/text/simpress/guide.po
+++ b/source/en-GB/helpcontent2/source/text/simpress/guide.po
@@ -4,7 +4,7 @@ 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: 2020-01-07 14:10+0100\n"
-"PO-Revision-Date: 2020-02-18 14:15+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textsimpressguide/en_GB/>\n"
 "Language: en-GB\n"
@@ -1058,7 +1058,7 @@ msgctxt ""
 "par_id3149942\n"
 "help.text"
 msgid "Choose <switchinline select=\"appl\"><caseinline select=\"IMPRESS\"><menuitem>Slide - Properties</menuitem></caseinline><defaultinline><menuitem>Page - Properties</menuitem></defaultinline></switchinline>, and then click on the <emph>Background</emph> tab."
-msgstr ""
+msgstr "Choose <switchinline select=\"appl\"><caseinline select=\"IMPRESS\"><menuitem>Slide - Properties</menuitem></caseinline><defaultinline><menuitem>Page - Properties</menuitem></defaultinline></switchinline>, and then click on the <emph>Background</emph> tab."
 
 #. EoCa7
 #: background.xhp
@@ -3821,7 +3821,7 @@ msgctxt ""
 "par_id4150436\n"
 "help.text"
 msgid "To apply the master page to all of the pages in your document, select the <emph>Exchange background page</emph> check box, and then click <widget>OK</widget>."
-msgstr ""
+msgstr "To apply the master page to all of the pages in your document, select the <emph>Exchange background page</emph> check box, and then click <widget>OK</widget>."
 
 #. MAp6s
 #: masterpage.xhp
diff --git a/source/en-GB/helpcontent2/source/text/swriter/01.po b/source/en-GB/helpcontent2/source/text/swriter/01.po
index 755e11e9ee6..d3a2b92550a 100644
--- a/source/en-GB/helpcontent2/source/text/swriter/01.po
+++ b/source/en-GB/helpcontent2/source/text/swriter/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: 2020-04-03 11:47+0200\n"
+"POT-Creation-Date: 2020-04-08 14:22+0200\n"
 "PO-Revision-Date: 2020-02-18 14:15+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textswriter01/en_GB/>\n"
@@ -7306,13 +7306,13 @@ msgctxt ""
 msgid "Name"
 msgstr "Name"
 
-#. Zjnxw
+#. kDDEs
 #: 04090002.xhp
 msgctxt ""
 "04090002.xhp\n"
 "par_id3156259\n"
 "help.text"
-msgid "<variable id=\"FieldValue\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list."
+msgid "<variable id=\"FieldName\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list."
 msgstr ""
 
 #. DRRLC
diff --git a/source/en-GB/helpcontent2/source/text/swriter/04.po b/source/en-GB/helpcontent2/source/text/swriter/04.po
index 1ba025aaa18..6de776628f8 100644
--- a/source/en-GB/helpcontent2/source/text/swriter/04.po
+++ b/source/en-GB/helpcontent2/source/text/swriter/04.po
@@ -4,7 +4,7 @@ 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: 2020-03-13 12:06+0100\n"
-"PO-Revision-Date: 2020-02-18 14:15+0000\n"
+"PO-Revision-Date: 2020-04-05 21:16+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textswriter04/en_GB/>\n"
 "Language: en-GB\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1508501318.000000\n"
 
 #. brcGC
@@ -266,7 +266,7 @@ msgctxt ""
 "par_id3149957\n"
 "help.text"
 msgid "Spelling"
-msgstr ""
+msgstr "Spelling"
 
 #. BgpGm
 #: 01020000.xhp
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-04-15 14:08:14 +0200
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-04-15 14:12:29 +0200
commit	1cf550347fdb87391903b533dd1c47135875a9d7 (patch)
tree	42aeb67f0d164abb01f73d6ddc7c1d8927a253a3 /source/en-GB/helpcontent2
parent	0a73e51795ef412006c59d3723f265fed445dea1 (diff)