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/cs/helpcontent2
parent: 0a73e51795ef412006c59d3723f265fed445dea1 (diff)
8 files changed, 1420 insertions, 943 deletions
diff --git a/source/cs/helpcontent2/source/auxiliary.po b/source/cs/helpcontent2/source/auxiliary.po
index b9a7a05f59f..09bd6fb7939 100644
--- a/source/cs/helpcontent2/source/auxiliary.po
+++ b/source/cs/helpcontent2/source/auxiliary.po
@@ -4,8 +4,8 @@ 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: 2019-12-17 11:21+0000\n"
-"Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
+"PO-Revision-Date: 2020-04-15 11:08+0000\n"
+"Last-Translator: raal <raal@post.cz>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/auxiliary/cs/>\n"
 "Language: cs\n"
 "MIME-Version: 1.0\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n==1) ? 0 : (n>=2 && n<=4) ? 1 : 2;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1563452452.000000\n"
 
 #. fEEXD
@@ -248,7 +248,7 @@ msgctxt ""
 "08101\n"
 "node.text"
 msgid "Subtotals"
-msgstr ""
+msgstr "Mezisoučty"
 
 #. CzARM
 #: scalc.tree
diff --git a/source/cs/helpcontent2/source/text/sbasic/python.po b/source/cs/helpcontent2/source/text/sbasic/python.po
index ee0ebb956c9..c7ebc0011dc 100644
--- a/source/cs/helpcontent2/source/text/sbasic/python.po
+++ b/source/cs/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-03-28 17:49+0000\n"
+"PO-Revision-Date: 2020-04-04 18:16+0000\n"
 "Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicpython/cs/>\n"
 "Language: cs\n"
@@ -2489,7 +2489,7 @@ msgctxt ""
 "N0222\n"
 "help.text"
 msgid "Genuine Basic UNO facilities can be inferred from <literal>XSCRIPTCONTEXT</literal> global variable. Refer to %PRODUCTNAME API for a complete <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1script_1_1provider_1_1XScriptContext.html\" name=\"description of XSCRIPTCONTEXT\">description of XSCRIPTCONTEXT</link>. <literal>XSCRIPTCONTEXT</literal> methods summarize as:"
-msgstr "Možnosti, které nabízí UNO v Basicu, lze odvodit z globální proměnné <literal>XSCRIPTCONTEXT</literal>. Její <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1script_1_1provider_1_1XScriptContext.html\" name=\"Popis proměnné XSCRIPTCONTEXT\">kompletní popis</link> naleznete v dokumentaci API pro %PRODUCTNAME. Metody proměnné <literal>XSCRIPTCONTEXT</literal> lze souhrnně:"
+msgstr "Možnosti, které nabízí UNO v Basicu, lze odvodit z globální proměnné <literal>XSCRIPTCONTEXT</literal>. Její <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1script_1_1provider_1_1XScriptContext.html\" name=\"Popis proměnné XSCRIPTCONTEXT\">kompletní popis</link> naleznete v dokumentaci API pro %PRODUCTNAME. Metody proměnné <literal>XSCRIPTCONTEXT</literal> souhrnně:"
 
 #. U6KbS
 #: python_programming.xhp
@@ -2966,7 +2966,7 @@ msgctxt ""
 "N0450\n"
 "help.text"
 msgid "Copy <literal>screen_io</literal> Python module in <link href=\"text/sbasic/python/python_locations.xhp\" name=\"User macros\">My macros</link> within <UserProfile>/Scripts/python/pythonpath,"
-msgstr "Zkopírujte modul Pythonu <literal>screen_io</literal> do kontejneru <link href=\"text/sbasic/python/python_locations.xhp\" name=\"User macros\">Moje makra</link> umístěného v <UživatelskýProfil>/Scripts/python/pythonpath."
+msgstr "Zkopírujte modul Pythonu <literal>screen_io</literal> do kontejneru <link href=\"text/sbasic/python/python_locations.xhp\" name=\"Uživatelská makra\">Moje makra</link> umístěného v <UživatelskýProfil>/Scripts/python/pythonpath."
 
 #. bckjW
 #: python_screen.xhp
diff --git a/source/cs/helpcontent2/source/text/sbasic/shared.po b/source/cs/helpcontent2/source/text/sbasic/shared.po
index 3bd4bfa4e70..123a68d33cb 100644
--- a/source/cs/helpcontent2/source/text/sbasic/shared.po
+++ b/source/cs/helpcontent2/source/text/sbasic/shared.po
@@ -3,8 +3,8 @@ 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"
-"PO-Revision-Date: 2020-03-28 17:49+0000\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
+"PO-Revision-Date: 2020-04-04 18:16+0000\n"
 "Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/cs/>\n"
 "Language: cs\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 "Promenna=NazevFunkce(Parametr1, Parametr2,...)"
