update translations for 7.0.0 beta1 libreoffice-7-0-branch-point

and force-fix errors using pocheck

Change-Id: I1adc224071cce4a7e0b21209890b3777f9e2539b

13 files changed, 1487 insertions, 843 deletions

diff --git a/source/nl/helpcontent2/source/text/sbasic/shared.po b/source/nl/helpcontent2/source/text/sbasic/shared.po
index 9f1c172e864..0e50da9cfe8 100644
--- a/source/nl/helpcontent2/source/text/sbasic/shared.po
+++ b/source/nl/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-05-05 14:59+0200\n"
+"POT-Creation-Date: 2020-05-25 20:00+0200\n"
 "PO-Revision-Date: 2020-03-02 09:16+0000\n"
 "Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/nl/>\n"
@@ -5128,14 +5128,14 @@ msgctxt ""
 msgid "Pass Count"
 msgstr "Doorloop"
 
-#. AzGxm
+#. hZEbs
 #: 01050300.xhp
 msgctxt ""
 "01050300.xhp\n"
 "par_id3161831\n"
 "help.text"
-msgid "<ahelp hid=\"modules/BasicIDE/ui/managebreakpoints/pass-nospin\">Specify the number of loops to perform before the breakpoint takes effect.</ahelp>"
-msgstr "<ahelp hid=\"modules/BasicIDE/ui/managebreakpoints/pass-nospin\">Specificeert het aantal doorlopen dat uitgevoerd moet worden voordat het onderbrekingspunt geactiveerd wordt.</ahelp>"
+msgid "<ahelp hid=\"modules/BasicIDE/ui/managebreakpoints/pass\">Specify the number of loops to perform before the breakpoint takes effect.</ahelp>"
+msgstr ""
 
 #. gr8LF
 #: 01050300.xhp
@@ -8188,68 +8188,59 @@ msgctxt ""
 msgid "Outputs the specified strings or numeric expressions to a dialog or to a file."
 msgstr "Schrijft de gespecificeerde strings of numerieke uitdrukkingen weg naar een dialoogvenster of naar een bestand."
 
-#. QSTQ3
+#. AhB82
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
-"hd_id3145785\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Syntaxis:"
+msgid "<image src=\"media/helpimg/sbasic/Print_statement.svg\" id=\"img_id931588605629842\"><alt id=\"alt_id931588605629842\">Print syntax</alt></image>"
+msgstr ""
 
-#. oBHh5
+#. A6QEE
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
 "par_id3153188\n"
 "help.text"
-msgid "Print [#FileName,] Expression1[{;|,} [Spc(Number As Integer);] [Tab(pos As Integer);] [Expression2[...]]"
-msgstr "Print [#FileName,] Expression1[{;|,} [Spc(Number As Integer);] [Tab(pos As Integer);] [Expression2[...]]"
-
-#. V7hQL
-#: 03010103.xhp
-msgctxt ""
-"03010103.xhp\n"
-"hd_id3147348\n"
-"help.text"
-msgid "Parameter:"
-msgstr "Parameter:"
+msgid "Print [#filenum,] expression1[{;|,} [Spc(number As Integer);] [Tab(pos As Integer);] [expression2[...]]"
+msgstr ""
 
-#. J5XzU
+#. NWBqr
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
 "par_id2508621\n"
 "help.text"
-msgid "<emph>FileName:</emph> Any numeric expression that contains the file number that was set by the Open statement for the respective file."
-msgstr "<emph>BestandsNaam:</emph> Elke numerieke uitdrukking die het bestandsnummer bevat dat werd ingesteld door de instructie Open voor het betreffende bestand."
+msgid "<emph>filenum:</emph> Any numeric expression that contains the file number that was set by the <literal>Open</literal> statement for the respective file."
+msgstr ""
 
-#. gnDQ8
+#. Zoa2X
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
 "par_id3163712\n"
 "help.text"
-msgid "<emph>Expression</emph>: Any numeric or string expression to be printed. Multiple expressions can be separated by a semicolon. If separated by a comma, the expressions are indented to the next tab stop. The tab stops cannot be adjusted."
-msgstr "<emph>Expressie</emph>: Elke tekenreeks of numerieke expressie kan worden afgedrukt. Meerdere expressies kunnen worden gescheiden door een puntkomma. Als ze gescheiden worden door een komma, springen de expressies in naar de volgende tabstop. De tabstops kunnen niet worden aangepast."
+msgid "<emph>expression</emph>: Any numeric or string expression to be printed. Multiple expressions can be separated by a semicolon. If separated by a comma, the expressions are indented to the next tab stop. The tab stops cannot be adjusted."
+msgstr ""
 
-#. oAkpr
+#. HB3kc
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
 "par_id3153092\n"
 "help.text"
-msgid "<emph>Number</emph>: Number of spaces to be inserted by the <emph>Spc</emph> function."
-msgstr "<emph>Getal</emph>: Het aantal spaties dat moet worden ingevoegd door de functie <emph>Spc</emph>."
+msgid "<emph>number</emph>: Number of spaces to be inserted by the <emph>Spc</emph> function."
+msgstr ""
 
-#. qPngH
+#. QDwLF
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
 "par_id3145364\n"
 "help.text"
-msgid "<emph>Pos</emph>: Spaces are inserted until the specified position."
-msgstr "<emph>Pos</emph>: Spaties worden ingevoegd tot de gespecificeerde positie."
+msgid "<emph>pos</emph>: Spaces are inserted until the specified position."
+msgstr ""
 
 #. GiAKc
 #: 03010103.xhp
@@ -8287,15 +8278,6 @@ msgctxt ""
 msgid "You can insert the <emph>Tab</emph> function, enclosed by semicolons, between arguments to indent the output to a specific position, or you can use the <emph>Spc</emph> function to insert a specified number of spaces."
 msgstr "U kunt de <emph>Tab</emph>-functie (tussen puntkomma's) tussen argumenten invoegen om de uitvoer naar een specifieke positie in te laten springen of u kunt de <emph>Spc</emph>-functie gebruiken om een gespecificeerd aantal spaties in te voegen."
 
-#. AoqEt
-#: 03010103.xhp
-msgctxt ""
-"03010103.xhp\n"
-"hd_id3146912\n"
-"help.text"
-msgid "Example:"
-msgstr "Voorbeeld:"
-
 #. knWZh
 #: 03010200.xhp
 msgctxt ""
@@ -22255,14 +22237,14 @@ msgctxt ""
 msgid "Select...Case Statement"
 msgstr "Instructie Select...Case"
 
-#. qov74
+#. PgL5b
 #: 03090102.xhp
 msgctxt ""
 "03090102.xhp\n"
 "bm_id3149416\n"
 "help.text"
-msgid "<bookmark_value>Select...Case statement</bookmark_value>  <bookmark_value>Case statement</bookmark_value>"
-msgstr "<bookmark_value>Select...Case-instructie</bookmark_value>  <bookmark_value>Case-instructie</bookmark_value>"
+msgid "<bookmark_value>Select Case statement</bookmark_value>  <bookmark_value>Case keyword; in Select Case statement</bookmark_value>"
+msgstr ""
 
 #. CBpPz
 #: 03090102.xhp
@@ -22282,14 +22264,14 @@ msgctxt ""
 msgid "Defines one or more statement blocks depending on the value of an expression."
 msgstr "Definieert één of meer instructieblokken, afhankelijk van de waarde van een expressie."
 
-#. M9zYG
+#. CFYkp
 #: 03090102.xhp
 msgctxt ""
 "03090102.xhp\n"
-"hd_id3147265\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Syntaxis:"
+msgid "<image src=\"media/helpimg/sbasic/Select-Case_statement.svg\" id=\"img_id931588605629842\"><alt id=\"alt_id931588605629842\">Select Case syntax</alt></image>"
+msgstr ""
 
 #. jsSZ5
 #: 03090102.xhp
@@ -22300,41 +22282,23 @@ msgctxt ""
 msgid "Select Case condition Case expression Statement Block [Case expression2 Statement Block][Case Else] Statement Block End Select"
 msgstr "Select Case Voorwaarde Case Expressie InstructieBlok [Case Expressie2 InstructieBlok][Case Else] InstructieBlok End Select"
 
-#. C5Bsm
-#: 03090102.xhp
-msgctxt ""
-"03090102.xhp\n"
-"hd_id3150767\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#. 7XCQ2
+#. yuqsv
 #: 03090102.xhp
 msgctxt ""
 "03090102.xhp\n"
 "par_id3156281\n"
 "help.text"
-msgid "<emph>Condition:</emph> Any expression that controls if the statement block that follows the respective Case clause is executed."
-msgstr "<emph>Voorwaarde:</emph> Elke expressie die bepaalt of het instructieblok dat volgt op de respectievelijke Case-instructie wordt uitgevoerd."
+msgid "<emph>condition:</emph> Any expression that controls if the statement block that follows the respective Case clause is executed."
+msgstr ""
 
-#. BJPwk
+#. DoPTj
 #: 03090102.xhp
 msgctxt ""
 "03090102.xhp\n"
 "par_id3150448\n"
 "help.text"
-msgid "<emph>Expression:</emph> Any expression that is compatible with the Condition type expression. The statement block that follows the Case clause is executed if <emph>Condition</emph> matches <emph>Expression</emph>."
-msgstr "<emph>Expressie:</emph> Elke expressie die uitwisselbaar is met de Voorwaarde type-uitdrukking. Het instructieblok dat volgt op de Case-instructie wordt uitgevoerd als <emph>Voorwaarde</emph> overeenkomt met <emph>Expressie</emph>."
-
-#. CPxCt
-#: 03090102.xhp
-msgctxt ""
-"03090102.xhp\n"
-"hd_id3153768\n"
-"help.text"
-msgid "Example:"
-msgstr "Voorbeeld:"
+msgid "<emph>expression:</emph> Any expression that is compatible with the condition type expression. The statement block that follows the <literal>Case</literal> clause is executed if <emph>condition</emph> matches <emph>expression</emph>."
+msgstr ""
 
 #. oCrpX
 #: 03090102.xhp
@@ -23389,158 +23353,86 @@ msgctxt ""
 msgid "GoSub...Return Statement"
 msgstr "Instructie GoSub...Return"
 
-#. xE9Hb
+#. EhtAB
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "bm_id3147242\n"
 "help.text"
-msgid "<bookmark_value>GoSub...Return statement</bookmark_value>"
-msgstr "<bookmark_value>GoSub...Return-instructie</bookmark_value>"
+msgid "<bookmark_value>GoSub...Return statement</bookmark_value>  <bookmark_value>label; in GoSub...Return statement</bookmark_value>"
+msgstr ""
 
-#. B36CH
+#. gVEdC
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "hd_id3147242\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03090301.xhp\" name=\"GoSub...Return Statement\">GoSub...Return Statement</link>"
-msgstr "<link href=\"text/sbasic/shared/03090301.xhp\" name=\"GoSub...Return Statement\">GoSub...Return-instructie</link>"
+msgid "<variable id=\"GoSubh1\"><link href=\"text/sbasic/shared/03090301.xhp\" name=\"GoSub...Return Statement\">GoSub...Return Statement</link></variable>"
+msgstr ""
 
-#. AFPmM
+#. HSYep
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "par_id3145316\n"
 "help.text"
-msgid "Calls a subroutine that is indicated by a label from a subroutine or a function. The statements following the label are executed until the next Return statement. Afterwards, the program continues with the statement that follows the <emph>GoSub </emph>statement."
-msgstr "Roept een subroutine aan die met een label uit een subroutine of een functie wordt aangegeven. De instructies na de label worden uitgevoerd tot de volgende Return-instructie. Daarna gaat het programma verder met de instructie die op de <emph>GoSub</emph>-instructie volgt."
-
-#. tRYir
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3145609\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxis:"
+msgid "Calls a subroutine that is indicated by a label inside a <literal>Sub</literal> or a <literal>Function</literal>. The statements following the label are executed until the next <literal>Return</literal> statement. Afterwards, the program continues with the statement that follows the <literal>GoSub</literal> statement."
+msgstr ""
 
-#. zqBBG
+#. g6Wgg
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "par_id3145069\n"
 "help.text"
-msgid "see Parameters"
-msgstr "zie 'Parameters'"
-
-#. aPEyy
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3147265\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
-
-#. dVLGt
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3148664\n"
-"help.text"
-msgid "Sub/Function"
-msgstr "Sub/Function"
-
-#. bcX4L
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3150400\n"
-"help.text"
-msgid "statement block"
-msgstr "instructieblok"
-
-#. z8D4B
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3154140\n"
-"help.text"
-msgid "Label"
-msgstr "Label"
-
-#. uxiuj
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3150869\n"
-"help.text"
-msgid "statement block"
-msgstr "instructieblok"
-
-#. Nn3Bw
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3154909\n"
-"help.text"
-msgid "GoSub Label"
-msgstr "GoSub Label"
-
-#. LSt3B
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3153969\n"
-"help.text"
-msgid "Exit Sub/Function"
-msgstr "Exit Sub/Function"
+msgid "GoSub label[:]"
+msgstr ""
 
-#. 62Fsi
+#. krBDs
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3154685\n"
+"par_id471588670859073\n"
 "help.text"
-msgid "Label:"
-msgstr "Label:"
+msgid "<emph>label: </emph>A line identifier indicating where to continue execution. The scope of a label in that of the routine it belongs to."
+msgstr ""
 
-#. cEndJ
+#. sqKLC
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3145786\n"
+"par_id3147318\n"
 "help.text"
-msgid "statement block"
-msgstr "instructieblok"
+msgid "The <literal>GoSub</literal> statement calls a local subroutine indicated by a label from within a subroutine or a function. The name of the label must end with a colon (\":\")."
+msgstr ""
 
-#. Gd3RE
+#. CfgLj
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3159252\n"
+"bas_id411588670455217\n"
 "help.text"
-msgid "Return"
-msgstr "Return"
+msgid "' statements"
+msgstr ""
 
-#. FyBNB
+#. hGEZe
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3154321\n"
+"bas_id421588670457589\n"
 "help.text"
-msgid "End Sub/Function"
-msgstr "End Sub/Function"
+msgid "' statements"
+msgstr ""
 
-#. LnwiR
+#. a8NbA
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3147318\n"
+"bas_id171588670458263\n"
 "help.text"
-msgid "The <emph>GoSub</emph> statement calls a local subroutine indicated by a label from within a subroutine or a function. The name of the label must end with a colon (\":\")."
-msgstr "De instructie <emph>GoSub</emph> roept een lokale subroutine op die wordt aangegeven met een label, vanuit een subroutine of functie. De naam van de label moet met een dubbele punt (:) eindigen."
+msgid "' statements"
+msgstr ""
 
 #. X2mAh
 #: 03090301.xhp
@@ -23560,15 +23452,6 @@ msgctxt ""
 msgid "The following example demonstrates the use of <emph>GoSub</emph> and <emph>Return</emph>. By executing a program section twice, the program calculates the square root of two numbers that are entered by the user."
 msgstr "In het volgende voorbeeld wordt het gebruik van <emph>GoSub</emph> en <emph>Return</emph> uitgelegd. Het programma kan de vierkantswortel berekenen van twee getallen die door de gebruiker worden ingevoerd, door een programmasectie tweemaal uit te voeren."
 
-#. VbwNL
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3156284\n"
-"help.text"
-msgid "Example:"
-msgstr "Voorbeeld:"
-
 #. JXEq5
 #: 03090301.xhp
 msgctxt ""
@@ -23614,32 +23497,32 @@ msgctxt ""
 msgid "GoTo Statement"
 msgstr "Instructie GoTo"
 