-
 #. 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 Promenna As TYP"
-
 #. 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 Promenna As TYP"
-
 #. 9akEs
 #: 01020300.xhp
 msgctxt ""
@@ -3022,15 +2950,6 @@ msgctxt ""
 msgid "The variable is valid in all modules."
 msgstr "Proměnná je platná ve všech modulech."
 
-#. ADEKE
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3158212\n"
-"help.text"
-msgid "Private VarName As TYPENAME"
-msgstr "Private Promenna As TYP"
-
 #. qeJQx
 #: 01020300.xhp
 msgctxt ""
@@ -3040,15 +2959,6 @@ msgctxt ""
 msgid "The variable is only valid in this module."
 msgstr "Proměnná je platná pouze v tomto modulu."
 
-#. WQdbC
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150886\n"
-"help.text"
-msgid "Dim VarName As TYPENAME"
-msgstr "Dim Promenna As TYP"
-
 #. 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 Promenna As TYP"
-
 #. hAB34
 #: 01020300.xhp
 msgctxt ""
@@ -17512,32 +17413,32 @@ msgctxt ""
 msgid "Error-Handling Functions"
 msgstr "Funkce pro zpracovávání chyb"
 
-#. 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=\"Funkce pro zpracovávání chyb\">Funkce pro zpracovávání chyb</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 "Pomocí následujících příkazů a funkcí je možné určit způsob, jakým bude $[officename] Basic reagovat na chyby za běhu."
+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 nabízí několik způsobů, jak předejít ukončení programu, pokud nastane chyba."
+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 "Syntaxe:"
 
+#. 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 "Příkaz For...Next"
 
-#. 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 (příkaz)</bookmark_value><bookmark_value>To (příkaz)</bookmark_value><bookmark_value>Step (příkaz)</bookmark_value><bookmark_value>Next (příkaz)</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=\"Příkaz For...Next\">Příkaz For...Next</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 "Určíte, kolikrát se mají opakovat příkazy mezi For...Next."
+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 "Syntaxe:"
 
-#. 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 čítač=začátek To konec [Step krok]"
+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 "blok příkazů"
+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 "blok příkazů"
+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 [čítač]"
+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 "Proměnné:"
 
-#. 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>Čítač:</emph> Čítači smyčky se na začátku přiřadí hodnota vpravo od rovnítka (začátek). Platné jsou pouze číselné proměnné. Čítač smyčky se zvyšuje nebo snižuje podle proměnné Krok, dokud nedosáhne hodnoty Konec."
+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>Začátek:</emph> Číselná proměnná, která určuje počáteční hodnotu počítadla smyčky."
+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>Konec:</emph> Číselná proměnná určující konečnou hodnotu počítadla smyčky."
+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>Krok:</emph> Nastaví hodnotu, o kterou se zvyšuje nebo snižuje čítač smyčky. Pokud není Krok určen, zvyšuje se čítač o 1. V tom případě musí být Konec větší než Začátek. Pokud chcete čítač snižovat, musí být Konec nižší než Začátek a Krok musí mít zápornou hodnotu."
+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 "Smyčka <emph>For...Next</emph> provádí všechny příkazy ve smyčce po určený počet opakování."
 
-#. 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 "Při snižování nebo zvyšování čítače kontroluje $[officename] Basic, zda již přesáhlo koncovou hodnotu. Jakmile čítač dosáhne nebo překročí koncovou hodnotu, smyčka automaticky skončí."
+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 "Pokud určíte krok 0, příkazy mezi <emph>For</emph> a <emph>Next</emph> se opakují neustále."
 
-#. 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 "Při snižování či zvyšování čítače kontroluje $[officename] Basic přetečení nebo podtečení. Smyčka skončí, když Počítadlo překročí Konec (kladný Krok) nebo je nižší než Konec (záporný Krok)."
+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 "Pro bezpodmínečné ukončení smyčky použijte příkaz <emph>Exit For</emph>. Tento příkaz musí být ve smyčce <emph>For...Next</emph>. Pro ukončovací podmínku je možné použít příkaz <emph>If...Then</emph>:"
 
-#. 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 "příkazy"
-
-#. 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 Podmínka = 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 "příkazy"
-
-#. 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 "Poznámka: Ve vnořených podmínkách <emph>For...Next</emph> platí, že pokud použijete bezpodmínečné ukončení <emph>Exit For</emph>, ukončí se jen jedna smyčka."
+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 "Příklad"
+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 "V následujícím příkladě jsou použity dvě vnořené smyčky k seřazení skupiny řetězců s 10 prvky ( sEntry() ), které jsou nejprve vyplněny různým obsahem:"
-
-#. 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=\"Příkaz Call\">Příkaz Call</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 "Přenese vykonávání programu do procedury, funkce nebo DLL procedury."
+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 "Parametry:"
 
-#. 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 "Je-li volána procedura, klíčové slovo není povinné. Je-li spuštěna funkce, musí být parametry uzavřeny v závorkách. Je-li volána funkce knihovny DLL, musí být nejprve určena příkazem <emph>Declare</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</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\">Funkce CVErr</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</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\">Funkce IsError</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 "Syntaxe:"
 
-#. 6bD7g
+#. ZR3gW
 #: 03103100.xhp
 msgctxt ""
 "03103100.xhp\n"
-"par_id3154285\n"
+"par_id41586012988213\n"
 "help.text"
-msgid "[Let] VarName=Expression"
-msgstr "[Let] NázevProměnné=Výraz"
+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 "Parametry:"
 
-#. 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>NázevProměnné:</emph> Proměnná, které chcete přiřadit hodnotu. Typ hodnoty a proměnné musí být kompatibilní."
+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 "Příkaz Set"
 
-#. 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 (příkaz)</bookmark_value><bookmark_value>objekt Nothing</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=\"Příkaz Set\">Příkaz Set</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 "Nastaví odkaz na objekt, proměnnou nebo vlastnost."
+msgid "Sets an object reference on a variable."
+msgstr ""
 
 #. MkkED
 #: 03103700.xhp
@@ -30139,14 +30022,23 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntaxe:"
 
-#. 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 ObjektProm = Objekt"
+msgid "Set variable = object"
+msgstr ""
 
 #. r4fJx
 #: 03103700.xhp
@@ -30157,32 +30049,41 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parametry:"
 
-#. 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>ObjektProm:</emph> Proměnná nebo vlastnost, která vyžaduje odkaz na objekt."
+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>Objekt:</emph> Objekt, na který odkazuje proměnná nebo vlastnost."
+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> - Přiřazením objektu <emph>Nothing</emph> proměnné odstraníte předchozí přiřazení."
+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 "Příklad:"
 
+#. 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 "Viz také <link href=\"text/sbasic/shared/00000002.xhp\" name=\"external\">zápis adresy URL</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 ""
@@ -40703,7 +40793,7 @@ msgctxt ""
 "N0030\n"
 "help.text"
 msgid "Enumerated values are rendered to <emph>Long</emph> datatype. Basic functions are public accessors to enumerations. Enumeration names and value names must be unique within a library and across modules."
-msgstr "Hodnoty výčtu jsou představovány datovým typem <emph>Long</emph>. K výčtům lze veřejně přistupovat pomocí funkcí. Názvy výčtů a jejich hodnot musí být jedineční v rámci knihovny a napříč moduly."
+msgstr "Hodnoty výčtu jsou představovány datovým typem <emph>Long</emph>. K výčtům lze veřejně přistupovat pomocí funkcí. Názvy výčtů a jejich hodnot musí být jedinečné v rámci knihovny a napříč moduly."
 
 #. zESQa
 #: enum.xhp
@@ -41225,7 +41315,7 @@ msgctxt ""
 "N0183\n"
 "help.text"
 msgid "A property, also called field or attribute, characterizes a given object or piece of information. Properties can be used to control access to data. It is common use to include instructions at setting or reading time of properties. Code can vary from simple assignment to complex context dependant routines. Using <emph>Get</emph>, <emph>Let</emph> or <emph>Set</emph> accessers enforces properties' consistency when necessary."
-msgstr "Vlastnost, označovaná také jako atribut, charakterizuje daný objekt nebo informaci. Vlastnosti lze použít k řízení přístupu k datům. Obvykle se zadávají instrukce, které se mají provést při nastavování nebo čtení vlastnosti. Může se jednat o jednoduché přiřazení i o komplexní podprogramy závisející na kontextu. Použití přístupových funkcí <emph>Get</emph>, <emph>Let</emph> a <emph>Set</emph> v případě potřeby zajišťují, aby vlastnost zůstala konzistentní."
+msgstr "Vlastnost, označovaná také jako atribut, charakterizuje daný objekt nebo informaci. Vlastnosti lze použít k řízení přístupu k datům. Obvykle se zadávají instrukce, které se mají provést při nastavování nebo čtení vlastnosti. Může se jednat o jednoduché přiřazení i o komplexní podprogramy závisející na kontextu. Přístupové funkce <emph>Get</emph>, <emph>Let</emph> a <emph>Set</emph> v případě potřeby zajišťují, aby vlastnost zůstala konzistentní."
 
 #. hD9fA
 #: property.xhp