-#. CyC3S
+#. MJeVf
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
 "bm_id3159413\n"
 "help.text"
-msgid "<bookmark_value>GoTo statement</bookmark_value>"
-msgstr "<bookmark_value>GoTo-instructie</bookmark_value>"
+msgid "<bookmark_value>GoTo statement</bookmark_value>  <bookmark_value>label; in GoTo statement</bookmark_value>"
+msgstr ""
 
-#. Tb5VW
+#. 6PsQf
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
 "hd_id3159413\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03090302.xhp\" name=\"GoTo Statement\">GoTo Statement</link>"
-msgstr "<link href=\"text/sbasic/shared/03090302.xhp\" name=\"GoTo Statement\">GoTo-instructie</link>"
+msgid "<variable id=\"GoToh1\"><link href=\"text/sbasic/shared/03090302.xhp\" name=\"GoTo Statement\">GoTo Statement</link></variable>"
+msgstr ""
 
-#. fEknP
+#. zmo8E
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
 "par_id3153379\n"
 "help.text"
-msgid "Continues program execution within a Sub or Function at the procedure line indicated by a label."
-msgstr "Zet de programma-uitvoering voort binnen een 'Sub' of 'Function' bij de procedureregel die door een label aangegeven wordt."
+msgid "Continues program execution within a <literal>Sub</literal> or <literal>Function</literal> at the procedure line indicated by a label."
+msgstr ""
 
 #. MFgEA
 #: 03090302.xhp
@@ -23650,15 +23533,6 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Syntaxis:"
 
-#. yjD8B
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3154367\n"
-"help.text"
-msgid "see Parameters"
-msgstr "zie 'Parameters'"
-
 #. ziCip
 #: 03090302.xhp
 msgctxt ""
@@ -23668,104 +23542,68 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parameters:"
 
-#. qGGVZ
+#. KaSma
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3156424\n"
+"par_id471588670859073\n"
 "help.text"
-msgid "statement block"
-msgstr "instructieblok"
-
-#. cM4t6
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3154685\n"
-"help.text"
-msgid "Label1"
-msgstr "Label1"
-
-#. B4ZCj
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3145786\n"
-"help.text"
-msgid "<emph>Label2:</emph>"
-msgstr "<emph>Label2:</emph>"
-
-#. tw7DH
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3161832\n"
-"help.text"
-msgid "statement block"
-msgstr "instructieblok"
-
-#. AF478
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3150010\n"
-"help.text"
-msgid "<emph>Label1:</emph>"
-msgstr "<emph>Label1:</emph>"
+msgid "<emph>label: </emph>A line identifier indicating where to continue execution. The scope of a label in that of the routine it belongs to."
+msgstr ""
 
-#. coe3B
+#. YxYq5
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3152462\n"
+"par_id3152596\n"
 "help.text"
-msgid "statement block"
-msgstr "instructieblok"
+msgid "Use the <literal>GoTo</literal> statement to instruct $[officename] Basic to continue program execution at another place within the procedure. The position must be indicated by a label. To set a label, assign a name, and then and end it with a colon (\":\")."
+msgstr ""
 
-#. p22vt
+#. 8o2aP
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3149664\n"
+"par_id3155416\n"
 "help.text"
-msgid "GoTo Label2"
-msgstr "GoTo Label2"
+msgid "You cannot use the <literal>GoTo</literal> statement to jump out of a <literal>Sub</literal> or <literal>Function</literal>."
+msgstr ""
 
-#. yEZwo
+#. s9tCK
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3152596\n"
+"hd_id3154731\n"
 "help.text"
-msgid "Use the GoTo statement to instruct $[officename] Basic to continue program execution at another place within the procedure. The position must be indicated by a label. To set a label, assign a name, and then and end it with a colon (\":\")."
-msgstr "Via de GoTo-instructie kunt u $[officename] Basic opdragen de programma-uitvoering ergens anders binnen de procedure voort te zetten. Deze plaats moet aangeduid worden met een label. Wijs een naam toe en sluit deze af met een dubbele punt (:) om een label in te stellen."
+msgid "Example:"
+msgstr "Voorbeeld:"
 
-#. 4SnXz
+#. YN5FT
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3155416\n"
+"par_id3156424\n"
 "help.text"
-msgid "You cannot use the GoTo statement to jump out of a Sub or Function."
-msgstr "U kunt de GoTo-instructie niet gebruiken om uit een 'Sub' of 'Function' te springen."
+msgid "' statement block"
+msgstr ""
 
-#. s9tCK
+#. 4DWfG
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"hd_id3154731\n"
+"par_id3161832\n"
 "help.text"
-msgid "Example:"
-msgstr "Voorbeeld:"
+msgid "' statement block"
+msgstr ""
 
-#. WAgYp
+#. FMGBa
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id6967035\n"
+"par_id3152462\n"
 "help.text"
-msgid "see Parameters"
-msgstr "zie 'Parameters'"
+msgid "' statement block"
+msgstr ""
 
 #. GLei6
 #: 03090303.xhp
@@ -23776,23 +23614,23 @@ msgctxt ""
 msgid "On...GoSub Statement; On...GoTo Statement"
 msgstr "Instructie On...GoSub; Instructie On...GoTo"
 
-#. baypv
+#. RSWDG
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "bm_id3153897\n"
 "help.text"
-msgid "<bookmark_value>On...GoSub statement</bookmark_value>  <bookmark_value>On...GoTo statement</bookmark_value>"
-msgstr "<bookmark_value>On...GoSub-instructie</bookmark_value>  <bookmark_value>On...GoTo-instructie</bookmark_value>"
+msgid "<bookmark_value>On...GoSub statement</bookmark_value>  <bookmark_value>On...GoTo statement</bookmark_value>  <bookmark_value>label; in On...GoSub statement</bookmark_value>  <bookmark_value>label; in On...GoTo statement</bookmark_value>"
+msgstr ""
 
-#. xAEB4
+#. 2xMSm
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "hd_id3153897\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03090303.xhp\" name=\"On...GoSub Statement; On...GoTo Statement\">On...GoSub Statement; On...GoTo Statement</link>"
-msgstr "<link href=\"text/sbasic/shared/03090303.xhp\" name=\"On...GoSub Statement; On...GoTo Statement\">On...GoSub-instructie; On...GoTo-instructie</link>"
+msgid "<variable id=\"OnGoSubGoToh1\"><link href=\"text/sbasic/shared/03090303.xhp\" name=\"On...GoSub Statement; On...GoTo Statement\">On...GoSub Statement; On...GoTo Statement</link></variable>"
+msgstr ""
 
 #. 9AaZW
 #: 03090303.xhp
@@ -23803,59 +23641,50 @@ msgctxt ""
 msgid "Branches to one of several specified lines in the program code, depending on the value of a numeric expression."
 msgstr "Vertakt naar één van verschillende gespecificeerde regels in de programmacode, afhankelijk van de waarde van een numerieke expressie."
 
-#. wz57Y
+#. 7yAyG
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
-"hd_id3148798\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Syntaxis:"
+msgid "<image src=\"media/helpimg/sbasic/On-GoSub-GoTo_statement.svg\" id=\"img_id931588605629842\"><alt id=\"alt_id931588605629842\">On GoSub/GoTo syntax</alt></image>"
+msgstr ""
 
-#. Hv9fU
+#. 7DeW7
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "par_id3154366\n"
 "help.text"
-msgid "On N GoSub Label1[, Label2[, Label3[,...]]]"
-msgstr "On N GoSub Label1[, Label2[, Label3[,...]]]"
+msgid "On expression GoSub Label1[, Label2[, Label3[,...]]]"
+msgstr ""
 
-#. iXto8
+#. osLES
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "par_id3150769\n"
 "help.text"
-msgid "On NumExpression GoTo Label1[, Label2[, Label3[,...]]]"
-msgstr "On NumExpressie GoTo Label1[, Label2[, Label3[,...]]]"
-
-#. anrdF
-#: 03090303.xhp
-msgctxt ""
-"03090303.xhp\n"
-"hd_id3156215\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
+msgid "On expression GoTo Label1[, Label2[, Label3[,...]]]"
+msgstr ""
 
-#. jB6gB
+#. eLCEK
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "par_id3148673\n"
 "help.text"
-msgid "<emph>NumExpression:</emph> Any numeric expression between 0 and 255 that determines which of the lines the program branches to. If NumExpression is 0, the statement is not executed. If NumExpression is greater than 0, the program jumps to the label that has a position number that corresponds to the expression (1 = First label; 2 = Second label)"
-msgstr "<emph>NumExpressie:</emph> Elke numerieke expressie tussen 0 en 255 die bepaalt naar welke van de regels het programma vertakt. Als NumExpressie 0 is, zal de expressie niet worden uitgevoerd. Als NumExpressie groter is dan 0, springt het programma naar de respectievelijke label met een positiegetal overeenkomstig de expressie (1 = Eerste label; 2 = Tweede label)"
+msgid "<emph>expression:</emph> Any numeric expression between 0 and 255 that determines which of the lines the program branches to. If <emph>expression</emph> is 0, the statement is not executed. If <emph>expression</emph> is greater  than 0, the program jumps to the label that has a position number that corresponds to the expression (1 = First label; 2 = Second label)"
+msgstr ""
 
-#. CWV9P
+#. K4CfD
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
 "par_id3153194\n"
 "help.text"
-msgid "<emph>Label:</emph> Target line according to<emph> GoTo </emph>or <emph>GoSub</emph> structure."
-msgstr "<emph>Label:</emph> Bestemmingsregel volgens <emph>GoTo-</emph>of <emph>GoSub-</emph>structuur."
+msgid "<emph>label:</emph> Target line according to<emph> GoTo </emph>or <emph>GoSub</emph> structure."
+msgstr ""
 
 #. eqUXk
 #: 03090303.xhp
@@ -23866,15 +23695,6 @@ msgctxt ""
 msgid "The <emph>GoTo</emph> or <emph>GoSub </emph>conventions are valid."
 msgstr "De <emph>GoTo</emph> of <emph>GoSub </emph>regels zijn geldig."
 
-#. 9SqBY
-#: 03090303.xhp
-msgctxt ""
-"03090303.xhp\n"
-"hd_id3148645\n"
-"help.text"
-msgid "Example:"
-msgstr "Voorbeeld:"
-
 #. PtTux
 #: 03090303.xhp
 msgctxt ""
@@ -30697,32 +30517,32 @@ msgctxt ""
 msgid "' Copy of structs as value -> new instance"
 msgstr "' Kopiëren van structs als waarde -> nieuw exemplaar"
 
-#. XZuoy
+#. hQzux
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "tit\n"
 "help.text"
-msgid "Erase Function"
-msgstr "Functie Erase"
+msgid "Erase Statement"
+msgstr ""
 
-#. dKRw9
+#. UwzDN
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "bm_id624713\n"
 "help.text"
-msgid "<bookmark_value>Erase function</bookmark_value>"
-msgstr "<bookmark_value>Erase-functie</bookmark_value>"
+msgid "<bookmark_value>Erase statement</bookmark_value>"
+msgstr ""
 
-#. bSr9M
+#. W6k5N
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "par_idN10548\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03104700.xhp\">Erase Function</link>"
-msgstr "<link href=\"text/sbasic/shared/03104700.xhp\">Erase-functie</link>"
+msgid "<link href=\"text/sbasic/shared/03104700.xhp\">Erase Statement</link>"
+msgstr ""
 
 #. xqtMK
 #: 03104700.xhp
@@ -30733,41 +30553,77 @@ msgctxt ""
 msgid "Erases the contents of array elements of fixed size arrays, and releases the memory used by arrays of variable size."
 msgstr "Wist de inhoud van matrixelementen in matrices met een vaste grootte, en geeft het geheugen vrij dat door matrices met verschillende grootten gebruikt wordt."
 
-#. QGwRF
+#. 3sXFq
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
-"par_idN1055D\n"
+"par_id831588865616326\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Syntaxis:"
+msgid "<image src=\"media/helpimg/sbasic/Erase_statement.svg\" id=\"img_id651588865616326\"><alt id=\"alt_id281588865616326\">Erase syntax</alt></image>"
+msgstr ""
 
-#. h8WrH
+#. CCyg8
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "par_idN105E6\n"
 "help.text"
-msgid "Erase Arraylist"
-msgstr "Erase Arraylijst"
+msgid "Erase array1 [, array2 [,...]]"
+msgstr ""
 
-#. zfSit
+#. 8J4Ab
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
-"par_idN105E9\n"
+"par_idN105ED\n"
 "help.text"
-msgid "Parameters:"
-msgstr "Parameters:"
+msgid "<emph>array list</emph> - A comma delimited list of arrays to be erased."
+msgstr ""
 
-#. r46GH
+#. FiDAp
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
-"par_idN105ED\n"
+"bas_id821588866562452\n"
+"help.text"
+msgid "Erase a, c(Ubound(c)) ' b and c(0) are unchanged"
+msgstr ""
+
+#. tYVCK
+#: 03104700.xhp
+msgctxt ""
+"03104700.xhp\n"
+"bas_id701588866563382\n"
+"help.text"
+msgid "Erase b, c(0) ' everything gets cleared"
+msgstr ""
+
+#. LvkX5
+#: 03104700.xhp
+msgctxt ""
+"03104700.xhp\n"
+"par_id161588865796615\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03102100.xhp\" name=\"Dim statement\">Dim</link> or <link href=\"text/sbasic/shared/03102101.xhp\" name=\"ReDim statement\">ReDim</link> statements"
+msgstr ""
+
+#. h7XZF
+#: 03104700.xhp
+msgctxt ""
+"03104700.xhp\n"
+"par_id281588865818334\n"
 "help.text"
-msgid "<emph>Arraylist</emph> - The list of arrays to be erased."
-msgstr "<emph>Arraylijst</emph> - De lijst met arrays die gewist moeten worden."
+msgid "<link href=\"text/sbasic/shared/03104200.xhp\" name=\"Array function\">Array</link> or <link href=\"text/sbasic/shared/03104300.xhp\" name=\"DimArray function\">DimArray</link> functions"
+msgstr ""
+
+#. FA4C9
+#: 03104700.xhp
+msgctxt ""
+"03104700.xhp\n"
+"par_id761588867124078\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03102900.xhp\" name=\"lower bound function\">Lbound</link> and <link href=\"text/sbasic/shared/03103000.xhp\" name=\"upper bound function\">Ubound</link> functions"
+msgstr ""
 
 #. y97EV
 #: 03110000.xhp
@@ -38806,14 +38662,14 @@ msgctxt ""
 msgid "<emph>numdecimalplaces</emph>: Optional. Specifies how many places to the right of the decimal are included in the rounding. Default is 0."
 msgstr "<emph>Aantal</emph>: Optioneel. Specificeert het aantal decimalen dat in de afronding wordt meegenomen. Standaard is dit 0."
 
-#. TpV6F
+#. g7CVV
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id061420170153186193\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/04060106.xhp#bm_id3158121\">Calc ROUND function</link>"
-msgstr "<link href=\"text/scalc/01/04060106.xhp#bm_id3158121\">Calc-functie AFRONDEN</link>"
+msgid "<link href=\"text/scalc/01/04060106.xhp#Section21\">Calc ROUND function</link>"
+msgstr ""
 
 #. 3ECTM
 #: 03170010.xhp
@@ -40741,13 +40597,13 @@ msgctxt ""
 msgid "When using <link href=\"text/sbasic/shared/vbasupport.xhp\" name=\"Option VBASupport\">Option VBASupport 1</link>, <literal>Optional</literal> arguments with no default value (<emph>= expression</emph>) are initialized according to their data type, except if <literal>Variant</literal>."
 msgstr ""
 