diff --git a/source/cs/helpcontent2/source/text/scalc/00.po b/source/cs/helpcontent2/source/text/scalc/00.po
index 21cf0e9c5ae..4645b6aed8d 100644
--- a/source/cs/helpcontent2/source/text/scalc/00.po
+++ b/source/cs/helpcontent2/source/text/scalc/00.po
@@ -4,8 +4,8 @@ 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-03-15 08:15+0000\n"
-"Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
+"PO-Revision-Date: 2020-04-10 00:16+0000\n"
+"Last-Translator: raal <raal@post.cz>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/cs/>\n"
 "Language: cs\n"
 "MIME-Version: 1.0\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n==1) ? 0 : (n>=2 && n<=4) ? 1 : 2;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1557549259.000000\n"
 
 #. E9tti
@@ -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\">Zvolte<menuitem>Data - Řadit vzestupně</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\">Zvolte<menuitem>Data - Řadit sestupně</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\">Na liště <emph>Standardní</emph> klepněte na</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\">Ikona Řadit vzestupně</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\">Ikona Řadit sestupně</alt></image>"
 
 #. AHMAB
 #: 00000412.xhp
diff --git a/source/cs/helpcontent2/source/text/scalc/01.po b/source/cs/helpcontent2/source/text/scalc/01.po
index 01ce6ca104a..8b7580439ab 100644
--- a/source/cs/helpcontent2/source/text/scalc/01.po
+++ b/source/cs/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-15 08:15+0000\n"
 "Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/cs/>\n"
@@ -6200,14 +6200,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\">Spočítá částku vyplacenou k danému datu splatnosti cenného papíru s pevným úrokem.</ahelp>"
 
-#. XhTVX
+#. BiDCz
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3145362\n"
 "help.text"
-msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"
-msgstr "RECEIVED(Smlouva;Splatnost;Investice;Diskontní sazba;Základ)"
+msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])"
+msgstr ""
 
 #. oHAVz
 #: 04060103.xhp
@@ -6992,14 +6992,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\">Spočítá diskontní sazbu cenného papíru v procentech.</ahelp>"
 
-#. tusey
+#. fBGBA
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3149756\n"
 "help.text"
-msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"
-msgstr "DISC(Smlouva;Splatnost;Cena;Výkupní cena;Základ)"
+msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])"
+msgstr ""
 
 #. Uyj29
 #: 04060103.xhp
@@ -7082,14 +7082,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\">Spočítá dobu trvání (počet roků) pro cenný papír s fixní úrokovou sazbou.</ahelp>"
 
-#. bJZPP
+#. 7ixum
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3153373\n"
 "help.text"
-msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"
-msgstr "DURATION(\"Smlouva\"; \"Splatnost\"; Kupón; Výnos; Frekvence; Základ)"
+msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])"
+msgstr ""
 
 #. JeeVp
 #: 04060103.xhp
@@ -7145,14 +7145,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 "Cenný papír byl nakoupen 2001-01-01; datum splatnosti je 2006-01-01. Nominální úroková sazba je 8 %. Výnos je 9,0 %. Úrok je vyplácen pololetně (frekvence je 2). S použitím výpočtu denní bilance úroku (základ 3), jaká je doba trvání?"
 