-#. KG4tC
+#. fDUEu
 #: fragments.xhp
 msgctxt ""
 "fragments.xhp\n"
 "hd_id231587046013456\n"
 "help.text"
-msgid "<variable id=\"arrayh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"array syntax fragment\"/></variable>array fragment"
+msgid "<variable id=\"arrayh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"array syntax fragment\">array fragment</link></variable>"
 msgstr ""
 
 #. YD32W
@@ -40795,13 +40651,13 @@ msgctxt ""
 msgid "Multiple dimensions for an array are denoted using comma (<emph>,</emph>) sign."
 msgstr ""
 
-#. bGJWo
+#. DeXti
 #: fragments.xhp
 msgctxt ""
 "fragments.xhp\n"
 "hd_id231587046013458\n"
 "help.text"
-msgid "<variable id=\"typenameh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"data types fragment\"/></variable>typename fragment"
+msgid "<variable id=\"typenameh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"data types fragment\">typename fragment</link></variable>"
 msgstr ""
 
 #. AqfYj
@@ -40813,13 +40669,13 @@ msgctxt ""
 msgid "<image src=\"media/helpimg/sbasic/typename_fragment.svg\" id=\"img_id4157296484514\"><alt id=\"alt_id15152796484515\">primitive data types fragment</alt></image>"
 msgstr ""
 
-#. CiDZr
+#. dM8Yg
 #: fragments.xhp
 msgctxt ""
 "fragments.xhp\n"
 "hd_id231587046013459\n"
 "help.text"
-msgid "<variable id=\"charh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"type declaration characters fragment\"/></variable>char fragment"
+msgid "<variable id=\"charh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"type declaration characters fragment\">char fragment</link></variable>"
 msgstr ""
 
 #. JFwPg
diff --git a/source/nl/helpcontent2/source/text/scalc/01.po b/source/nl/helpcontent2/source/text/scalc/01.po
index 04545169ea0..a1da73b0e3c 100644
--- a/source/nl/helpcontent2/source/text/scalc/01.po
+++ b/source/nl/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-05-05 14:59+0200\n"
+"POT-Creation-Date: 2020-05-27 11:43+0200\n"
 "PO-Revision-Date: 2020-03-06 10:51+0000\n"
 "Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/nl/>\n"
@@ -5830,14 +5830,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Calculates the amount of depreciation for a settlement period as degressive amortization.</ahelp> Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here."
 msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Berekent het afschrijvingsbedrag voor een vereffeningsperiode als degressieve afschrijving.</ahelp> In tegenstelling tot AMORLINC wordt hier een afschrijvingscoëfficiënt gebruikt die niet afhankelijk is van de afschrijvingsperiode."
 
-#. i8TkC
+#. DEtMa
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147427\n"
 "help.text"
-msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
-msgstr "AMORDEGRC(Kosten; Aankoopdatum; Eerste periode; Restwaarde; Periode; Percentage; Basis)"
+msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
+msgstr ""
 
 #. bA2pT
 #: 04060103.xhp
@@ -5920,14 +5920,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Berekent het afschrijvingsbedrag voor een vereffeningsperiode als lineaire afschrijving. Als het kapitaalgoed gekocht wordt tijdens de vereffeningsperiode, wordt het proportionele afschrijvingsbedrag in aanmerking genomen.</ahelp>"
 
-#. 3n4Kb
+#. jD9JZ
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147363\n"
 "help.text"
-msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
-msgstr "AMORLINC(Kosten; Aankoopdatum; Eerste periode; Restwaarde; Periode; Percentage; Basis)"
+msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
+msgstr ""
 
 #. PsFjE
 #: 04060103.xhp
@@ -6019,14 +6019,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Berekent de opgebouwde rente van een waardepapier bij periodieke betalingen.</ahelp>"
 
-#. oHnfa
+#. yGdCf
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3159092\n"
 "help.text"
-msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis)"
-msgstr "SAMENG.RENTE(Uitgiftedatum; Eerste rente; Aankoopdatum; Koers; Nominale waarde; Frequentie; Basis)"
+msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])"
+msgstr ""
 
 #. PKp6i
 #: 04060103.xhp
@@ -6127,14 +6127,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calculates the accrued interest of a security in the case of one-off payment at the settlement date.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Berekent de opgebouwde rente van een waardepapier bij een eenmalige betaling op de aankoopdatum.</ahelp>"
 
-#. uRZWP
+#. zFkiX
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147074\n"
 "help.text"
-msgid "ACCRINTM(Issue; Settlement; Rate; Par; Basis)"
-msgstr "SAMENG.RENTE.V(Uitgiftedatum; Afrekeningsdatum; Nominale rente;Nominale waarde; Frequentie;Basis)"
+msgid "ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])"
+msgstr ""
 
 #. pTobQ
 #: 04060103.xhp
@@ -6334,14 +6334,14 @@ msgctxt ""
 msgid "Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under <emph>Rate</emph> and <item type=\"productname\">%PRODUCTNAME</item> Calc with automatically calculate the correct factor."
 msgstr "Voer deze waarden in als getallen, als uitdrukkingen of als verwijzingen. Als er bijvoorbeeld een jaarlijkse rente wordt betaald van 8%, maar u wilt een periode van een maand gebruiken, voer dan 8%/12 in bij <emph>Rente</emph> en <item type=\"productname\">%PRODUCTNAME</item> Calc zal automatisch de correcte factor berekenen."
 
-#. BVQTK
+#. uiDaD
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3150395\n"
 "help.text"
-msgid "PV(Rate; NPer; Pmt; FV; Type)"
-msgstr "HW(Rente; NPER; Betaling; TW; Type)"
+msgid "PV(Rate; NPer; Pmt[; FV][; Type])"
+msgstr ""
 
 #. JrCA6
 #: 04060103.xhp
@@ -7360,14 +7360,14 @@ msgctxt ""
 msgid "Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type."
 msgstr "Gebruik deze manier van afwaarderen als u een hogere initiële afwaarderingswaarde nodig hebt in tegenstelling tot lineaire afwaardering. De afwaarderingswaarde wordt met elke termijn kleiner. Deze methode wordt doorgaans gebruikt voor goederen waarvan het waardeverlies hoger is kort na de aankoop (bijv. voertuigen, computers). Merk op dat de boekwaarde nooit nul zal bereiken met deze berekeningsmethode."
 
-#. GnhjW
+#. EV3DT
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3166452\n"
 "help.text"
-msgid "DDB(Cost; Salvage; Life; Period; Factor)"
-msgstr "DDB(Aanschafwaarde; Restwaarde; Levensduur; Periode; Factor)"
+msgid "DDB(Cost; Salvage; Life; Period[; Factor])"
+msgstr ""
 
 #. VKnDB
 #: 04060103.xhp
@@ -7468,14 +7468,14 @@ msgctxt ""
 msgid "This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost."
 msgstr "Deze vorm van afwaardering kunt u gebruiken als u een hogere afwaarderingswaarde wilt aan het begin van de afschrijving (in tegenstelling tot lineaire afwaardering). De afwaarderingswaarde wordt iedere afwaarderingsperiode verkleind door de afschrijving af te trekken van de initiële kosten."
 
-#. zaXLw
+#. EDXF8
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3153349\n"
 "help.text"
-msgid "DB(Cost; Salvage; Life; Period; Month)"
-msgstr "DB(Aanschafwaarde; Restwaarde; Levensduur; Periode; Maand)"
+msgid "DB(Cost; Salvage; Life; Period[; Month])"
+msgstr ""
 
 #. caSta
 #: 04060103.xhp
@@ -7585,14 +7585,14 @@ msgctxt ""
 msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link> function."
 msgstr "Gebruik de functie <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">IR.SCHEMA</link>, als de betalingen op onregelmatige basis plaatsvinden."
 
-#. CCfhc
+#. zWTAW
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3155427\n"
 "help.text"
-msgid "IRR(Values; Guess)"
-msgstr "IR(Waarden; Schatting)"
+msgid "IRR(Values[; Guess])"
+msgstr ""
 
 #. o9R77
 #: 04060103.xhp
@@ -9448,14 +9448,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_ZELLE\">Returns information on address, formatting or contents of a cell.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_ZELLE\">Geeft informatie over adres, opmaak of inhoud van een cel.</ahelp>"
 
-#. P9UHc
+#. RWBPC
 #: 04060104.xhp
 msgctxt ""
 "04060104.xhp\n"
 "par_id3147355\n"
 "help.text"
-msgid "CELL(\"InfoType\"; Reference)"
-msgstr "CEL(\"Infotype\"; Verwijzing)"
+msgid "CELL(\"InfoType\"[; Reference])"
+msgstr ""
 
 #. wjBKt
 #: 04060104.xhp
@@ -10195,14 +10195,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_WENN\">Specifies a logical test to be performed.</ahelp>"
 msgstr "<ahelp hid=\"HID_FUNC_WENN\">Geeft een logische test op.</ahelp>"
 
-#. QQdtE
+#. qT9mo
 #: 04060105.xhp
 msgctxt ""
 "04060105.xhp\n"
 "par_id3154558\n"
 "help.text"
-msgid "IF(Test; ThenValue; OtherwiseValue)"
-msgstr "ALS(Test; Dan waarde; Anders waarde)"
+msgid "IF(Test[; ThenValue][; OtherwiseValue])"
+msgstr ""
 
 #. JnjcT
 #: 04060105.xhp
@@ -63061,14 +63061,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_WOCHENTAG\">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below."
 msgstr "<ahelp hid=\"HID_FUNC_WOCHENTAG\">Geeft de dag van de week terug voor de opgegeven datumwaarde.</ahelp> De dag wordt teruggegeven als een geheel getal tussen 1 (zondag) en 7 (zaterdag) als er geen type of type=1 is gespecificeerd. Andere types staan in de tabel hieronder."
 
-#. Q6BXr
+#. EDmeN
 #: func_weekday.xhp
 msgctxt ""
 "func_weekday.xhp\n"
 "par_id3149033\n"
 "help.text"
-msgid "WEEKDAY(Number; Type)"
-msgstr "WEEKDAG(Getal; Methode)"
+msgid "WEEKDAY(Number[; Type])"
+msgstr ""
 
 #. mcF52
 #: func_weekday.xhp
@@ -63808,14 +63808,14 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp>"
 msgstr ""
 
-#. RRr3i
+#. ZFLiY
 #: func_workday.intl.xhp
 msgctxt ""
 "func_workday.intl.xhp\n"
 "par_id241020160008306838\n"
 "help.text"
-msgid "WORKDAY.INTL(StartDate; Days; Weekend; Holidays)"
-msgstr "WERKDAG.INTL(Begindatum; Dagen; Weekend; Vakantiedagen)"
+msgid "WORKDAY.INTL(StartDate; Days[; Weekend][; Holidays])"
+msgstr ""
 
 #. gJg5G
 #: func_workday.intl.xhp
@@ -63979,14 +63979,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> Het resultaat is een datumgetal dat kan worden opgemaakt als een datum. U kunt dan de datum van een dag zien die nog een bepaald aantal <emph>werkdagen</emph> verwijderd is van de <emph>startdatum</emph>.</ahelp>"
 
-#. gSoD4
+#. fo6sg
 #: func_workday.xhp
 msgctxt ""
 "func_workday.xhp\n"
 "par_id3154844\n"
 "help.text"
-msgid "WORKDAY(StartDate; Days; Holidays)"
-msgstr "WERKDAG(Startdatum; Dagen; Feestdagen)"
+msgid "WORKDAY(StartDate; Days[; Holidays])"
+msgstr ""
 
 #. 35EG5
 #: func_workday.xhp
@@ -64168,14 +64168,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>"
 msgstr "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">Het resultaat is het aantal jaren (inclusief een restdeel) tussen <emph>StartDatum</emph> en <emph>EindDatum</emph>.</ahelp>"
 
-#. C3aRF
+#. AASCJ
 #: func_yearfrac.xhp
 msgctxt ""
 "func_yearfrac.xhp\n"
 "par_id3155823\n"
 "help.text"
-msgid "YEARFRAC(StartDate; EndDate; Basis)"
-msgstr "JAAR.DEEL(Startdatum; Einddatum; Basis)"
+msgid "YEARFRAC(StartDate; EndDate[; Basis])"
+msgstr ""
 
 #. JAA8u
 #: func_yearfrac.xhp
@@ -64339,14 +64339,14 @@ msgctxt ""
 msgid "Solver"
 msgstr "Oplosser"
 
-#. i2Coz
+#. pDGKS
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "bm_id7654652\n"
 "help.text"
-msgid "<bookmark_value>goal seeking;solver</bookmark_value>  <bookmark_value>what if operations;solver</bookmark_value>  <bookmark_value>back-solving</bookmark_value>  <bookmark_value>solver</bookmark_value>"
-msgstr "<bookmark_value>doel zoeken;oplosser</bookmark_value> <bookmark_value>wat-als bewerkingen;oplosser</bookmark_value> <bookmark_value>terugrekenen oplosser</bookmark_value> <bookmark_value>oplosser</bookmark_value>"
+msgid "<bookmark_value>goal seeking;solver</bookmark_value>  <bookmark_value>what if operations;solver</bookmark_value>  <bookmark_value>back-solving</bookmark_value>  <bookmark_value>solver</bookmark_value>  <bookmark_value>mathematical programming;solver for Calc</bookmark_value>  <bookmark_value>mathematical optimization;solver for Calc</bookmark_value>  <bookmark_value>operations research;solver for Calc</bookmark_value>"
+msgstr ""
 
 #. cBvDd
 #: solver.xhp
@@ -64357,131 +64357,230 @@ msgctxt ""
 msgid "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Solver</link></variable>"
 msgstr "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Oplosser</link></variable>"
 
-#. VvLwc
+#. JGk9s
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id9210486\n"
 "help.text"
-msgid "<ahelp hid=\".\">Opens the Solver dialog. A solver allows you to solve equations with multiple unknown variables by goal-seeking methods.</ahelp>"
-msgstr "<ahelp hid=\".\">Opent het dialoogvenster Oplosser. Een oplosser is in staat vergelijkingen met meerdere onbekende variabelen op te lossen door middel van doel zoeken-methoden.</ahelp>"
+msgid "<ahelp hid=\".\">Opens the Solver dialog. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.</ahelp>"
+msgstr ""
+
+#. wszcE
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id21589912365601\n"
+"help.text"
+msgid "Solver settings"
+msgstr ""
+
+#. 36mEY
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id501589912905479\n"
+"help.text"
+msgid "The dialog settings are retained until you close the current document."
+msgstr ""
 
-#. ivjGw
+#. GgVk7
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id121589913023217\n"
+"help.text"
+msgid "Target Cell"
+msgstr ""
+
+#. EsgHG
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id8538773\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Klik op de celverwijzing van de doelcel of voer die in. Dit veld neemt het adres van de cel waarvan de waarde moet worden geoptimaliseerd.</ahelp>"
+msgid "<ahelp hid=\".\">Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized.</ahelp>"
+msgstr ""
+
+#. 9j2m7
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id441589913036601\n"
+"help.text"
+msgid "Optimize results to"
+msgstr ""
 
-#. pcopF
+#. U8Ttv
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id7564012\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation for a maximum value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Probeer de vergelijking op te lossen met een maximumwaarde van de doelcel.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Maximum:</emph> Try to solve the equation for a maximum value of the target cell.</ahelp>"
+msgstr ""
 
-#. MBtDo
+#. N5C2U
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id1186254\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation for a minimum value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Probeer de vergelijking op te lossen met een minimumwaarde van de doelcel.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Minimum:</emph> Try to solve the equation for a minimum value of the target cell.</ahelp>"
+msgstr ""
 
-#. 7KTjo
+#. JAo82
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id7432477\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation to approach a given value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Probeer de vergelijking op te lossen door een benadering van een opgegeven waarde van de doelcel.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Value of:</emph> Try to solve the equation to approach a given value of the target cell.</ahelp>"
+msgstr ""
 
-#. xAB7a
+#. 5BC94
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id7141026\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter the value or a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Voer de waarde of een celverwijzing in.</ahelp>"
+msgid "<ahelp hid=\".\">Enter the value or a cell reference in the text field.</ahelp>"
+msgstr ""
 
-#. AkKFT
+#. KMA6B
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id761589914010085\n"
+"help.text"
+msgid "By Changing Cells"
+msgstr ""
+
+#. VvrzV
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id8531449\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter the cell range that can be changed.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Voer het celbereik in dat kan worden gewijzigd.</ahelp>"
+msgid "<ahelp hid=\".\">Enter the cell range that can be changed.</ahelp> These are the variables of the equations."
+msgstr ""
+
+#. if7S9
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id671589914927836\n"
+"help.text"
+msgid "Limiting Conditions"
+msgstr ""
+
+#. QQCWC
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id421589915278885\n"
+"help.text"
+msgid "Add the set of constraints for the mathematical problem. Each constraint is represented by a cell reference (a variable), an operator, and a value."
+msgstr ""
 
-#. o7jUm
+#. YApta
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id9183935\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Voer een celverwijzing in.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Cell reference:</emph> Enter a cell reference of the variable.</ahelp>"
+msgstr ""
+
+#. eyxy9
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id1939451\n"
+"help.text"
+msgid "<ahelp hid=\".\">Click the Shrink button to shrink or restore the dialog. You can click or select cells in the sheet. You can enter a cell reference manually in the input box.</ahelp>"
+msgstr ""
 
-#. 7s5ZD
+#. CWWbZ
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id946684\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Select an operator from the list.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Selecteer een operator uit de lijst.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Operator:</emph> Select an operator from the list.</ahelp> Use Binary operator to restrict your variable to 0 or 1. Use the Integer operator to restrict your variable to take only integer values (no decimal part)."
+msgstr ""
 
-#. Gj2Eo
+#. CtpNG
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id9607226\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter a value or a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Voer een waarde of een celverwijzing in.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Value:</emph> Enter a value or a cell reference.</ahelp> This field is ignored when the operator is Binary or Integer."
+msgstr ""
 
-#. 2iEku
+#. GzohM
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
-"par_id1939451\n"
+"par_id9038972\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Click to shrink or restore the dialog. You can click or select cells in the sheet. You can enter a cell reference manually in the input box.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Klik om het dialoogvenster te vergroten of te verkleinen. U kunt de cellen in het werkblad selecteren of er op klikken. U kunt handmatig een celverwijzing in het invoervak intypen.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Remove button:</emph> Click to remove the row from the list. Any rows from below this row move up.</ahelp>"
+msgstr ""
 
-#. FvWnk
+#. H3FEH
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
-"par_id9038972\n"
+"par_id511589916338595\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Click to remove the row from the list. Any rows from below this row move up.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Klik er op om de rij uit de lijst te verwijderen. Alle rijen vanaf deze rij worden naar boven verplaatst.</ahelp>"
+msgid "You can set multiple conditions for a variable. For example, a variable in cell A1 that must be an integer less than 10. In that case, set two limiting conditions for A1."
+msgstr ""
 
-#. GqxKL
+#. B4DtG
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id441589917031236\n"
+"help.text"
+msgid "Options"
+msgstr ""
+
+#. AheHK
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id2423780\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens the Options dialog.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Opent het dialoogvenster Opties.</ahelp>"
+msgid "<ahelp hid=\".\">Opens the <link href=\"text/scalc/01/solver_options.xhp#solveroptionsh1\" name=\"solveroptions\">Solver Options</link> dialog.</ahelp>"
+msgstr ""
+
+#. jDGPG
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id221589917833431\n"
+"help.text"
+msgid "The <emph>Solver Options</emph> dialog let you select the different solver algorithms for either linear and non-linear problems and set their solving parameters."
+msgstr ""
 
-#. ssqdF
+#. 8YGDA
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id771589917064147\n"
+"help.text"
+msgid "Solve"
+msgstr ""
+
+#. jFwTt
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id2569658\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Click to solve the equation with the current settings. The dialog settings are retained until you close the current document.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Klik hier om de vergelijking op te lossen met de huidige instellingen. De dialoogvensterinstellingen worden behouden tot u het huidige document sluit.</ahelp>"
+msgid "<ahelp hid=\".\">Click to solve the problem with the current settings. The dialog settings are retained until you close the current document.</ahelp>"
+msgstr ""
 
 #. VFnjv
 #: solver.xhp
@@ -64519,122 +64618,770 @@ msgctxt ""
 msgid "You can define a series of limiting conditions that set constraints for some cells. For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or not bigger than a given value. You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed)."
 msgstr "U kunt een reeks beperkende voorwaarden definiëren die beperkingen instellen voor bepaalde cellen. U kunt bijvoorbeeld de beperking instellen dat één van de variabelen of cellen niet groter mag zijn dan een andere variabele of niet groter dan een opgegeven waarde. U kunt ook de beperking diefiniëren dat één of meer variabelen gehele getallen (waarden zonder cijfers achter de komma) of binaire waarden (waar alleen 0 en 1 zijn toegestaan) moeten zijn."
 
-#. bZZnv
+#. irGoh
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
-"par_id5323953\n"
+"hd_id0603200910430882\n"
 "help.text"
-msgid "The default solver engine supports only linear equations."
-msgstr "De standaard oplosserfunctie ondersteunt alleen lineaire vergelijkingen."
+msgid "Using Non-Linear solvers"
+msgstr ""
 
-#. dAcyJ
+#. UTzzV
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430845\n"
+"help.text"
+msgid "Regardless whether you use DEPS or SCO, you start by going to <menuitem>Tools - Solver</menuitem> and set the Cell to be optimized, the direction to go (minimization, maximization) and the cells to be modified to reach the goal. Then you go to the Options and specify the solver to be used and if necessary adjust the according <link href=\"text/scalc/01/solver_options.xhp\">parameters</link>."
+msgstr ""
+
+#. gJGz2
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430821\n"
+"help.text"
+msgid "There is also a list of constraints you can use to restrict the possible range of solutions or to penalize certain conditions. However, in case of the evolutionary solvers DEPS and SCO, these constraints are also used to specify bounds on the variables of the problem. Due to the random nature of the algorithms, it is <emph>highly recommended</emph> to do so and give upper (and in case \"Assume Non-Negative Variables\" is turned off also lower) bounds for all variables. They don't have to be near the actual solution (which is probably unknown) but should give a rough indication of the expected size (0 ≤ var ≤ 1 or maybe -1000000 ≤ var ≤ 1000000)."
+msgstr ""
+
+#. GFZqJ
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430873\n"
+"help.text"
+msgid "Bounds are specified by selecting one or more variables (as range) on the left side and entering a numerical value (not a cell or a formula) on the right side. That way you can also choose one or more variables to be <emph>Integer</emph> or <emph>Binary</emph> only."
+msgstr ""
+
+#. ZUeCC
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id271589981559367\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/\" name=\"wikipage\">Wiki page on solvers and theirs algorithms</link>"
+msgstr ""
+
+#. akxrP
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
 "tit\n"
 "help.text"
-msgid "Options"
-msgstr "Opties"
+msgid "Solver Options"
+msgstr ""
+
+#. UBnZK
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"bm_id291590166034871\n"
+"help.text"
+msgid "<bookmark_value>solver for Calc;options</bookmark_value>"
+msgstr ""
 
-#. 2p755
+#. vZkr3
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
 "hd_id2794274\n"
 "help.text"
-msgid "Options"
-msgstr "Opties"
+msgid "<variable id=\"solveroptionsh1\"><link href=\"text/scalc/01/solver_options.xhp\" name=\"Solver  Options\">Solver Options</link></variable>"
+msgstr ""
 
-#. 4v4nE
+#. LHgS8
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id6776940\n"
+"par_id3163853\n"
 "help.text"
-msgid "The Options dialog for the <link href=\"text/scalc/01/solver.xhp\">Solver</link> is used to set some options."
-msgstr "Het dialoogvenster Opties voor de <link href=\"text/scalc/01/solver.xhp\">Oplosser</link> wordt gebruikt om sommige opties in te stellen."
+msgid "Use the Options dialog to configure the solver engine."
+msgstr ""
+
+#. mFtPo
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"par_id9999694\n"
+"help.text"
+msgid "Click OK to accept the changes and to go back to the <link href=\"text/scalc/01/solver.xhp\">Solver</link> dialog."
+msgstr "Klik op OK om de wijzigingen te accepteren en terug te gaan naar het dialoogvenster <link href=\"text/scalc/01/solver.xhp\">Oplosser</link>."
 
-#. 8D7tG
+#. gE7WZ
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"hd_id581589922716672\n"
+"help.text"
+msgid "Solver engine"
+msgstr ""
+
+#. A7MrG
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
 "par_id393993\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Select a solver engine. The listbox is disabled if only one solver engine is installed. Solver engines can be installed as extensions.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Selecteer een oplosserfunctie. De keuzelijst is uitgeschakeld indien slechts één oplosserfunctie is geïnstalleerd. Oplosserfuncties kunnen als extensies worden geïnstalleerd.</ahelp>"
+msgid "<ahelp hid=\".\">Select a solver engine. The listbox is disabled if only one solver engine is installed.</ahelp>"
+msgstr ""
 
-#. JuBPY
+#. NMHJR
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id5871761\n"
+"par_id221589959855748\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Configure the current solver.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Configureer de huidige oplosserfunctie.</ahelp>"
+msgid "You can install more solver engines as extensions, if available. Open <menuitem>Tools - Extension Manager</menuitem> and browse to the Extensions web site to search for extensions."
+msgstr ""
 
-#. 9ATtL
+#. QtDyE
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id6531266\n"
+"hd_id711589922750833\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">U kunt op de knop Bewerken klikken als het huidige item in de keuzelijst Instellingen kan worden bewerkt. Een dialoogvenster opent waarin u de waarde kunt veranderen.</ahelp>"
+msgid "Settings"
+msgstr ""
 
-#. yRRMt
+#. ncgjf
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id3912778\n"
+"par_id130619\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter or change the value.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Voer de waarde in of wijzig die.</ahelp>"
+msgid "Configure the current solver. In the Settings box, check all settings that you want to use for the current goal seeking operation. If the current option offers different values, the Edit button is enabled. Click <emph>Edit</emph> to open a dialog where you can change the value."
+msgstr ""
 
-#. FdSQu
+#. DPYew
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id3163853\n"
+"hd_id481589922813764\n"
 "help.text"
-msgid "Use the Options dialog to configure the current solver engine."
-msgstr "Gebruik het dialoogvenster Opties om de huidige oplosserfunctie te configureren."
+msgid "Edit"
+msgstr ""
 
-#. edT9Q
+#. XZbDB
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id121158\n"
+"par_id6531266\n"
 "help.text"
-msgid "You can install more solver engines as extensions, if available. Open Tools - Extension Manager and browse to the Extensions web site to search for extensions."
-msgstr "U kunt meerdere oplosserfuncties, indien beschikbaar, als extensies installeren. Open Extra - Extensiebeheer en blader naar de website Extensies om naar extensies te zoeken."
+msgid "<ahelp hid=\".\">If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.</ahelp>"
+msgstr ""
 
-#. YGbpY
+#. JzS8w
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id3806878\n"
+"hd_id331589923158248\n"
 "help.text"
-msgid "Select the solver engine to use and to configure from the listbox. The listbox is disabled if only one solver engine is installed."
-msgstr "Selecteer de oplosserfunctie, in de keuzelijst, die moet worden gebruikt en geconfigureerd. De keuzelijst is uitgeschakeld indien slechts één oplosserfunctie is geïnstalleerd."
+msgid "Edit settings spin box"
+msgstr ""
 
-#. kk9QD
+#. B4WMx
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id130619\n"
+"par_id3912778\n"
 "help.text"
-msgid "In the Settings box, check all settings that you want to use for the current goal seeking operation. If the current option offers different values, the Edit button is enabled. Click Edit to open a dialog where you can change the value."
-msgstr "In het vak Instellingen selecteert u alle instellingen die u wilt gebruiken voor de huidige actie Doel zoeken. Als de huidige optie verschillende waarden aanbiedt is de knop Bewerken uitgeschakeld. Klik op Bewerken om een dialoogvenster te openen waar u de waarde kunt veranderen."
+msgid "<ahelp hid=\".\">Enter or change the value of the selected setting.</ahelp>"
+msgstr ""
 
-#. mFtPo
+#. cYCVf
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id9999694\n"
+"par_id271589981559367\n"
 "help.text"