-#. 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
@@ -12662,420 +12662,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> vrátí dekadický logaritmus čísla 5 (přibližně 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</bookmark_value><bookmark_value>zaokrouhlování; nahoru na určený počet míst</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\">Zaokrouhlí zadané číslo nahoru na násobek zadaného čísla.</ahelp>"
-
-#. fhdEu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153454\n"
-"help.text"
-msgid "CEILING(Number; Significance; Mode)"
-msgstr "CEILING(Číslo; Násobek; Režim)"
-
-#. 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>Číslo</emph> je číslo, které se bude zaokrouhlovat."
-
-#. 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>Násobek</emph> určuje číslo, na jehož násobky se zaokrouhluje nahoru."
-
-#. 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>Režim</emph> je volitelná hodnota. Pokud je hodnota režimu uvedena a není rovna nule a pokud je Číslo a Významnost negativní, zaokrouhlení se provede na základě absolutní hodnoty Čísla, tj. záporná čísla se zaokrouhlují od nuly. Pokud je hodnota Režimu rovna nule nebo není uvedena, záporná čísla se zaokrouhlují na nulu."
-
-#. 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 "Pokud je sešit exportován do aplikace Microsoft Excel, funkce CEILING je exportována jako ekvivalentní funkce CEILING.MATH, která existuje od verze 2013. Pokud plánujete použít sešit s dřívějšími verzemi aplikace Excel, použijte buď CEILING.PRECISE, která existuje od verze 2010, nebo CEILING.XCL, která je exportována jako funkce CEILING kompatibilní se všemi verzemi aplikace Excel. Všimněte si, že CEILING.XCL se vždy zaokrouhluje od nuly."
-
-#. 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> vrátí -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> vrátí -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> vrátí -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</bookmark_value><bookmark_value>zaokrouhlování;nahoru na určený počet míst</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\">Zaokrouhlí číslo na nejbližší vyšší násobek argumentu, bez ohledu na znaménko tohoto argumentu.</ahelp>"
-
-#. af8Jy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953454\n"
-"help.text"
-msgid "CEILING.PRECISE(Number; Significance)"
-msgstr "CEILING.PRECISE(Číslo; Násobek)"
-
-#. 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>Číslo</emph> (vyžadováno) je číslo, které se má zaokrouhlit nahoru."
-
-#. 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>Násobek</emph> (nepovinné) je číslo, k jehož násobku má být hodnota zaokrouhlena nahoru."
-
-#. 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> vrátí -10"
-
-#. CyR3Z
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id911516997198644\n"
-"help.text"
-msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
-msgstr "<bookmark_value>funkce CEILING.MATH</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\">Zaokrouhlí číslo na nejbližší násobek Významnosti.</ahelp>"
-
-#. dEs2U
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id841516997669932\n"
-"help.text"
-msgid "CEILING.MATH(Number; Significance; Mode)"
-msgstr "CEILING.MATH(Číslo; Významnost; Režim)"
-
-#. 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>Číslo</emph> je číslo, které se bude zaokrouhlovat."
-
-#. 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>Významnost</emph> určuje číslo, na jehož násobky se zaokrouhluje nahoru."
-
-#. 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>Režim</emph> je volitelná hodnota. Pokud je hodnota režimu uvedena a není rovna nule a pokud je Číslo a Významnost negativní, zaokrouhlení se provede na základě absolutní hodnoty Čísla, tj. záporná čísla se zaokrouhlují od nuly. Pokud je hodnota Režimu rovna nule nebo není uvedena, záporná čísla se zaokrouhlují na nulu."
-
-#. 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 "Tato funkce existuje pro interoperabilitu s aplikací Microsoft Excel 2013 nebo novější."
-
-#. 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> vrátí -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> vrátí -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> vrátí -12"
-
-#. 5eFKb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id921516998608939\n"
-"help.text"
-msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
-msgstr "<bookmark_value>funkce CEILING.XCL</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\">Zaokrouhluje číslo od nuly k nejbližšímu násobku Významnosti.</ahelp>"
-
-#. hh5aZ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id251516998856873\n"
-"help.text"
-msgid "CEILING.XCL(Number; Significance)"
-msgstr "CEILING.XCL(Číslo; Významnost)"
-
-#. 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>Číslo</emph> je číslo, které se bude zaokrouhlovat."
-
-#. 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>Významnost</emph> určuje číslo, na jehož násobky se zaokrouhluje."
-
-#. 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 "Tato funkce existuje pro interoperabilitu s Microsoft Excel 2007 nebo staršími verzemi."
-
-#. 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> vrátí 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> vrátí 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> vrátí -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</bookmark_value><bookmark_value>zaokrouhlování; nahoru na určený počet míst</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\">Zaokrouhlí číslo na nejbližší vyšší násobek argumentu, bez ohledu na znaménko tohoto argumentu.</ahelp>"
-
-#. iGoz8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953454\n"
-"help.text"
-msgid "ISO.CEILING(Number; Significance)"
-msgstr "ISO.CEILING(Číslo; Násobek)"
-
-#. 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>Číslo</emph> (vyžadováno) je číslo, které se má zaokrouhlit nahoru."
-
-#. 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>Násobek</emph> (nepovinné) je číslo, k jehož násobku má být hodnota zaokrouhlena nahoru."
-
-#. 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> vrátí -10"
-
 #. tQjUA
 #: 04060106.xhp
 msgctxt ""
@@ -15038,168 +14624,6 @@ msgctxt ""
 msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5."
 msgstr "<item type=\"input\">=ODD(-3,1)</item> vrátí -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</bookmark_value><bookmark_value>FLOOR.XCL</bookmark_value><bookmark_value>zaokrouhlování; dolů na určený počet míst</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\">Zaokrouhlí číslo k nejbližšímu násobku argumentu, bez ohledu na znaménko tohoto argumentu.</ahelp>"
-
-#. BKB8E
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957464\n"
-"help.text"
-msgid "FLOOR.PRECISE(Number; Significance)"
-msgstr "FLOOR.PRECISE(Číslo; Násobek)"
-
-#. 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>Číslo</emph> je číslo, které se má zaokrouhlit dolů."
-
-#. 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>Násobek</emph> je hodnota, k jejímuž násobku má být číslo zaokrouhleno dolů."
-
-#. 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> vrátí -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</bookmark_value><bookmark_value>FLOOR.MATH</bookmark_value><bookmark_value>zaokrouhlování; dolů na určený počet míst</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\">Zaokrouhlí číslo dolů na nejbližší nižší násobek parametru Násobek.</ahelp>"
-
-#. DDbJ6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157464\n"
-"help.text"
-msgid "FLOOR(Number; Significance; Mode)"
-msgstr "FLOOR(Číslo; Násobek; Režim)"
-
-#. 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>Číslo</emph> je číslo, které se má zaokrouhlit dolů."
-
-#. 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>Násobek</emph> je hodnota, k jejímuž násobku má být číslo zaokrouhleno dolů."
-
-#. 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>Režim</emph> je volitelná hodnota. Pokud je hodnota režimu uvedena a není rovna nule a pokud je Číslo a Významnost negativní, zaokrouhlení se provede na základě absolutní hodnoty Čísla, tj. záporná čísla se zaokrouhlují na nulu. Pokud je hodnota Režimu rovna nule nebo není uvedena, záporná čísla se zaokrouhlují od nuly."
-
-#. 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 "Pokud je sešit exportován do aplikace Microsoft Excel, funkce FLOOR je exportována jako ekvivalentní funkce FLOOR.MATH, která existuje od verze Excel 2013. Pokud plánujete použít sešit s dřívějšími verzemi aplikace Excel, použijte buď FLOOR.PRECISE, která existuje od verze 2010, nebo FLOOR.XCL, která je exportována jako funkce FLOOR kompatibilní se všemi verzemi aplikace Excel. Všimněte si, že FLOOR.XCL se vždy zaokrouhluje na nulu."
-
-#. 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> vrátí -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> vrátí -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> vrátí -10"
-
 #. itiAQ
 #: 04060106.xhp
 msgctxt ""
@@ -16586,41 +16010,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\">Vypočítá maticový součin dvou matic.</ahelp> Počet sloupců první matice se musí rovna počtu řádků druhé matice. Čtvercová matice má stejný počet řádků i sloupců."
 
-#. dEKAU
+#. JUTAD
 #: 04060107.xhp
 msgctxt ""
 "04060107.xhp\n"
 "par_id3150798\n"
 "help.text"
-msgid "MMULT(Array; Array)"
-msgstr "MMULT(Matice; Matice)"
+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>Matice</emph> jako první parametr značí první činitel maticového součinu."
+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>Matice</emph> jako druhý parametr je druhý činitel maticového součinu."
+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 "Vyberte čtvercovou oblast buněk. Vyberte funkci MMULT. Zadejte první <emph>Matici</emph> a potom druhou <emph>Matici</emph>. V <emph>Průvodci funkcí</emph> zaškrtněte pole <emph>Matice</emph>. Klepněte na tlačítko <emph>OK</emph>. Výsledná matice se objeví v oblasti buněk označené v prvním kroku."
+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
@@ -18314,15 +17738,6 @@ msgctxt ""
 msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518."
 msgstr "Pokud se v buňce A1 zobrazuje Chyba:518, funkce <item type=\"input\">=ERRORTYPE(A1)</item> vrátí číslo 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 ""
@@ -33785,6 +33200,15 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>"
 msgstr "<ahelp hid=\".\">Vrátí inverzní funkci k 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 ""
@@ -35765,6 +35189,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=\".\">Vrátí hodnotu gama funkce.</ahelp> Pamatujte na to, že GAMMAINV není inverzní funkcí ke GAMMA, ale ke GAMMADIST."
 
+#. WT29Z
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id211585771824267\n"
+"help.text"
+msgid "GAMMA(Number)"
+msgstr ""
+
 #. 2DdQa
 #: 04060182.xhp
 msgctxt ""
@@ -36638,14 +36071,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Vrátí hypergeometrické rozdělení.</ahelp>"
 
-#. fNMzN
+#. 5uQ3c
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id3155388\n"
 "help.text"
-msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation)"
-msgstr "HYPGEOMDIST(X; NVýběr; Úspěchy; NZákladníSoubor)"
+msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])"
+msgstr ""
 
 #. ingyW
 #: 04060182.xhp
@@ -36683,6 +36116,15 @@ msgctxt ""
 msgid "<emph>NPopulation </emph>is the size of the total population."
 msgstr "<emph>NZákladníSoubor</emph> je velikost celého základního souboru."
 
+#. 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 ""
@@ -55988,6 +55430,528 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Pokud E2 = nůž, funkce vrátí 65, protože odkaz na buňku je nahrazen jejím obsahem."
 
+#. 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 ""
@@ -56951,14 +56915,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\">Vrátí rozdíl mezi dvěma daty s použitím roků o délce 360 dní (které se používají při výpočtu úroků).</ahelp>"
 
-#. ow4Jg
+#. Vndiw
 #: func_days360.xhp
 msgctxt ""
 "func_days360.xhp\n"
 "par_id3155313\n"
 "help.text"
-msgid "DAYS360(\"Date1\"; \"Date2\"; Type)"
-msgstr "DAYS360(Datum 1;Datum 2;Typ)"
+msgid "DAYS360(Date1; Date2[; Type])"
+msgstr ""
 
 #. 5qfGz
 #: func_days360.xhp
@@ -57608,6 +57572,429 @@ msgctxt ""
 msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
 msgstr "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> vrátí 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/cs/helpcontent2/source/text/scalc/guide.po b/source/cs/helpcontent2/source/text/scalc/guide.po