-msgid "Click OK to accept the changes and to go back to the <link href=\"text/scalc/01/solver.xhp\">Solver</link> dialog."
-msgstr "Klik op OK om de wijzigingen te accepteren en terug te gaan naar het dialoogvenster <link href=\"text/scalc/01/solver.xhp\">Oplosser</link>."
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgstr ""
+
+#. A843R
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"tit\n"
+"help.text"
+msgid "Options"
+msgstr ""
+
+#. U9kTW
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"bm_id0503200917110375_scalc\n"
+"help.text"
+msgid "<bookmark_value>Solver for Nonlinear Problems;Options</bookmark_value>    <bookmark_value>solver for Calc; DEPS evolutionary algorithm</bookmark_value>    <bookmark_value>solver for Calc; SCO evolutionary algorithm</bookmark_value>    <bookmark_value>solver for Calc; linear solver</bookmark_value>    <bookmark_value>solver for Calc; CoinMP linear solver</bookmark_value>    <bookmark_value>solver for Calc; swarm non-linear solver</bookmark_value>"
+msgstr ""
+
+#. atkqE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"hd_id0503200917103593\n"
+"help.text"
+msgid "<variable id=\"SolverAlgorithmsOptionsh1\"><link href=\"text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1\" name=\"Solver Algorithms Options\">Solver Algorithms Options</link></variable>"
+msgstr ""
+
+#. RjM8p
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id651589925044267\n"
+"help.text"
+msgid "<variable id=\"DEPSEvolutionaryalgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2\" name=\"DEPS Evolutionary algorithm\">DEPS Evolutionary Algorithm</link></variable>"
+msgstr ""
+
+#. xBZfN
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id931590164412542\n"
+"help.text"
+msgid "DEPS consists of two independent algorithms: Differential Evolution and Particle Swarm Optimization. Both are especially suited for numerical problems, such as nonlinear optimization, and are complementary to each other in that they even out their others shortcomings."
+msgstr ""
+
+#. EFbzc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394232\n"
+"help.text"
+msgid "Agent Switch Rate"
+msgstr ""
+
+#. E3ZoK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394248\n"
+"help.text"
+msgid "Specifies the probability for an individual to choose the Differential Evolution strategy."
+msgstr ""
+
+#. DbnUB
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394277\n"
+"help.text"
+msgid "DE: Crossover Probability"
+msgstr ""
+
+#. phaC2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394280\n"
+"help.text"
+msgid "Defines the probability of the individual being combined with the globally best point. If crossover is not used, the point is assembled from the own memory of the individual."
+msgstr ""
+
+#. G4GC9
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0643200910394216\n"
+"help.text"
+msgid "DE: Scaling Factor"
+msgstr ""
+
+#. qKt78
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id360320091039424\n"
+"help.text"
+msgid "During crossover, the scaling factor decides about the “speed” of movement."
+msgstr ""
+
+#. HPPHg
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0507200917103771\n"
+"help.text"
+msgid "Learning Cycles"
+msgstr ""
+
+#. ED86j
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503210917103720\n"
+"help.text"
+msgid "Defines the number of iterations, the algorithm should take. In each iteration, all individuals make a guess on the best solution and share their knowledge."
+msgstr ""
+
+#. M5Ka8
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id3603200910394222\n"
+"help.text"
+msgid "PS: Cognitive Constant"
+msgstr ""
+
+#. bVENc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id3603200915394212\n"
+"help.text"
+msgid "Sets the importance of the own memory (in particular the best reached point so far)."
+msgstr ""
+
+#. ujBHP
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060324091037421\n"
+"help.text"
+msgid "PS: Constriction Coefficient"
+msgstr ""
+
+#. Z86BZ
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0608200910394225\n"
+"help.text"
+msgid "Defines the speed at which the particles/individuals move towards each other."
+msgstr ""
+
+#. nFnAu
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060320091039425\n"
+"help.text"
+msgid "PS: Mutation Probability"
+msgstr ""
+
+#. fGiKi
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394272\n"
+"help.text"
+msgid "Defines the probability, that instead of moving a component of the particle towards the best point, it randomly chooses a new value from the valid range for that variable."
+msgstr ""
+
+#. nn4Ms
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394292\n"
+"help.text"
+msgid "PS: Social Constant"
+msgstr ""
+
+#. nAD2Z
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394284\n"
+"help.text"
+msgid "Sets the importance of the global best point between all particles/individuals."
+msgstr ""
+
+#. GAGDE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200217103891\n"
+"help.text"
+msgid "<variable id=\"enhstatusheader\">Show Enhanced Solver Status</variable>"
+msgstr ""
+
+#. na8Ee
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0523200917103832\n"
+"help.text"
+msgid "<variable id=\"enhstatusdesc\">If <emph>enabled</emph>, an additional dialog is shown during the solving process which gives information about the current progress, the level of stagnation, the currently best known solution as well as the possibility, to stop or resume the solver.</variable>"
+msgstr ""
+
+#. 3LaZ7
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200417103780\n"
+"help.text"
+msgid "<variable id=\"swarmheader\">Size of Swarm</variable>"
+msgstr ""
+
+#. UhBid
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503100917103723\n"
+"help.text"
+msgid "<variable id=\"swarmdesc\">Defines the number of individuals to participate in the learning process. Each individual finds its own solutions and contributes to the overall knowledge.</variable>"
+msgstr ""
+
+#. r62GH
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0504200917103794\n"
+"help.text"
+msgid "<variable id=\"stagnationheader\">Stagnation Limit</variable>"
+msgstr ""
+
+#. LDNEL
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id050320091710377\n"
+"help.text"
+msgid "<variable id=\"stagnationdesc\">If this number of individuals found solutions within a close range, the iteration is stopped and the best of these values is chosen as optimal.</variable>"
+msgstr ""
+
+#. vGYwe
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103762\n"
+"help.text"
+msgid "<variable id=\"stagtolheader\">Stagnation Tolerance</variable>"
+msgstr ""
+
+#. wqeXY
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103834\n"
+"help.text"
+msgid "<variable id=\"stagtoldesc\">Defines in what range solutions are considered “similar”.</variable>"
+msgstr ""
+
+#. jKuiG
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103740\n"
+"help.text"
+msgid "<variable id=\"acrheader\">Use ACR Comparator</variable>"
+msgstr ""
+
+#. D8e8D
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103766\n"
+"help.text"
+msgid "If <emph>disabled</emph> (default), the BCH Comparator is used. It compares two individuals by first looking at their constraint violations and only if those are equal, it measures their current solution."
+msgstr ""
+
+#. 7LWoa
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103744\n"
+"help.text"
+msgid "If <emph>enabled</emph>, the ACR Comparator is used. It compares two individuals dependent on the current iteration and measures their goodness with knowledge about the libraries worst known solutions (in regard to their constraint violations)."
+msgstr ""
+
+#. GZ7C2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103792\n"
+"help.text"
+msgid "Use Random Starting Point"
+msgstr ""
+
+#. EdJoF
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103790\n"
+"help.text"
+msgid "If <emph>enabled</emph>, the library is simply filled up with randomly chosen points."
+msgstr ""
+
+#. oCPc4
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103765\n"
+"help.text"
+msgid "If <emph>disabled</emph>, the currently present values (as given by the user) are inserted in the library as reference point."
+msgstr ""
+
+#. ctLqK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103732\n"
+"help.text"
+msgid "<variable id=\"variableguessheader\">Variable Bounds Guessing</variable>"
+msgstr ""
+
+#. rc95a
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id050320091710378\n"
+"help.text"
+msgid "<variable id=\"variableguessdesc\">If enabled (default), the algorithm tries to find variable bounds by looking at the starting values.</variable>"
+msgstr ""
+
+#. JctSA
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103794\n"
+"help.text"
+msgid "<variable id=\"variablethresheader\">Variable Bounds Threshold</variable>"
+msgstr ""
+
+#. NNyfL
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103710\n"
+"help.text"
+msgid "<variable id=\"variablethresdesc\">When guessing variable bounds, this threshold specifies, how the initial values are shifted to build the bounds. For an example how these values are calculated, please refer to the Manual in the Wiki.</variable>"
+msgstr ""
+
+#. UDXDh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id391589925078747\n"
+"help.text"
+msgid "<variable id=\"SCOEvolutionaryAlgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2\" name=\"SCO Evolutionary Algorithm\">SCO Evolutionary Algorithm</link></variable>"
+msgstr ""
+
+#. tqkJh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id681590165847694\n"
+"help.text"
+msgid "Social Cognitive Optimization takes into account the human behavior of learning and sharing information. Each individual has access to a common library with knowledge shared between all individuals."
+msgstr ""
+
+#. wovoy
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103771\n"
+"help.text"
+msgid "Learning Cycles"
+msgstr ""
+
+#. wgKE5
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103720\n"
+"help.text"
+msgid "Defines the number of iterations, the algorithm should take. In each iteration, all individuals make a guess on the best solution and share their knowledge."
+msgstr ""
+
+#. wrasx
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910401382\n"
+"help.text"
+msgid "Size of Library"
+msgstr ""
+
+#. 4PmLg
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060320091040136\n"
+"help.text"
+msgid "Defines the amount of information to store in the public library. Each individual stores knowledge there and asks for information."
+msgstr ""
+
+#. EPiZn
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id741589980722689\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/solver_options_algo.xhp#variablethresheader\"/>"
+msgstr ""
+
+#. Ltucz
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id901589980722691\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/solver_options_algo.xhp#variablethresdesc\"/>"
+msgstr ""
+
+#. 46h4u
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id671589925148891\n"
+"help.text"
+msgid "<variable id=\"LinearSolverh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#LinearSolverh2\" name=\"%PRODUCTNAME Linear Solver\">%PRODUCTNAME Linear Solver and CoinMP Linear solver</link></variable>"
+msgstr ""
+
+#. PNEaC
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id731589925837981\n"
+"help.text"
+msgid "<variable id=\"settingshead\">Setting</variable>"
+msgstr ""
+
+#. DhVRA
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id611589925837982\n"
+"help.text"
+msgid "<variable id=\"descriptionhead\">Description</variable>"
+msgstr ""
+
+#. MqHfE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id511589925837984\n"
+"help.text"
+msgid "<variable id=\"integerhead\">Assume variables as integers</variable>"
+msgstr ""
+
+#. Javmc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id11589925837985\n"
+"help.text"
+msgid "<variable id=\"integerdesc\">Mark to force variables to be integers only.</variable>"
+msgstr ""
+
+#. yie3u
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id221589961756407\n"
+"help.text"
+msgid "<variable id=\"noneghead\">Assume variables as non negative</variable>"
+msgstr ""
+
+#. ij2he
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id861589961756408\n"
+"help.text"
+msgid "<variable id=\"nonegdesc\">Mark to force variables to be positive only.</variable>"
+msgstr ""
+
+#. uEDEh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id971589961907787\n"
+"help.text"
+msgid "Epsilon level"
+msgstr ""
+
+#. JSVtE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id421589961907788\n"
+"help.text"
+msgid "Epsilon level. Valid values are in range 0 (very tight) to 3 (very loose). Epsilon is the tolerance for rounding values to zero."
+msgstr ""
+
+#. rtCLo
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id71589961998523\n"
+"help.text"
+msgid "Limit branch-and-bound depth"
+msgstr ""
+
+#. yeTw2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id331589961998525\n"
+"help.text"
+msgid "Specifies the maximum branch-and-bound depth. A positive value means that the depth is absolute. A negative value means a relative branch-and-bound depth limit."
+msgstr ""
+
+#. pnUYs
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id91589962070327\n"
+"help.text"
+msgid "<variable id=\"timelimithead\">Solver time limit</variable>"
+msgstr ""
+
+#. PPtR8
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id331589962070329\n"
+"help.text"
+msgid "<variable id=\"timelimitdesc\">Sets the maximum time for the algorithm to converge to a solution.</variable>"
+msgstr ""
+
+#. 9WDm6
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id711589925192067\n"
+"help.text"
+msgid "<variable id=\"SwarmNonLinearSolverh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#SwarmNonLinearSolverh2\" name=\"%PRODUCTNAME Swarm Non-Linear Solver (Experimental)\">%PRODUCTNAME Swarm Non-Linear Solver (Experimental)</link></variable>"
+msgstr ""
+
+#. TFadK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id971589963431459\n"
+"help.text"
+msgid "Swarm algorithm"
+msgstr ""
+
+#. cgpYF
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id71589963431460\n"
+"help.text"
+msgid "Set the swarm algorithm. 0 for differential evolution and 1 for particle swarm optimization. Default is 0."
+msgstr ""
+
+#. ugAZb
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id271589981559367\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgstr ""
+
+#. D2nCR
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id211590163660314\n"
+"help.text"
+msgid "<link href=\"http://lpsolve.sourceforge.net/\">lp_solve reference guide in sourceforge.net</link>"
+msgstr ""
 
 #. Q6isn
 #: stat_data.xhp
diff --git a/source/nl/helpcontent2/source/text/sdatabase.po b/source/nl/helpcontent2/source/text/sdatabase.po
new file mode 100644
index 00000000000..bcb78a91063
--- /dev/null
+++ b/source/nl/helpcontent2/source/text/sdatabase.po
@@ -0,0 +1,140 @@
+#. extracted from helpcontent2/source/text/sdatabase
+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-05-19 12:41+0200\n"
+"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
+"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
+"Language-Team: LANGUAGE <LL@li.org>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Accelerator-Marker: ~\n"
+"X-Generator: LibreOffice\n"
+
+#. cLmBi
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"tit\n"
+"help.text"
+msgid "%PRODUCTNAME Database"
+msgstr ""
+
+#. yxuCC
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"bm_id8622089\n"
+"help.text"
+msgid "<bookmark_value>databases;main page (Base)</bookmark_value><bookmark_value>$[officename] Base data sources</bookmark_value><bookmark_value>data sources;$[officename] Base</bookmark_value>"
+msgstr ""
+
+#. yR4MP
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN10579\n"
+"help.text"
+msgid "<variable id=\"base\"><link href=\"text/sdatabase/main.xhp\">Using Databases in %PRODUCTNAME Base</link></variable>"
+msgstr ""
+
+#. FvcWc
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN107BD\n"
+"help.text"
+msgid "In %PRODUCTNAME Base, you can access data that is stored in a wide variety of database file formats. %PRODUCTNAME Base natively supports some flat file database formats, such as the dBASE format. You can also use %PRODUCTNAME Base to connect to external relational databases, such as databases from MySQL or Oracle."
+msgstr ""
+
+#. RRoXE
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_id5864131\n"
+"help.text"
+msgid "The following database types are read-only types in %PRODUCTNAME Base. From within %PRODUCTNAME Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:"
+msgstr ""
+
+#. uAqcW
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_id8865016\n"
+"help.text"
+msgid "Spreadsheet files"
+msgstr ""
+
+#. U7fFX
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_id3786736\n"
+"help.text"
+msgid "Text files"
+msgstr ""
+
+#. WPAC3
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_id6747337\n"
+"help.text"
+msgid "Address book data"
+msgstr ""
+
+#. TchjD
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN107C0\n"
+"help.text"
+msgid "Using a Database in %PRODUCTNAME"
+msgstr ""
+
+#. cBbKE
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN10838\n"
+"help.text"
+msgid "To create a new database file, choose <emph>File - New - Database</emph>."
+msgstr ""
+
+#. h4EpR
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN1083B\n"
+"help.text"
+msgid "The <link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link> helps you to create a database file and to register a new database within %PRODUCTNAME."
+msgstr ""
+
+#. 2jPWg
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN107E7\n"
+"help.text"
+msgid "The database file contains queries, reports, and forms for the database as well as a link to the database where the records are stored. Formatting information is also stored in the database file."
+msgstr ""
+
+#. 4DEr3
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_idN1084A\n"
+"help.text"
+msgid "To open a database file, choose <emph>File - Open</emph>. In the <emph>File type</emph> list box, select to view only \"Database documents\". Select a database document and click <emph>Open</emph>."
+msgstr ""
+
+#. QFEDB
+#: main.xhp
+msgctxt ""
+"main.xhp\n"
+"par_id6474806\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Database\" name=\"wiki.documentfoundation.org Database\">Wiki page about Base</link>"
+msgstr ""
diff --git a/source/nl/helpcontent2/source/text/shared/00.po b/source/nl/helpcontent2/source/text/shared/00.po
index 0a675916a46..d2e96644b26 100644
--- a/source/nl/helpcontent2/source/text/shared/00.po
+++ b/source/nl/helpcontent2/source/text/shared/00.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-27 15:54+0200\n"
+"POT-Creation-Date: 2020-05-27 11:43+0200\n"
 "PO-Revision-Date: 2020-03-10 11:44+0000\n"
 "Last-Translator: kees538 <kees538@gmail.com>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textshared00/nl/>\n"
@@ -3877,6 +3877,24 @@ msgctxt ""
 msgid "*.odm"
 msgstr "*.odm"
 
+#. vxBEx
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_idN10779\n"
+"help.text"
+msgid "ODF Master Document Template"
+msgstr ""
+
+#. h9xwQ
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_idN1077E\n"
+"help.text"
+msgid "*.otm"
+msgstr ""
+
 #. nkBGU
 #: 00000021.xhp
 msgctxt ""
@@ -4219,23 +4237,41 @@ msgctxt ""
 msgid "OpenOffice.org 3, StarOffice 9, Oracle Open Office"
 msgstr "OpenOffice.org 3, StarOffice 9, Oracle Open Office"
 
-#. vD7AT
+#. yDRTc
 #: 00000021.xhp
 msgctxt ""
 "00000021.xhp\n"
-"par_id1001200912381153\n"
+"par_id1001200912381154\n"
 "help.text"
-msgid "ODF 1.2 (Extended)"
-msgstr "ODF 1.2 (Extended)"
+msgid "ODF 1.2 Extended (compatibility mode)"
+msgstr ""
 
-#. UjbNC
+#. 8yWdz
 #: 00000021.xhp
 msgctxt ""
 "00000021.xhp\n"
-"par_id100120091238112\n"
+"par_id100120091238113\n"
 "help.text"
 msgid "-"
-msgstr "-"
+msgstr ""
+
+#. JvqYD
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id1001200912381175\n"
+"help.text"
+msgid "LibreOffice 3.5"
+msgstr ""
+
+#. Absnz
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id1001200912381153\n"
+"help.text"
+msgid "ODF 1.2 Extended"
+msgstr ""
 
 #. 3rCcz
 #: 00000021.xhp
@@ -4246,23 +4282,59 @@ msgctxt ""
 msgid "OpenOffice.org 3.2 or StarOffice 9.2"
 msgstr "OpenOffice.org 3.2 of StarOffice 9.2"
 
-#. mrGRB
+#. GGUsk
 #: 00000021.xhp
 msgctxt ""
 "00000021.xhp\n"
-"par_id0514200811525591\n"
+"par_id1001200912381155\n"
 "help.text"
-msgid "In current versions, you can select to save your documents using ODF 1.2 (default) or ODF 1.0/1.1 (for backward compatibility). Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - Load/Save - General</menuitem> and select the ODF format version."
+msgid "ODF 1.3"
 msgstr ""
 
-#. y6aBs
+#. 9DZNb
 #: 00000021.xhp
 msgctxt ""
 "00000021.xhp\n"
-"par_idN107E9\n"
+"par_id100120091238114\n"
+"help.text"
+msgid "TBD"
+msgstr ""
+
+#. TtGnn
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id1001200912381176\n"
+"help.text"
+msgid "LibreOffice 7.0"
+msgstr ""
+
+#. ks8eU
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id1001200912381156\n"
+"help.text"
+msgid "ODF 1.3 Extended"
+msgstr ""
+
+#. ZH6EB
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id1001200912381177\n"
+"help.text"
+msgid "LibreOffice 7.0"
+msgstr ""
+
+#. HGRdD
+#: 00000021.xhp
+msgctxt ""
+"00000021.xhp\n"
+"par_id0514200811525591\n"
 "help.text"
-msgid "If you want to exchange documents with users that still use OpenOffice.org 1 or StarOffice 7, save the document using the respectively named filter in the <emph>File type</emph> listbox."
-msgstr "Indien u documenten wilt uitwisselen met gebruikers die nog steeds OpenOffice.org 1 of StarOffice 7 gebruiken, sla het document dan op met behulp van het respectievelijk benoemde filter in de keuzelijst <emph>Bestandstype</emph>."
+msgid "In current versions, you can select to save your documents using ODF 1.2 or ODF 1.0/1.1 (for backward compatibility). Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - Load/Save - General</menuitem> and select the ODF format version."
+msgstr ""
 
 #. wCawc
 #: 00000021.xhp
@@ -8539,14 +8611,14 @@ msgctxt ""
 msgid "<variable id=\"allg\">Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph>.</variable>"
 msgstr "<variable id=\"allg\">Kies <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Voorkeuren</emph></caseinline><defaultinline><emph>Extra - Opties</emph></defaultinline></switchinline><emph> - $[officename] - Algemeen</emph>.</variable>"
 
-#. QpVmF
+#. 7eLKJ
 #: 00000406.xhp
 msgctxt ""
 "00000406.xhp\n"
 "par_id3159153\n"
 "help.text"
-msgid "<variable id=\"ansicht\">Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - View</emph>.</variable>"
-msgstr "<variable id=\"ansicht\">Kies <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Voorkeuren</emph></caseinline><defaultinline><emph>Extra - Opties</emph></defaultinline></switchinline><emph> - $[officename] - Beeld</emph>.</variable>"
+msgid "<variable id=\"view\">Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - $[officename] - View</menuitem>.</variable>"
+msgstr ""
 
 #. LLvWB
 #: 00000406.xhp
diff --git a/source/nl/helpcontent2/source/text/shared/01.po b/source/nl/helpcontent2/source/text/shared/01.po
index 68ddfbecc13..7938e4dd19a 100644
--- a/source/nl/helpcontent2/source/text/shared/01.po
+++ b/source/nl/helpcontent2/source/text/shared/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-29 22:17+0200\n"
+"POT-Creation-Date: 2020-05-20 13:08+0200\n"
 "PO-Revision-Date: 2020-03-02 09:15+0000\n"
 "Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textshared01/nl/>\n"
@@ -3742,167 +3742,185 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of tables in the file.</caseinline><caseinline select=\"CALC\">Number of sheets in the file.</caseinline></switchinline> This statistic <emph>does not</emph> include tables that were inserted as <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link> objects."
 msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Aantal tabelen in het bestand.</caseinline><caseinline select=\"CALC\">Aantal bladen in het bestand.</caseinline></switchinline> Deze statistief bevat <emph>geen</emph> tabellen die als <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link>-objecten ingevoegd zijn."
 
-#. EZWri
+#. gCAE7
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3153311\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Cells:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Cellen</caseinline></switchinline>"
+msgid "Cells:"
+msgstr ""
 
-#. seVAH
+#. sLNFC
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3156114\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Number of cells with content in the file.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Het aantal cellen met inhoud in het bestand.</caseinline></switchinline>"
+msgid "Number of cells with content in the file."
+msgstr ""
 
-#. TXysK
+#. sxqAk
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id641526904710590\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Formula groups:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Formulegroepen:</caseinline></switchinline>"
+msgid "Formula groups:"
+msgstr ""
 
-#. WAFAR
+#. QDcds
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id541526903668055\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Number of contiguous ranges in a column with same formula.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Aantal opeenvolgende bereiken in een kolom met dezelfde formule.</caseinline></switchinline>"
+msgid "Number of contiguous ranges in a column with same formula."
+msgstr ""
 
-#. H3i2a
+#. LU85G
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3147210\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Images:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Afbeeldingen:</caseinline></switchinline>"
+msgid "Images:"
+msgstr ""
 
-#. ryGt3
+#. a4k3j
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3166411\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of images in the file. This statistic <emph>does not</emph> include images that were inserted as <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link> objects.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Aantal afbeeldingen in het bestand. Deze statistiek bevat <emph>geen</emph> include afbeeldingen die als <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link>-objecten ingevoegd zijn.</caseinline></switchinline>"
+msgid "Number of images in the file. This statistic <emph>does not</emph> include images that were inserted as <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link> objects."
+msgstr ""
 
-#. KbxEs
+#. UBabs
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3147618\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">OLE Objects:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">OLE-objecten:</caseinline></switchinline>"
+msgid "OLE Objects:"
+msgstr ""
 
-#. BkmWR
+#. BuF3C
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3149820\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link> objects in the file, <emph>including</emph> tables and graphics that were inserted as OLE objects.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Aantal <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link>-objecten in het bestand, <emph>inclusief</emph> tabellen en afbeeldingen die als OLE-objecten zijn ingevoegd.</caseinline></switchinline>"
+msgid "Number of <link href=\"text/shared/00/00000005.xhp#ole\" name=\"OLE\"><emph>OLE</emph></link> objects in the file, <emph>including</emph> tables and graphics that were inserted as OLE objects."
+msgstr ""
 
-#. coPjE
+#. qw77q
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3153665\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Paragraphs:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Alinea's:</caseinline></switchinline>"
+msgid "Paragraphs:"
+msgstr ""
 
-#. 9cqSQ
+#. sDTWH
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3156156\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of paragraphs, including blank paragraphs, in the file.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Het aantal alinea's, inclusief lege alinea's, in het bestand.</caseinline></switchinline>"
+msgid "Number of paragraphs, including blank paragraphs, in the file."
+msgstr ""
 
-#. KDEhm
+#. cJoGM
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3155261\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Words:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Woorden:</caseinline></switchinline>"
+msgid "Words:"
+msgstr ""
 
-#. e7HhL
+#. NWZHb
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3147402\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of words, including words consisting of a single character, in the file.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Het aantal woorden, inclusief woorden die uit één teken bestaan, in het bestand.</caseinline></switchinline>"
+msgid "Number of words, including words consisting of a single character, in the file."
+msgstr ""
 
-#. oG7TM
+#. F9a22
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3150466\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Characters:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Tekens:</caseinline></switchinline>"
+msgid "Characters:"
+msgstr ""
 
-#. rLEmf
+#. J57aD
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3149294\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of characters, including spaces, in the file. Non-printable characters are not included.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Het aantal tekens, inclusief spaties, in het bestand. Niet-afdrukbare tekens zijn niet inbegrepen.</caseinline></switchinline>"
+msgid "Number of characters, including spaces, in the file. Non-printable characters are not included."
+msgstr ""
 
-#. LUXFC
+#. EvT7H
+#: 01100400.xhp
+msgctxt ""
+"01100400.xhp\n"
+"hd_id541589188608624\n"
+"help.text"
+msgid "Characters excluding spaces:"
+msgstr ""
+
+#. C6y8S
+#: 01100400.xhp
+msgctxt ""
+"01100400.xhp\n"
+"par_id341589188750182\n"
+"help.text"
+msgid "Number of characters, excluding spaces, in the file. Non-printable characters are not included."
+msgstr ""
+
+#. FeKAd
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3148947\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Lines:</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Regels:</caseinline></switchinline>"
+msgid "Lines:"
+msgstr ""
 
-#. 79fie
+#. cronY
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3149650\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Number of lines in the file.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Het aantal regels in het bestand.</caseinline></switchinline>"
+msgid "Number of lines in the file."
+msgstr ""
 
-#. hcEnb
+#. dbQ2X
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3153525\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Update</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Bijwerken</caseinline></switchinline>"
+msgid "Update"
+msgstr ""
 
-#. JzybH
+#. xECP4
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "par_id3148981\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><ahelp hid=\"modules/swriter/ui/statisticsinfopage/update\">Updates the statistics.</ahelp></caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><ahelp hid=\"modules/swriter/ui/statisticsinfopage/update\">De statistieken bijwerken.</ahelp></caseinline></switchinline>"
+msgid "<ahelp hid=\"modules/swriter/ui/statisticsinfopage/update\">Updates the statistics.</ahelp>"
+msgstr ""
 
 #. HpTwh
 #: 01100600.xhp
@@ -7837,13 +7855,13 @@ msgctxt ""
 msgid "A line break that was inserted with the <keycode>Shift+Enter</keycode> key combination when in the <widget>Find</widget> text box."
 msgstr ""
 
-#. oALhj
+#. r4Xir
 #: 02100001.xhp
 msgctxt ""
 "02100001.xhp\n"
 "par_id731559575258580\n"
 "help.text"
-msgid "A paragraph break that can be entered with the <keycode>Enter</keycode> or <keycode>Return</keycode> key when in the <widget>Replace</widget> text box."
+msgid "A paragraph break that can be entered with the <keycode>Enter</keycode> or <keycode>Return</keycode> key when in the <widget>Replace</widget> text box in Writer. Has no special meaning in Calc, and is treated literally there."
 msgstr ""
 
 #. u7KxS
@@ -15613,13 +15631,13 @@ msgctxt ""
 msgid "Language"
 msgstr "Taal"
 
-#. tGmXJ
+#. wCJKH
 #: 05020300.xhp
 msgctxt ""
 "05020300.xhp\n"
 "par_id3154138\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/numberingformatpage/languagelb\">Specifies the language setting for the selected <switchinline select=\"appl\"><caseinline select=\"CALC\">cells</caseinline><defaultinline>field</defaultinline></switchinline>. <switchinline select=\"appl\"><caseinline select=\"WRITER\">With the language set to <emph>Automatic</emph>, $[officename] automatically applies the number formats associated with the system default language.</caseinline></switchinline> Select any language to fix the settings for the selected <switchinline select=\"appl\"><caseinline select=\"CALC\">cells</caseinline><defaultinline> fields</defaultinline></switchinline>.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/numberingformatpage/languagelb\">  <switchinline select=\"appl\">      <caseinline select=\"WRITER\">          Select any language to fix the settings for the selected fields. With the language set to <emph>Automatic</emph>, $[officename] automatically applies the number formats associated with the system default language. Select any language to fix the settings for the selected fields.      </caseinline>      <caseinline select=\"CALC\">          Specifies the language setting for the selected cells. Select any language to fix the settings for the selected cells.      </caseinline>      <defaultinline>Specifies the language setting for the selected field. Select any language to fix the settings for the selected fields.</defaultinline>  </switchinline>  </ahelp>"
 msgstr ""
 
 #. K29ZG
@@ -19753,15 +19771,6 @@ msgctxt ""
 msgid "File opens in a named frame in the current HTML document."
 msgstr "Het bestand wordt geopend in een benoemd frame in het huidige HTML-document."
 
-#. wf4vi
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3148739\n"
-"help.text"
-msgid "_self"
-msgstr "_self"
-
 #. E9CvG
 #: 05020400.xhp
 msgctxt ""
@@ -19771,15 +19780,6 @@ msgctxt ""
 msgid "File opens in the current frame."
 msgstr "Het bestand wordt in het huidige frame geopend."
 
-#. PdCyG
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3151210\n"
-"help.text"
-msgid "_blank"
-msgstr "_blank"
-
 #. Kv599
 #: 05020400.xhp
 msgctxt ""
@@ -19789,15 +19789,6 @@ msgctxt ""
 msgid "File opens in a new page."
 msgstr "Het bestand wordt op een nieuwe pagina geopend."
 
-#. GhVRg
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3148451\n"
-"help.text"
-msgid "_parent"
-msgstr "_parent"
-
 #. 9oC24
 #: 05020400.xhp
 msgctxt ""
@@ -19807,15 +19798,6 @@ msgctxt ""
 msgid "File opens in the parent frame of the current frame. If there is no parent frame, the current frame is used."
 msgstr "Het bestand wordt in het bovenliggende frame van het huidige frame geopend. Als er geen bovenliggend frame aanwezig is, wordt het huidige frame gebruikt."
 
-#. FP7B6
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3154153\n"
-"help.text"
-msgid "_top"
-msgstr "_top"
-
 #. rkF4o
 #: 05020400.xhp
 msgctxt ""
@@ -22687,15 +22669,6 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/pageformatpage/PageFormatPage\">Allows you to define page layouts for single and multiple-page documents, as well as a numbering and paper formats.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/pageformatpage/PageFormatPage\">Hiermee kunt u pagina-layouts voor documenten met één en meerdere pagina's definiëren, evenals een nummering en papierformaten.</ahelp>"
 
-#. Upj6A
-#: 05040200.xhp
-msgctxt ""
-"05040200.xhp\n"
-"par_id090120160133439102\n"
-"help.text"
-msgid "<image id=\"img_id090120160131201466\" src=\"media/screenshots/cui/ui/pageformatpage/PageFormatPage.png\" width=\"8.6457in\" height=\"5.9063in\"><alt id=\"alt_id090120160131201466\">Page format tab page</alt></image>"
-msgstr "<image id=\"img_id090120160131201466\" src=\"media/screenshots/cui/ui/pageformatpage/PageFormatPage.png\" width=\"8.6457in\" height=\"5.9063in\"><alt id=\"alt_id090120160131201466\">Tabblad Pagina van het venster Pagina-opmaakprofiel</alt></image>"
-
 #. EEgg6
 #: 05040200.xhp
 msgctxt ""
@@ -44872,14 +44845,14 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/notebook_bar.xhp\">Using the notebook bar</link>"
 msgstr "<link href=\"text/shared/01/notebook_bar.xhp\">De notebookbalk gebruiken</link>"
 
-#. Hme8z
+#. LkNPu
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161732262244\n"
 "help.text"
-msgid "<ahelp hid=\".\">The notebook bar is a new form of displaying commands icons for a quicker usage</ahelp>"
-msgstr "<ahelp hid=\".\">De notebookbalk is een nieuwe vorm van het weergeven van pictogrammen voor opdrachten om sneller te werken.</ahelp>"
+msgid "<ahelp hid=\".\">The notebook bar is a new form of displaying commands icons for a quicker usage.</ahelp>"
+msgstr ""
 
 #. roAUi
 #: notebook_bar.xhp