index ea90ebb557f..2a66c413314 100644
--- a/source/cs/helpcontent2/source/text/scalc/guide.po
+++ b/source/cs/helpcontent2/source/text/scalc/guide.po
@@ -4,8 +4,8 @@ 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-28 14:00+0000\n"
-"Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
+"PO-Revision-Date: 2020-04-10 00:16+0000\n"
+"Last-Translator: raal <raal@post.cz>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/cs/>\n"
 "Language: cs\n"
 "MIME-Version: 1.0\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n==1) ? 0 : (n>=2 && n<=4) ? 1 : 2;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1547389818.000000\n"
 
 #. NXy6S
@@ -11345,7 +11345,7 @@ msgctxt ""
 "hd_id3148798\n"
 "help.text"
 msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link></variable>"
-msgstr ""
+msgstr "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filtr: Použití pokročilých filtrů</link></variable>"
 
 #. tYuAi
 #: specialfilter.xhp
@@ -11804,7 +11804,7 @@ msgctxt ""
 "tit\n"
 "help.text"
 msgid "Using Subtotals Tool"
-msgstr ""
+msgstr "Použití nástroje Mezisoučty"
 
 #. aKjYH
 #: subtotaltool.xhp
@@ -11813,7 +11813,7 @@ msgctxt ""
 "bm_id521585182060496\n"
 "help.text"
 msgid "<bookmark_value>subtotals;using subtotals tool</bookmark_value>"
-msgstr ""
+msgstr "<bookmark_value>mezisoučty;použití nástroje mezisoučty</bookmark_value>"
 
 #. 6JBG9
 #: subtotaltool.xhp
@@ -11822,7 +11822,7 @@ msgctxt ""
 "hd_id631585177069332\n"
 "help.text"
 msgid "<variable id=\"subtotaltoolh1\"><link href=\"text/scalc/guide/subtotaltool.xhp\" name=\"Using Subtotal Tool\">Using Subtotal Tool</link></variable>"
-msgstr ""
+msgstr "<variable id=\"subtotaltoolh1\"><link href=\"text/scalc/guide/subtotaltool.xhp\" name=\"Použití nástroje Mezisoučty\">Using Subtotal Tool</link></variable>"
 
 #. rC9BC
 #: subtotaltool.xhp
diff --git a/source/cs/helpcontent2/source/text/shared/01.po b/source/cs/helpcontent2/source/text/shared/01.po
index cff91d489fb..4bb71ca935d 100644
--- a/source/cs/helpcontent2/source/text/shared/01.po
+++ b/source/cs/helpcontent2/source/text/shared/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-03-31 10:35+0200\n"
-"PO-Revision-Date: 2020-03-28 17:49+0000\n"
+"PO-Revision-Date: 2020-04-04 18:16+0000\n"
 "Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textshared01/cs/>\n"
 "Language: cs\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n==1) ? 0 : (n>=2 && n<=4) ? 1 : 2;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Weblate 3.10.3\n"
 "X-POOTLE-MTIME: 1547111868.000000\n"
 
 #. 3u8hR
@@ -29588,7 +29588,7 @@ msgctxt ""
 "par_id3155934\n"
 "help.text"
 msgid "This <emph>Fontwork</emph> dialog is meant for making text follow a curve. Draw a curve, double-click it and type text into it. With the curve selected, you can now activate the Fontwork command. <switchinline select=\"appl\"><caseinline select=\"WRITER\">Access the dialog by choosing <menuitem>Format - Text Box and Shape - Fontwork</menuitem></caseinline><defaultinline>First call <menuitem>Tools - Customize</menuitem> to add a menu command or a toolbar button to open the dialog. The <emph>Fontwork</emph> command is found in the Format category of the Customize dialog</defaultinline></switchinline>."