@@ -44908,23 +44881,23 @@ msgctxt ""
 msgid "With the notebook bar, frequently used commands are grouped in an arrangement that will make it quicker to access, avoiding lengthy menu navigation and toolbars command icon lookup."
 msgstr "Met de notebookbalk worden veelgebruikte opdrachten gegroepeerd in een samenstelling die sneller toegang geven, waardoor lang navigeren in menu's en werkbalken naar het zoeken van opdrachten wordt voorkomen."
 
-#. Qmurg
+#. GjBq3
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161744067918\n"
 "help.text"
-msgid "The notebook bar is available in Writer, Calc and Impress. The user interface has now several available layouts. To change the layout, choose <item type=\"menuitem\">View - User Interface</item> and from the submenu select the layout which you want."
-msgstr "De notebookbalk is beschikbaar in Writer, Calc en Impress. De gebruikersinterface heeft nu verschillende beschikbare lay-outs. Om van lay-out te wisselen, kies <item type=\"menuitem\">Beeld - Gebruikersinterface</item> en selecteer de gewenste lay-out."
+msgid "The notebook bar is available in Writer, Calc, Draw and Impress. The user interface has now several available layouts. To change the layout, choose <menuitem>View - User Interface</menuitem> and from the submenu select the layout which you want."
+msgstr ""
 
-#. 9gGf4
+#. eBXFy
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161744066306\n"
 "help.text"
-msgid "Choose menu <item type=\"menuitem\">View - User Interface</item>"
-msgstr "Kies <item type=\"menuitem\">Beeld - Gebruikersinterface</item>"
+msgid "Choose menu <menuitem>View - User Interface</menuitem>"
+msgstr ""
 
 #. SJiku
 #: notebook_bar.xhp
@@ -45052,14 +45025,14 @@ msgctxt ""
 msgid "The Tabbed and Groupedbar modes are also available as compact variants."
 msgstr "Van de modi Tabblad en Groepen is ook een compact-versie aanwezig."
 
-#. iQUHs
+#. 5BGEh
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161744076273\n"
 "help.text"
-msgid "The notebook bar icon size is adjustable in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME - View - Notebookbar icon size</item> listbox."
-msgstr "De pictogramgrootte van de noteboekbalk is aanpasbaar in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Voorkeuren</item></caseinline><defaultinline><item type=\"menuitem\">Extra - Opties</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME - Beeld - Pictogramgrootte Notebookbalk</item>."
+msgid "The notebook bar icon size is adjustable in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - View - Notebookbar icon size</menuitem> listbox."
+msgstr ""
 
 #. ooEpD
 #: notebook_bar.xhp
@@ -45070,14 +45043,14 @@ msgctxt ""
 msgid "The notebook bar cannot be customized."
 msgstr "De notebookbalk kan niet aangepast worden."
 
-#. AhU4A
+#. cKECd
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161744078275\n"
 "help.text"
-msgid "The current implementation (%PRODUCTNAME %PRODUCTVERSION) of the notebook bar is common to Writer, Calc and Impress modules. A change in the notebook bar in one module will affect the notebook bar of the other modules."
-msgstr "De huidige implementatie (%PRODUCTNAME %PRODUCTVERSION) van de notebookbalk is voor gebruik in Writer, Calc en Impress modules. Een wijziging in de notebookbalk in één module zal de notebookbalk van de andere modules beïnvloeden."
+msgid "The current implementation (%PRODUCTNAME %PRODUCTVERSION) of the notebook bar is common to Writer, Calc, Draw and Impress modules. A change in the notebook bar in one module will affect the notebook bar of the other modules."
+msgstr ""
 
 #. zznYu
 #: notebook_bar.xhp
@@ -45088,6 +45061,15 @@ msgctxt ""
 msgid "<link href=\"text/shared/guide/floating_toolbar.xhp\">Toolbars</link>"
 msgstr "<link href=\"text/shared/guide/floating_toolbar.xhp\">Werkbalken</link>"
 
+#. tZPkf
+#: notebook_bar.xhp
+msgctxt ""
+"notebook_bar.xhp\n"
+"par_id921589901261168\n"
+"help.text"
+msgid "<link href=\"text/shared/optionen/01010800.xhp\" name=\"view\">View</link> options"
+msgstr ""
+
 #. kgVKD
 #: online_update.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/06.po b/source/nl/helpcontent2/source/text/shared/06.po
index 4fb6eff001b..6bb731384c9 100644
--- a/source/nl/helpcontent2/source/text/shared/06.po
+++ b/source/nl/helpcontent2/source/text/shared/06.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-01-17 16:45+0100\n"
+"POT-Creation-Date: 2020-05-11 14:25+0200\n"
 "PO-Revision-Date: 2019-02-10 09:32+0000\n"
 "Last-Translator: kees538 <kees538@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -259,6 +259,15 @@ msgctxt ""
 msgid "<image id=\"img_id521237\" src=\"media/screenshots/cui/ui/colorpage/ColorPage.png\"><alt id=\"alt_id378144\">Color page dialog</alt></image>"
 msgstr ""
 
+#. mpmiK
+#: shared_cui_screenshots.xhp
+msgctxt ""
+"shared_cui_screenshots.xhp\n"
+"par_id531589156232176\n"
+"help.text"
+msgid "<image id=\"img_id090120160131201466\" src=\"media/screenshots/cui/ui/pageformatpage/PageFormatPage.png\"><alt id=\"alt_id090120160131201466\">Page format tab page</alt></image>"
+msgstr ""
+
 #. agtWk
 #: simpress_screenshots.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/explorer/database.po b/source/nl/helpcontent2/source/text/shared/explorer/database.po
index 770466f30dd..8f45d35d780 100644
--- a/source/nl/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/nl/helpcontent2/source/text/shared/explorer/database.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-27 15:55+0200\n"
+"POT-Creation-Date: 2020-05-19 12:41+0200\n"
 "PO-Revision-Date: 2020-03-10 09:17+0000\n"
 "Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedexplorerdatabase/nl/>\n"
@@ -6568,14 +6568,14 @@ msgctxt ""
 msgid "<ahelp hid=\".\">The database file window organizes the tables, views, queries, and reports of a database in %PRODUCTNAME.</ahelp>"
 msgstr "<ahelp hid=\".\">In het bestandsvenster van de database worden de tabellen, weergaven, query's en rapporten van een database in %PRODUCTNAME beheerd.</ahelp>"
 
-#. Lx3G5
+#. 3KEBA
 #: dabadoc.xhp
 msgctxt ""
 "dabadoc.xhp\n"
 "par_idN105B7\n"
 "help.text"
-msgid "<link href=\"text/shared/explorer/database/main.xhp\">Working with databases in %PRODUCTNAME</link>"
-msgstr "<link href=\"text/shared/explorer/database/main.xhp\">Met databases in %PRODUCTNAME werken</link>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
+msgstr ""
 
 #. ptEgp
 #: dabaprop.xhp
@@ -8674,22 +8674,22 @@ msgctxt ""
 msgid "<link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link>"
 msgstr "<link href=\"text/shared/explorer/database/dabawiz00.xhp\">Assistent Database</link>"
 
-#. QCKtt
+#. Y4EFA
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "tit\n"
 "help.text"
-msgid "MySQL Connection"
-msgstr "MySQL-verbinding"
+msgid "MariaDB and MySQL Connection"
+msgstr ""
 
-#. B5kKY
+#. bVNAZ
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "bm_id861587404584956\n"
 "help.text"
-msgid "<bookmark_value>MariaDB settings (base)</bookmark_value><bookmark_value>MySQL settings (base)</bookmark_value>"
+msgid "<bookmark_value>MariaDB settings (Base)</bookmark_value><bookmark_value>MySQL settings (Base)</bookmark_value>"
 msgstr ""
 
 #. f4CzF
@@ -8746,13 +8746,13 @@ msgctxt ""
 msgid "Server URL"
 msgstr ""
 
-#. Dw4Qu
+#. SshYk
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "par_id521587405341138\n"
 "help.text"
-msgid "Enter the URL for the database server. This is the name of the machine that runs the MariaDB or MYSQL database. You can also replace hostname with the IP address of the server."
+msgid "Enter the URL for the database server. This is the name of the machine that runs the MariaDB or MySQL database. You can also replace hostname with the IP address of the server."
 msgstr ""
 
 #. MZQiq
@@ -9601,132 +9601,6 @@ msgctxt ""
 msgid "<link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link>"
 msgstr "<link href=\"text/shared/explorer/database/dabawiz00.xhp\">Assistent Database</link>"
 
-#. cLmBi
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"tit\n"
-"help.text"
-msgid "%PRODUCTNAME Database"
-msgstr "%PRODUCTNAME-database"
-
-#. yxuCC
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"bm_id8622089\n"
-"help.text"
-msgid "<bookmark_value>databases;main page (Base)</bookmark_value><bookmark_value>$[officename] Base data sources</bookmark_value><bookmark_value>data sources;$[officename] Base</bookmark_value>"
-msgstr "<bookmark_value>databases;hoofdpagina (Base)</bookmark_value><bookmark_value>$[officename] Base gegevensbronnen</bookmark_value><bookmark_value>gegevensbronnen;$[officename] Base</bookmark_value>"
-
-#. aS7aL
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN10579\n"
-"help.text"
-msgid "<variable id=\"base\"><link href=\"text/shared/explorer/database/main.xhp\">Using Databases in %PRODUCTNAME Base</link></variable>"
-msgstr "<variable id=\"base\"><link href=\"text/shared/explorer/database/main.xhp\">Databases in %PRODUCTNAME Base gebruiken</link></variable>"
-
-#. FvcWc
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN107BD\n"
-"help.text"
-msgid "In %PRODUCTNAME Base, you can access data that is stored in a wide variety of database file formats. %PRODUCTNAME Base natively supports some flat file database formats, such as the dBASE format. You can also use %PRODUCTNAME Base to connect to external relational databases, such as databases from MySQL or Oracle."
-msgstr "In %PRODUCTNAME Base kunt u gegevens oproepen die in vele verschillende databasebestandsindelingen zijn opgeslagen. %PRODUCTNAME Base heeft ingebouwde ondersteuning voor enkele platte databasebestandsindelingen, zoals de dBASE-indeling. Met %PRODUCTNAME Base kunt u ook een verbinding met externe relationele databases maken, zoals databases van MySQL of Oracle."
-
-#. RRoXE
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id5864131\n"
-"help.text"
-msgid "The following database types are read-only types in %PRODUCTNAME Base. From within %PRODUCTNAME Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:"
-msgstr "De volgende databasetypen zijn alleen-lezen-typen in %PRODUCTNAME Base. Binnen %PRODUCTNAME Base is het niet mogelijk om de databasestructuur te wijzigen of om databaserecords voor deze databasetypen te bewerken, in te voegen of te verwijderen:"
-
-#. uAqcW
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id8865016\n"
-"help.text"
-msgid "Spreadsheet files"
-msgstr "Werkbladbestanden"
-
-#. U7fFX
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id3786736\n"
-"help.text"
-msgid "Text files"
-msgstr "Tekstbestanden"
-
-#. WPAC3
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id6747337\n"
-"help.text"
-msgid "Address book data"
-msgstr "Adresboekgegevens"
-
-#. TchjD
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN107C0\n"
-"help.text"
-msgid "Using a Database in %PRODUCTNAME"
-msgstr "Een database in %PRODUCTNAME gebruiken"
-
-#. cBbKE
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN10838\n"
-"help.text"
-msgid "To create a new database file, choose <emph>File - New - Database</emph>."
-msgstr "Kies <emph>Bestand - Nieuw - Database</emph> om een nieuw databasebestand te maken."
-
-#. h4EpR
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN1083B\n"
-"help.text"
-msgid "The <link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link> helps you to create a database file and to register a new database within %PRODUCTNAME."
-msgstr "Met behulp van de <link href=\"text/shared/explorer/database/dabawiz00.xhp\">Assistent Database</link> kunt u een databasebestand maken en een nieuwe database in %PRODUCTNAME registreren."
-
-#. 2jPWg
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN107E7\n"
-"help.text"
-msgid "The database file contains queries, reports, and forms for the database as well as a link to the database where the records are stored. Formatting information is also stored in the database file."
-msgstr "Het databasebestand bevat query's, rapporten en formulieren voor de database, evenals een koppeling naar de database waar de records worden bewaard. Opmaakinformatie wordt ook in het databasebestand opgeslagen."
-
-#. 4DEr3
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_idN1084A\n"
-"help.text"
-msgid "To open a database file, choose <emph>File - Open</emph>. In the <emph>File type</emph> list box, select to view only \"Database documents\". Select a database document and click <emph>Open</emph>."
-msgstr "Kies <emph>Bestand - Openen</emph> om een datbasebestand te openen. In de keuzelijst <emph>Bestandstype</emph> selecteert u dat u alleen \"Databasedocumenten\" wilt zien. Selecteer een databasedocument en klik op <emph>Openen</emph>."
-
-#. QFEDB
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id6474806\n"
-"help.text"
-msgid "<link href=\"https://wiki.documentfoundation.org/Database\" name=\"wiki.documentfoundation.org Database\">Wiki page about Base</link>"
-msgstr "<link href=\"https://wiki.documentfoundation.org/Database\" name=\"wiki.documentfoundation.org Database\">Wiki-pagina over Base</link>"
-
 #. rw2xT
 #: menubar.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/guide.po b/source/nl/helpcontent2/source/text/shared/guide.po
index 575f928a67d..637e6ea0247 100644
--- a/source/nl/helpcontent2/source/text/shared/guide.po
+++ b/source/nl/helpcontent2/source/text/shared/guide.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-27 15:55+0200\n"
+"POT-Creation-Date: 2020-05-19 12:41+0200\n"
 "PO-Revision-Date: 2019-08-08 08:58+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5344,42 +5344,6 @@ msgctxt ""
 msgid "MOV - QuickTime File Format"
 msgstr "MOV - QuickTime-bestandsformaat"
 
-#. VSUDs
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter54\n"
-"help.text"
-msgid "Macromedia Flash (SWF)"
-msgstr "Macromedia Flash (SWF)"
-
-#. ojK6F
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter55\n"
-"help.text"
-msgid "None"
-msgstr "Geen"
-
-#. SqSpc
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter57\n"
-"help.text"
-msgid "Macromedia Flash (SWF)"
-msgstr "Macromedia Flash (SWF)"
-
-#. 3D8p5
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter58\n"
-"help.text"
-msgid "None"
-msgstr "Geen"
-
 #. oAAov
 #: convertfilters.xhp
 msgctxt ""
@@ -8251,14 +8215,14 @@ msgctxt ""
 msgid "<variable id=\"database_main\"><link href=\"text/shared/guide/database_main.xhp\" name=\"Data Source Overview\">Database Overview</link></variable>"
 msgstr "<variable id=\"database_main\"><link href=\"text/shared/guide/database_main.xhp\" name=\"Data Source Overview\">Database-overzicht</link></variable>"
 
-#. oygdp
+#. ouC3J
 #: database_main.xhp
 msgctxt ""
 "database_main.xhp\n"
 "par_idN105F1\n"
 "help.text"
-msgid "<link href=\"text/shared/explorer/database/main.xhp\">Working with databases in %PRODUCTNAME</link>"
-msgstr "<link href=\"text/shared/explorer/database/main.xhp\">Werken met databases in %PRODUCTNAME</link>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
+msgstr ""
 
 #. VPAta
 #: database_main.xhp
@@ -16801,14 +16765,14 @@ msgctxt ""
 msgid "Data Sources"
 msgstr "Gegevensbronnen"
 
-#. XGAwL
+#. dFGaf
 #: main.xhp
 msgctxt ""
 "main.xhp\n"
 "par_idN10826\n"
 "help.text"
-msgid "<link href=\"text/shared/explorer/database/main.xhp\">Working with databases in %PRODUCTNAME</link>"
-msgstr "<link href=\"text/shared/explorer/database/main.xhp\">Werken met databases in %PRODUCTNAME</link>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
+msgstr ""
 
 #. CGeKT
 #: main.xhp
@@ -23308,14 +23272,14 @@ msgctxt ""
 msgid "<emph>Math Formula</emph> opens %PRODUCTNAME <link href=\"text/smath/main0000.xhp\">Math</link>"
 msgstr "<emph>Formule</emph> opent %PRODUCTNAME <link href=\"text/smath/main0000.xhp\">Math</link>"
 
-#. PHUPr
+#. nq6EF
 #: startcenter.xhp
 msgctxt ""
 "startcenter.xhp\n"
 "par_id0820200803105089\n"
 "help.text"
-msgid "<emph>Base Database</emph> opens %PRODUCTNAME <link href=\"text/shared/explorer/database/main.xhp\">Base</link>"
-msgstr "<emph>Database</emph> opent %PRODUCTNAME <link href=\"text/shared/explorer/database/main.xhp\">Base</link>"
+msgid "<emph>Base Database</emph> opens %PRODUCTNAME <link href=\"text/sdatabase/main.xhp\">Base</link>"
+msgstr ""
 
 #. MvEcH
 #: startcenter.xhp
diff --git a/source/nl/helpcontent2/source/text/shared/optionen.po b/source/nl/helpcontent2/source/text/shared/optionen.po
index 19bd979fcbc..a9fdf075a45 100644
--- a/source/nl/helpcontent2/source/text/shared/optionen.po
+++ b/source/nl/helpcontent2/source/text/shared/optionen.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-27 15:55+0200\n"
+"POT-Creation-Date: 2020-05-27 11:43+0200\n"
 "PO-Revision-Date: 2020-04-14 06:16+0000\n"
 "Last-Translator: kees538 <kees538@gmail.com>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedoptionen/nl/>\n"
@@ -1078,59 +1078,68 @@ msgctxt ""
 msgid "ODF format version"
 msgstr "ODF-indeling versie"
 
-#. pEQ68
+#. sDCvq
+#: 01010200.xhp
+msgctxt ""
+"01010200.xhp\n"
+"par_id6944182\n"
+"help.text"
+msgid "LibreOffice 7.0 supports the <link href=\"https://en.wikipedia.org/wiki/OpenDocument\" name=\"English Wikipedia: OpenDocument\"><emph>OpenDocument</emph></link> format (ODF) version 1.3. The prior versions of LibreOffice support the file format ODF 1.2. Prior file formats cannot store all new features of the new software."
+msgstr ""
+
+#. BZc73
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id6944181\n"
 "help.text"
-msgid "OpenOffice.org 3 and StarOffice 9 introduced new features which have to be saved using the <link href=\"https://en.wikipedia.org/wiki/OpenDocument\" name=\"English Wikipedia: OpenDocument\"><emph>OpenDocument></emph></link> format (ODF) version 1.2. The prior versions of OpenOffice.org 2 and StarOffice 8 support the file formats ODF 1.0/1.1. Those prior file formats cannot store all new features of the new software."
-msgstr "OpenOffice.org 3 en StarOffice 9 introduceren nieuwe mogelijkheden die moeten worden opgeslagen met de <link href=\"https://en.wikipedia.org/wiki/OpenDocument\" name=\"English Wikipedia: OpenDocument\"><emph>OpenDocument</emph></link>-opmaak (ODF) versie 1.2. De eerdere versies van OpenOffice.org 2 en StarOffice 8 ondersteunen de bestandsformaten ODF 1.0/1.1. Deze eerdere bestandsformaten kunnen niet alle nieuwe mogelijkheden van de nieuwe software opslaan."
+msgid "OpenOffice.org 3 and StarOffice 9 introduced new features which have to be saved using the <link href=\"https://en.wikipedia.org/wiki/OpenDocument\" name=\"English Wikipedia: OpenDocument\"><emph>OpenDocument</emph></link> format (ODF) version 1.2. The prior versions of OpenOffice.org 2 and StarOffice 8 support the file formats ODF 1.0/1.1. Those prior file formats cannot store all new features of the new software."
+msgstr ""
 
-#. pto2V
+#. BoRgh
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id886257\n"
 "help.text"
-msgid "Current %PRODUCTNAME versions can open documents in ODF formats 1.0/1.1 and 1.2."
-msgstr "Huidige %PRODUCTNAME-versies kunnen documenten in ODF-opmaak 1.0/1.1 and 1.2 openen."
+msgid "Current %PRODUCTNAME versions can open documents in ODF formats 1.0/1.1, 1.2, and 1.3."
+msgstr ""
 
-#. BHABK
+#. PL8e4
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id8892483\n"
 "help.text"
-msgid "When you save a document, you can select whether to save the document in the format ODF 1.2, ODF 1.2 (Extended), or in the prior format ODF 1.0/1.1."
-msgstr "Als u een document opslaat kunt u selecteren om het document op te slaan in de indeling ODF 1.2, ODF 1.2 (Extended) of in de eerdere indeling ODF 1.0/1.1."
+msgid "When you save a document, you can select whether to save the document in the format ODF 1.3, ODF 1.3 Extended, ODF 1.2, ODF 1.2 Extended, ODF 1.2 Extended (compatibility mode), or in the prior format ODF 1.0/1.1."
+msgstr ""
 
-#. NAxKq
+#. hadyp
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id0915200911205367\n"
 "help.text"
-msgid "Currently, the ODF 1.2 (Extended) format enables files of Draw and Impress to contain comments. Those comments can be inserted by <item type=\"menuitem\">Insert - Comment</item> in the latest software version. The comments get lost when loading files into prior software versions that were saved by the latest software version."
-msgstr "Momenteel maakt de indeling ODF 1.2 (Extended) het mogelijk dat bestanden van Draw en Impress notities bevatten. Deze notities kunnen worden ingevoegd met <item type=\"menuitem\">Invoegen - Notitie</item> in de laatste softwareversie. De notities gaan verloren bij het laden van bestanden in eerdere versies van de software indien zij werden opgeslagen met de laatste versie van de software."
+msgid "Currently, the ODF 1.2 (Extended) or newer formats enable files of Draw and Impress to contain comments. Those comments can be inserted by <item type=\"menuitem\">Insert - Comment</item> in the latest software version. The comments get lost when loading files into prior software versions that were saved by the latest software version."
+msgstr ""
 
-#. YHA83
+#. aLBQC
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id7198400\n"
 "help.text"
-msgid "<ahelp hid=\".\">Some companies or organizations may require ODF documents in the ODF 1.0/1.1 format. You can select that format to save in the listbox. This older format cannot store all new features, so the new format ODF 1.2 (Extended) is recommended where possible.</ahelp>"
-msgstr "<ahelp hid=\".\">Sommige bedrijven of organisaties kunnen ODF-documenten in de ODF 1.0/1.1-opmaak verlangen. U kunt in de keuzelijst die opmaak kiezen om op te slaan. Deze oudere indeling kan niet alle nieuwe mogelijkheden opslaan, dus wordt, waar mogelijk, het nieuwe formaat ODF 1.2 (Extended) aanbevolen.</ahelp>"
+msgid "<ahelp hid=\".\">Some companies or organizations may require ODF documents in the ODF 1.0/1.1, or ODF 1.2 format. You can select these format to save in the listbox. These older formats cannot store all new features, so the new format ODF 1.3 (Extended) is recommended where possible.</ahelp>"
+msgstr ""
 
-#. 56Bit
+#. 9iBAX
 #: 01010200.xhp
 msgctxt ""
 "01010200.xhp\n"
 "par_id7198401\n"
 "help.text"
-msgid "The ODF 1.2 Extended (compat) mode is a more backward-compatible ODF 1.2 extended mode. It uses features that are deprecated in ODF1.2 and/or it is 'bug-compatible' to older OpenOffice.org versions. It may be useful, if you need to interchange ODF documents with users, who use pre-ODF1.2 or ODF1.2-only legacy applications."
-msgstr "De ODF 1.2 uitgebreide modus (compat) is een meer achterwaarts compatibel ODF 1.2 uitgebreide modus. Het maakt gebruik van functies die zijn gedeprecieerd in ODF1.2 en/of het is 'bug-compatible' met oudere versies van OpenOffice.org. Het kan nuttig zijn, als u ODF-documenten moet uitwisselen met gebruikers, die gebruik maken van oudere pre-ODF1.2 of ODF1.2-only applicaties."
+msgid "The ODF 1.2 Extended (compatibility mode) is a more backward-compatible ODF 1.2 extended mode. It uses features that are deprecated in ODF 1.2 and/or it is 'bug-compatible' to older OpenOffice.org versions. It may be useful if you need to interchange ODF documents with users who use pre-ODF 1.2 or ODF 1.2-only legacy applications."
+msgstr ""
 
 #. iP4AE
 #: 01010200.xhp
diff --git a/source/nl/helpcontent2/source/text/simpress/01.po b/source/nl/helpcontent2/source/text/simpress/01.po
index 65fee1bb374..20bc9b92ace 100644
--- a/source/nl/helpcontent2/source/text/simpress/01.po
+++ b/source/nl/helpcontent2/source/text/simpress/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-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-05-07 12:48+0200\n"
 "PO-Revision-Date: 2019-07-12 19:24+0000\n"
 "Last-Translator: vpanter <leo.moons@telenet.be>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -25,14 +25,14 @@ msgctxt ""
 msgid "Export"
 msgstr "Exporteren"
 
-#. tBBeZ
+#. ToRjB
 #: 01170000.xhp
 msgctxt ""
 "01170000.xhp\n"
 "bm_id3153728\n"
 "help.text"
-msgid "<bookmark_value>Macromedia Flash export</bookmark_value><bookmark_value>exporting;to Macromedia Flash format</bookmark_value>"
-msgstr "<bookmark_value>Macromedia Flash;exporteren</bookmark_value><bookmark_value>exporteren;naar Macromedia Flash-indeling</bookmark_value>"
+msgid "<bookmark_value>Presentation HTML export</bookmark_value> <bookmark_value>Drawing HTML export</bookmark_value><bookmark_value>exporting;to HTML format</bookmark_value>"
+msgstr ""
 
 #. y8AoW
 #: 01170000.xhp
@@ -70,15 +70,6 @@ msgctxt ""
 msgid "<link href=\"text/shared/autopi/01110000.xhp\" name=\"HTML Document\">HTML Document</link>, <link href=\"text/shared/00/00000200.xhp\" name=\"Image Options\">JPEG, SVM/WMF/PICT/MET, BMP, GIF, EPS, PNG, PBM, PPM, PGM</link>."
 msgstr ""
 
-#. LDX5K
-#: 01170000.xhp
-msgctxt ""
-"01170000.xhp\n"
-"par_id3145584\n"
-"help.text"
-msgid "If you select \"Macromedia Flash (SWF)\" as file format, the current Impress or Draw document will be exported to the Macromedia Flash format."
-msgstr "Als u ‘Macromedia Flash (SWF)’ als bestandsindeling selecteert, wordt het huidige Impress- of Draw-document geëxporteerd naar de Macromedia Flash-indeling."
-
 #. oyYNp
 #: 01170000.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/simpress/guide.po b/source/nl/helpcontent2/source/text/simpress/guide.po
index f3df4b5f233..83d35e07c2a 100644
--- a/source/nl/helpcontent2/source/text/simpress/guide.po
+++ b/source/nl/helpcontent2/source/text/simpress/guide.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-27 15:55+0200\n"
+"POT-Creation-Date: 2020-05-19 12:41+0200\n"
 "PO-Revision-Date: 2019-07-12 19:25+0000\n"
 "Last-Translator: vpanter <leo.moons@telenet.be>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -340,14 +340,14 @@ msgctxt ""
 msgid "To create an animated GIF:"
 msgstr "Zo maakt u een GIF-animatie:"
 
-#. REeik
+#. 3C5Z8
 #: animated_gif_create.xhp
 msgctxt ""
 "animated_gif_create.xhp\n"
 "par_id3148703\n"
 "help.text"
-msgid "Select an object or group of objects that you want to include in your animation and choose<emph> Insert - Animated Image</emph>."
-msgstr "Selecteer een object of groep objecten voor uw animatie en kies<emph> Invoegen - Geanimeerde afbeelding</emph>."
+msgid "Select an object or group of objects that you want to include in your animation and choose<emph> Insert - Media - Animated Image</emph>."
+msgstr ""
 
 #. EaBa6
 #: animated_gif_create.xhp
diff --git a/source/nl/helpcontent2/source/text/swriter.po b/source/nl/helpcontent2/source/text/swriter.po
index 17208ad5693..9863bda4fa1 100644
--- a/source/nl/helpcontent2/source/text/swriter.po
+++ b/source/nl/helpcontent2/source/text/swriter.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-05-05 14:59+0200\n"
+"POT-Creation-Date: 2020-05-11 14:25+0200\n"
 "PO-Revision-Date: 2019-02-28 21:31+0000\n"
 "Last-Translator: vpanter <leo.moons@telenet.be>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -898,13 +898,13 @@ msgctxt ""
 msgid "Show Whitespace"
 msgstr ""
 
-#. eFkCV
+#. WJ3Vz
 #: main0103.xhp
 msgctxt ""
 "main0103.xhp\n"
 "par_id102720150854012820\n"
 "help.text"
-msgid "Displays the document with the top and bottom margins, header and footer and a gap between pages. Uncheck to collapse all the elements above and display document in a contiguous page stream."
+msgid "Displays the document with the top and bottom margins, header and footer and a gap between pages. Uncheck to collapse all the elements above and display document in a contiguous page stream. Hiding whitespace is only possible in Single-page view."
 msgstr ""
 
 #. eBSCq
diff --git a/source/nl/helpcontent2/source/text/swriter/01.po b/source/nl/helpcontent2/source/text/swriter/01.po
index 221a20b6de0..0d2c7ab04a4 100644
--- a/source/nl/helpcontent2/source/text/swriter/01.po
+++ b/source/nl/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-27 15:55+0200\n"
+"POT-Creation-Date: 2020-05-25 20:00+0200\n"
 "PO-Revision-Date: 2019-12-24 16:18+0000\n"
 "Last-Translator: Henk van der Burg <h.vdburg@hccnet.nl>\n"
 "Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textswriter01/nl/>\n"
@@ -20275,14 +20275,14 @@ msgctxt ""
 msgid "Remaining space"
 msgstr "Nog beschikbare ruimte"
 
-#. 8BeLm
+#. xJdfF
 #: 05090200.xhp
 msgctxt ""
 "05090200.xhp\n"
 "par_id3154571\n"
 "help.text"
-msgid "<ahelp hid=\"modules/swriter/ui/tablecolumnpage/space-nospin\">Displays the amount of space that is available for adjusting the width of the columns. To set the width of the table, click the <emph>Table </emph>tab.</ahelp>"
-msgstr "<ahelp hid=\"modules/swriter/ui/tablecolumnpage/space-nospin\">Geeft de hoeveelheid ruimte weer die beschikbaar is voor het aanpassen van de breedte van de kolommen. Klik op de tab <emph>Tabel</emph> om de breedte van de tabel in te stellen.</ahelp>"
+msgid "<ahelp hid=\"modules/swriter/ui/tablecolumnpage/space\">Displays the amount of space that is available for adjusting the width of the columns. To set the width of the table, click the <emph>Table </emph>tab.</ahelp>"
+msgstr ""
 
 #. AmKDF
 #: 05090200.xhp