-msgstr "Dialogové okno <emph>Písmomalba</emph> slouží k vytvoření textu následujícího křivku. Nakreslete křivku, poklepejte na ni a zadejte na ni text. Když tuto křivku vyberete, můžete použít příkaz Písmomalba. <switchinline select=\"appl\"><caseinline select=\"WRITER\">Otevřete jeho dialogového okno volbou <menuitem>Formát - Textové pole a tvar - Písmomalba</menuitem></caseinline><defaultinline>. Můžete si také přidat vlastní příkaz nabídky nebo tlačítko na nástrojovou lištu pomocí <menuitem>Nástroje - Přizpůsobit</menuitem>. Příkaz <emph>Písmomalba </emph> se nachází v tomto dialogu v kategorii Formát</defaultinline></switchinline>."
+msgstr "Dialogové okno <emph>Písmomalba</emph> slouží k vytvoření textu následujícího křivku. Nakreslete křivku, poklepejte na ni a zadejte text. Když tuto křivku vyberete, můžete použít příkaz Písmomalba. <switchinline select=\"appl\"><caseinline select=\"WRITER\">Otevřete dialogové okno volbou <menuitem>Formát - Textové pole a tvar - Písmomalba</menuitem></caseinline><defaultinline>. Můžete si také přidat vlastní příkaz nabídky nebo tlačítko na nástrojovou lištu pomocí <menuitem>Nástroje - Přizpůsobit</menuitem>. Příkaz <emph>Písmomalba </emph> se nachází v tomto okně v kategorii Formát</defaultinline></switchinline>."
 
 #. dLxem
 #: 05280000.xhp
@@ -30371,7 +30371,7 @@ msgctxt ""
 "par_id3157991\n"
 "help.text"
 msgid "To select an individual object in a group, hold down <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline>, and then click the object."
-msgstr "Chcete-li ve skupině vybrat jednotlivý objekt, podržte <switchinline select=\"sys\"> <caseinline select=\"MAC\"><emph>Command</emph></caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> a poté na objekt klepněte."
+msgstr "Chcete-li ve skupině vybrat jednotlivý objekt, podržte <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> a poté na objekt klepněte."
 
 #. yNMnY
 #: 05290300.xhp
@@ -37922,7 +37922,7 @@ msgctxt ""
 "par_id1015655\n"
 "help.text"
 msgid "<ahelp hid=\".\">Enter the distance from the left page margin at which the numbering symbol will be aligned.</ahelp>"
-msgstr "<ahelp hid=\".\"> Vložte vzdálenost od levého okraje stránky, na kterou mají být symboly zarovnány</ahelp>"
+msgstr "<ahelp hid=\".\">Zadejte vzdálenost od levého okraje stránky, na kterou mají být symboly zarovnány</ahelp>"
 
 #. nv46o
 #: 06050600.xhp
@@ -38003,7 +38003,7 @@ msgctxt ""
 "par_id6081728\n"
 "help.text"
 msgid "<ahelp hid=\".\">Enter the distance from the left page margin to the start of all lines in the numbered paragraph that follow the first line.</ahelp>"
-msgstr "<ahelp hid=\".\"> Vložte vzdálenost od levého okraje stránky pro začátek všech řádek v číslovaném odstavci, který následuje za první řádkou. </ahelp>"
+msgstr "<ahelp hid=\".\">Zadejte vzdálenost od levého okraje stránky, ve které budou začínat všechny řádky v číslovaném odstavci, které následují po prvním řádku.</ahelp>"
 
 #. B9fGG
 #: 06050600.xhp
diff --git a/source/cs/helpcontent2/source/text/swriter/01.po b/source/cs/helpcontent2/source/text/swriter/01.po
index fd42a4b86ab..0162f07385f 100644
--- a/source/cs/helpcontent2/source/text/swriter/01.po
+++ b/source/cs/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-03-28 17:49+0000\n"
 "Last-Translator: Stanislav Horáček <stanislav.horacek@gmail.com>\n"
 "Language-Team: Czech <https://weblate.documentfoundation.org/projects/libo_help-master/textswriter01/cs/>\n"
@@ -7306,14 +7306,14 @@ msgctxt ""
 msgid "Name"
 msgstr "Název"
 
-#. 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."
-msgstr "<variable id=\"FieldValue\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Zadejte název uživatelského pole, které chcete vytvořit.</ahelp></variable> K nastavení cíle klepněte na \"Nastavit odkaz\" v seznamu <emph>Typ</emph>, zadejte název a klepněte na <emph>Vložit</emph>. K vytvoření odkazu na nový cíl klepněte na název cíle v seznamu <emph>Výběr</emph>."
+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
 #: 04090002.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/cs/helpcontent2
parent	0a73e51795ef412006c59d3723f265fed445dea1 (diff)