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

and force-fix errors using pocheck Change-Id: I1adc224071cce4a7e0b21209890b3777f9e2539b
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-05-27 13:41:26 +0200
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-05-27 13:51:17 +0200
commit: 13d55bb42d2f5617f568fd8b000e3d0c8bc4be6b (patch)
tree: 02b3b1e0eb9d8c674f39a80375f862a5565622ff /source/sq/helpcontent2
parent: 3d85ba95fa37f794cb08d0c4adce45621c1d8a4d (diff)
14 files changed, 1396 insertions, 752 deletions
diff --git a/source/sq/helpcontent2/source/auxiliary.po b/source/sq/helpcontent2/source/auxiliary.po
index d135bdf4a20..5c5d1b07b06 100644
--- a/source/sq/helpcontent2/source/auxiliary.po
+++ b/source/sq/helpcontent2/source/auxiliary.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:34+0200\n"
+"POT-Creation-Date: 2020-05-19 12:41+0200\n"
 "PO-Revision-Date: 2020-02-19 20:15+0000\n"
 "Last-Translator: Bela Toci <toci.bela@gmail.com>\n"
 "Language-Team: Albanian <https://weblate.documentfoundation.org/projects/libo_help-master/auxiliary/sq/>\n"
@@ -314,6 +314,24 @@ msgctxt ""
 msgid "General Information"
 msgstr "Informacion i Përgjithshëm"
 
+#. Q5EUA
+#: sdatabase.tree
+msgctxt ""
+"sdatabase.tree\n"
+"09\n"
+"help_section.text"
+msgid "Database Functionality (Base)"
+msgstr ""
+
+#. tLWiE
+#: sdatabase.tree
+msgctxt ""
+"sdatabase.tree\n"
+"0901\n"
+"node.text"
+msgid "General Information"
+msgstr ""
+
 #. xU49Q
 #: sdraw.tree
 msgctxt ""
@@ -665,24 +683,6 @@ msgctxt ""
 msgid "Guides"
 msgstr "Guidat"
 
-#. haknq
-#: shared.tree
-msgctxt ""
-"shared.tree\n"
-"09\n"
-"help_section.text"
-msgid "Database Functionality (Base)"
-msgstr "Funksionaliteti i Bazave të të Dhënave (Baza)"
-
-#. aHvBN
-#: shared.tree
-msgctxt ""
-"shared.tree\n"
-"0901\n"
-"node.text"
-msgid "General Information"
-msgstr "Informacion i Përgjithshëm"
-
 #. BjDNf
 #: simpress.tree
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/sbasic/shared.po b/source/sq/helpcontent2/source/text/sbasic/shared.po
index 0f6e8b02c4e..cdb3abbf113 100644
--- a/source/sq/helpcontent2/source/text/sbasic/shared.po
+++ b/source/sq/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: 2018-10-21 20:35+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5128,13 +5128,13 @@ msgctxt ""
 msgid "Pass Count"
 msgstr "Numwrimi i kalimeve:"
 
-#. 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>"
+msgid "<ahelp hid=\"modules/BasicIDE/ui/managebreakpoints/pass\">Specify the number of loops to perform before the breakpoint takes effect.</ahelp>"
 msgstr ""
 
 #. gr8LF
@@ -8188,67 +8188,58 @@ msgctxt ""
 msgid "Outputs the specified strings or numeric expressions to a dialog or to a file."
 msgstr ""
 
-#. QSTQ3
+#. AhB82
 #: 03010103.xhp
 msgctxt ""
 "03010103.xhp\n"
-"hd_id3145785\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaksa:"
+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[...]]"
+msgid "Print [#filenum,] expression1[{;|,} [Spc(number As Integer);] [Tab(pos As Integer);] [expression2[...]]"
 msgstr ""
 
-#. V7hQL
-#: 03010103.xhp
-msgctxt ""
-"03010103.xhp\n"
-"hd_id3147348\n"
-"help.text"
-msgid "Parameter:"
-msgstr "Parametri i sllajdit"
-
-#. 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."
+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."
+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."
+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."
+msgid "<emph>pos</emph>: Spaces are inserted until the specified position."
 msgstr ""
 
 #. GiAKc
@@ -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 ""
 
-#. AoqEt
-#: 03010103.xhp
-msgctxt ""
-"03010103.xhp\n"
-"hd_id3146912\n"
-"help.text"
-msgid "Example:"
-msgstr "Shembull"
-
 #. knWZh
 #: 03010200.xhp
 msgctxt ""
@@ -22255,13 +22237,13 @@ msgctxt ""
 msgid "Select...Case Statement"
 msgstr ""
 
-#. 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>"
+msgid "<bookmark_value>Select Case statement</bookmark_value>  <bookmark_value>Case keyword; in Select Case statement</bookmark_value>"
 msgstr ""
 
 #. CBpPz
@@ -22282,14 +22264,14 @@ msgctxt ""
 msgid "Defines one or more statement blocks depending on the value of an expression."
 msgstr ""
 
-#. M9zYG
+#. CFYkp
 #: 03090102.xhp
 msgctxt ""
 "03090102.xhp\n"
-"hd_id3147265\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaksa:"
+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,42 +22282,24 @@ msgctxt ""
 msgid "Select Case condition Case expression Statement Block [Case expression2 Statement Block][Case Else] Statement Block End Select"
 msgstr ""
 
-#. C5Bsm
-#: 03090102.xhp
-msgctxt ""
-"03090102.xhp\n"
-"hd_id3150767\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrat animues"
-
-#. 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."
+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>."
+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 ""
 
-#. CPxCt
-#: 03090102.xhp
-msgctxt ""
-"03090102.xhp\n"
-"hd_id3153768\n"
-"help.text"
-msgid "Example:"
-msgstr "Shembull"
-
 #. oCrpX
 #: 03090102.xhp
 msgctxt ""
@@ -23389,157 +23353,85 @@ msgctxt ""
 msgid "GoSub...Return Statement"
 msgstr ""
 
-#. xE9Hb
+#. EhtAB
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "bm_id3147242\n"
 "help.text"
-msgid "<bookmark_value>GoSub...Return statement</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>"
+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."
+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 ""
 
-#. tRYir
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3145609\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaksa:"
-
-#. zqBBG
+#. g6Wgg
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
 "par_id3145069\n"
 "help.text"
-msgid "see Parameters"
-msgstr "Parametrat animues"
-
-#. aPEyy
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3147265\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrat animues"
-
-#. dVLGt
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3148664\n"
-"help.text"
-msgid "Sub/Function"
-msgstr "Funksion eksponencial"
-
-#. bcX4L
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3150400\n"
-"help.text"
-msgid "statement block"
-msgstr "Shigjetat e bllokut"
-
-#. z8D4B
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3154140\n"
-"help.text"
-msgid "Label"
-msgstr "Emërtimi"
-
-#. uxiuj
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3150869\n"
-"help.text"
-msgid "statement block"
-msgstr "Shigjetat e bllokut"
-
-#. Nn3Bw
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3154909\n"
-"help.text"
-msgid "GoSub Label"
-msgstr "Teksti i etiketës"
-
-#. LSt3B
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"par_id3153969\n"
-"help.text"
-msgid "Exit Sub/Function"
-msgstr "**Tejmbushje e funksionit të katrorit**"
+msgid "GoSub label[:]"
+msgstr ""
 
-#. 62Fsi
+#. krBDs
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3154685\n"
+"par_id471588670859073\n"
 "help.text"
-msgid "Label:"
-msgstr "Etiketa:"
+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 "Shigjetat e bllokut"
+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 "Tipi i rikthimit"
+msgid "' statements"
+msgstr ""
 
-#. FyBNB
+#. hGEZe
 #: 03090301.xhp
 msgctxt ""
 "03090301.xhp\n"
-"par_id3154321\n"
+"bas_id421588670457589\n"
 "help.text"
-msgid "End Sub/Function"
-msgstr "**Tejmbushje e funksionit të katrorit**"
+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 (\":\")."
+msgid "' statements"
 msgstr ""
 
 #. X2mAh
@@ -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 ""
 
-#. VbwNL
-#: 03090301.xhp
-msgctxt ""
-"03090301.xhp\n"
-"hd_id3156284\n"
-"help.text"
-msgid "Example:"
-msgstr "Shembull"
-
 #. JXEq5
 #: 03090301.xhp
 msgctxt ""
@@ -23614,31 +23497,31 @@ msgctxt ""
 msgid "GoTo Statement"
 msgstr ""
 
-#. CyC3S
+#. MJeVf
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
 "bm_id3159413\n"
 "help.text"
-msgid "<bookmark_value>GoTo statement</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>"
+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."
+msgid "Continues program execution within a <literal>Sub</literal> or <literal>Function</literal> at the procedure line indicated by a label."
 msgstr ""
 
 #. MFgEA
@@ -23650,15 +23533,6 @@ msgctxt ""
 msgid "Syntax:"
 msgstr "Sintaksa:"
 
-#. yjD8B
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3154367\n"
-"help.text"
-msgid "see Parameters"
-msgstr "Parametrat animues"
-
 #. ziCip
 #: 03090302.xhp
 msgctxt ""
@@ -23668,105 +23542,69 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parametrat animues"
 
-#. qGGVZ
+#. KaSma
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3156424\n"
+"par_id471588670859073\n"
 "help.text"
-msgid "statement block"
-msgstr "Shigjetat e bllokut"
-
-#. cM4t6
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3154685\n"
-"help.text"
-msgid "Label1"
+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 ""
 
-#. B4ZCj
+#. YxYq5
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3145786\n"
+"par_id3152596\n"
 "help.text"
-msgid "<emph>Label2:</emph>"
+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 ""
 
-#. tw7DH
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id3161832\n"
-"help.text"
-msgid "statement block"
-msgstr "Shigjetat e bllokut"
-
-#. AF478
+#. 8o2aP
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3150010\n"
+"par_id3155416\n"
 "help.text"
-msgid "<emph>Label1:</emph>"
+msgid "You cannot use the <literal>GoTo</literal> statement to jump out of a <literal>Sub</literal> or <literal>Function</literal>."
 msgstr ""
 
-#. coe3B
+#. s9tCK
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3152462\n"
+"hd_id3154731\n"
 "help.text"
-msgid "statement block"
-msgstr "Shigjetat e bllokut"
+msgid "Example:"
+msgstr "Shembull"
 
-#. p22vt
+#. YN5FT
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3149664\n"
+"par_id3156424\n"
 "help.text"
-msgid "GoTo Label2"
+msgid "' statement block"
 msgstr ""
 
-#. yEZwo
+#. 4DWfG
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3152596\n"
+"par_id3161832\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 (\":\")."
+msgid "' statement block"
 msgstr ""
 
-#. 4SnXz
+#. FMGBa
 #: 03090302.xhp
 msgctxt ""
 "03090302.xhp\n"
-"par_id3155416\n"
+"par_id3152462\n"
 "help.text"
-msgid "You cannot use the GoTo statement to jump out of a Sub or Function."
+msgid "' statement block"
 msgstr ""
 
-#. s9tCK
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"hd_id3154731\n"
-"help.text"
-msgid "Example:"
-msgstr "Shembull"
-
-#. WAgYp
-#: 03090302.xhp
-msgctxt ""
-"03090302.xhp\n"
-"par_id6967035\n"
-"help.text"
-msgid "see Parameters"
-msgstr "Parametrat animues"
-
 #. GLei6
 #: 03090303.xhp
 msgctxt ""
@@ -23776,22 +23614,22 @@ msgctxt ""
 msgid "On...GoSub Statement; On...GoTo Statement"
 msgstr ""
 
-#. 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>"
+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>"
+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
@@ -23803,58 +23641,49 @@ msgctxt ""
 msgid "Branches to one of several specified lines in the program code, depending on the value of a numeric expression."
 msgstr ""
 
-#. wz57Y
+#. 7yAyG
 #: 03090303.xhp
 msgctxt ""
 "03090303.xhp\n"
-"hd_id3148798\n"
+"par_id841588605629842\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaksa:"
+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[,...]]]"
+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[,...]]]"
+msgid "On expression GoTo Label1[, Label2[, Label3[,...]]]"
 msgstr ""
 
-#. anrdF
-#: 03090303.xhp
-msgctxt ""
-"03090303.xhp\n"
-"hd_id3156215\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrat animues"
-
-#. 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)"
+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."
+msgid "<emph>label:</emph> Target line according to<emph> GoTo </emph>or <emph>GoSub</emph> structure."
 msgstr ""
 
 #. eqUXk
@@ -23866,15 +23695,6 @@ msgctxt ""
 msgid "The <emph>GoTo</emph> or <emph>GoSub </emph>conventions are valid."
 msgstr ""
 
-#. 9SqBY
-#: 03090303.xhp
-msgctxt ""
-"03090303.xhp\n"
-"hd_id3148645\n"
-"help.text"
-msgid "Example:"
-msgstr "Shembull"
-
 #. PtTux
 #: 03090303.xhp
 msgctxt ""
@@ -30697,31 +30517,31 @@ msgctxt ""
 msgid "' Copy of structs as value -> new instance"
 msgstr ""
 
-#. XZuoy
+#. hQzux
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "tit\n"
 "help.text"
-msgid "Erase Function"
+msgid "Erase Statement"
 msgstr ""
 
-#. dKRw9
+#. UwzDN
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
 "bm_id624713\n"
 "help.text"
-msgid "<bookmark_value>Erase function</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>"
+msgid "<link href=\"text/sbasic/shared/03104700.xhp\">Erase Statement</link>"
 msgstr ""
 
 #. xqtMK
@@ -30733,40 +30553,76 @@ msgctxt ""
 msgid "Erases the contents of array elements of fixed size arrays, and releases the memory used by arrays of variable size."
 msgstr ""
 
-#. QGwRF
+#. 3sXFq
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
-"par_idN1055D\n"
+"par_id831588865616326\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaksa:"
+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 "Fshi të dhëna:"
+msgid "Erase array1 [, array2 [,...]]"
+msgstr ""
 
-#. zfSit
+#. 8J4Ab
 #: 03104700.xhp
 msgctxt ""
 "03104700.xhp\n"
-"par_idN105E9\n"
+"par_idN105ED\n"
 "help.text"
-msgid "Parameters:"
-msgstr "Parametrat animues"
+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 "<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 "<emph>Arraylist</emph> - The list of arrays to be erased."
+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
@@ -38806,13 +38662,13 @@ 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 ""
 
-#. 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>"
+msgid "<link href=\"text/scalc/01/04060106.xhp#Section21\">Calc ROUND function</link>"
 msgstr ""
 
 #. 3ECTM
@@ -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/sq/helpcontent2/source/text/scalc/01.po b/source/sq/helpcontent2/source/text/scalc/01.po
index 4761abdbfee..3d03ac8a67a 100644
--- a/source/sq/helpcontent2/source/text/scalc/01.po
+++ b/source/sq/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: 2018-11-12 14:06+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5830,13 +5830,13 @@ 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 ""
 
-#. i8TkC
+#. DEtMa
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147427\n"
 "help.text"
-msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
+msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
 msgstr ""
 
 #. bA2pT
@@ -5920,13 +5920,13 @@ 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 ""
 
-#. 3n4Kb
+#. jD9JZ
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147363\n"
 "help.text"
-msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
+msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
 msgstr ""
 
 #. PsFjE
@@ -6019,13 +6019,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>"
 msgstr ""
 
-#. oHnfa
+#. yGdCf
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3159092\n"
 "help.text"
-msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis)"
+msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])"
 msgstr ""
 
 #. PKp6i
@@ -6127,13 +6127,13 @@ 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 ""
 
-#. uRZWP
+#. zFkiX
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3147074\n"
 "help.text"
-msgid "ACCRINTM(Issue; Settlement; Rate; Par; Basis)"
+msgid "ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])"
 msgstr ""
 
 #. pTobQ
@@ -6334,13 +6334,13 @@ 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 ""
 
-#. BVQTK
+#. uiDaD
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3150395\n"
 "help.text"
-msgid "PV(Rate; NPer; Pmt; FV; Type)"
+msgid "PV(Rate; NPer; Pmt[; FV][; Type])"
 msgstr ""
 
 #. JrCA6
@@ -7360,13 +7360,13 @@ 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 ""
 
-#. GnhjW
+#. EV3DT
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3166452\n"
 "help.text"
-msgid "DDB(Cost; Salvage; Life; Period; Factor)"
+msgid "DDB(Cost; Salvage; Life; Period[; Factor])"
 msgstr ""
 
 #. VKnDB
@@ -7468,13 +7468,13 @@ 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 ""
 
-#. zaXLw
+#. EDXF8
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3153349\n"
 "help.text"
-msgid "DB(Cost; Salvage; Life; Period; Month)"
+msgid "DB(Cost; Salvage; Life; Period[; Month])"
 msgstr ""
 
 #. caSta
@@ -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 ""
 
-#. CCfhc
+#. zWTAW
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3155427\n"
 "help.text"
-msgid "IRR(Values; Guess)"
-msgstr "Ndrysho vlerat standarde"
+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 ""
 
-#. P9UHc
+#. RWBPC
 #: 04060104.xhp
 msgctxt ""
 "04060104.xhp\n"
 "par_id3147355\n"
 "help.text"
-msgid "CELL(\"InfoType\"; Reference)"
-msgstr "Emri i tabelarit të referencës së qelisë."
+msgid "CELL(\"InfoType\"[; Reference])"
+msgstr ""
 
 #. wjBKt
 #: 04060104.xhp
@@ -10195,13 +10195,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_WENN\">Specifies a logical test to be performed.</ahelp>"
 msgstr ""
 
-#. QQdtE
+#. qT9mo
 #: 04060105.xhp
 msgctxt ""
 "04060105.xhp\n"
 "par_id3154558\n"
 "help.text"
-msgid "IF(Test; ThenValue; OtherwiseValue)"
+msgid "IF(Test[; ThenValue][; OtherwiseValue])"
 msgstr ""
 
 #. JnjcT
@@ -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 ""
 
-#. Q6BXr
+#. EDmeN
 #: func_weekday.xhp
 msgctxt ""
 "func_weekday.xhp\n"
 "par_id3149033\n"
 "help.text"
-msgid "WEEKDAY(Number; Type)"
-msgstr "Zgjedh tipin e dokumentit"
+msgid "WEEKDAY(Number[; Type])"
+msgstr ""
 
 #. mcF52
 #: func_weekday.xhp
@@ -63808,13 +63808,13 @@ 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)"
+msgid "WORKDAY.INTL(StartDate; Days[; Weekend][; Holidays])"
 msgstr ""
 
 #. gJg5G
@@ -63979,13 +63979,13 @@ 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 ""
 
-#. gSoD4
+#. fo6sg
 #: func_workday.xhp
 msgctxt ""
 "func_workday.xhp\n"
 "par_id3154844\n"
 "help.text"
-msgid "WORKDAY(StartDate; Days; Holidays)"
+msgid "WORKDAY(StartDate; Days[; Holidays])"
 msgstr ""
 
 #. 35EG5
@@ -64168,13 +64168,13 @@ 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 ""
 
-#. C3aRF
+#. AASCJ
 #: func_yearfrac.xhp
 msgctxt ""
 "func_yearfrac.xhp\n"
 "par_id3155823\n"
 "help.text"
-msgid "YEARFRAC(StartDate; EndDate; Basis)"
+msgid "YEARFRAC(StartDate; EndDate[; Basis])"
 msgstr ""
 
 #. JAA8u
@@ -64339,13 +64339,13 @@ msgctxt ""
 msgid "Solver"
 msgstr ""
 
-#. 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>"
+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
@@ -64357,130 +64357,229 @@ msgctxt ""
 msgid "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Solver</link></variable>"
 msgstr ""
 
-#. 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>"
+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 ""
 
-#. ivjGw
+#. 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 ""
+
+#. 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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+msgid "<ahelp hid=\".\">Enter the cell range that can be changed.</ahelp> These are the variables of the equations."
 msgstr ""
 
-#. o7jUm
+#. 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 ""
+
+#. YApta
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
 "par_id9183935\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter a cell reference.</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>"
+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>"
+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>"
+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>"
+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>"
+msgid "<ahelp hid=\".\">Opens the <link href=\"text/scalc/01/solver_options.xhp#solveroptionsh1\" name=\"solveroptions\">Solver Options</link> dialog.</ahelp>"
 msgstr ""
 
-#. ssqdF
+#. 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 ""
+
+#. 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>"
+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
@@ -64519,121 +64618,769 @@ 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 ""
 
-#. bZZnv
+#. irGoh
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id0603200910430882\n"
+"help.text"
+msgid "Using Non-Linear solvers"
+msgstr ""
+
+#. UTzzV
 #: solver.xhp
 msgctxt ""
 "solver.xhp\n"
-"par_id5323953\n"
+"par_id0603200910430845\n"
 "help.text"
-msgid "The default solver engine supports only linear equations."
+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 ""
 
-#. dAcyJ
+#. 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 "Opcionet"
+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 "Opcionet"
+msgid "<variable id=\"solveroptionsh1\"><link href=\"text/scalc/01/solver_options.xhp\" name=\"Solver  Options\">Solver Options</link></variable>"
+msgstr ""
+
+#. LHgS8
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"par_id3163853\n"
+"help.text"
+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 ""
 
-#. 4v4nE
+#. gE7WZ
 #: solver_options.xhp
 msgctxt ""
 "solver_options.xhp\n"
-"par_id6776940\n"
+"hd_id581589922716672\n"
 "help.text"
-msgid "The Options dialog for the <link href=\"text/scalc/01/solver.xhp\">Solver</link> is used to set some options."
+msgid "Solver engine"
 msgstr ""
 
-#. 8D7tG
+#. 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>"
+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>"
+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>"
+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>"
+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."
+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."
+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."
+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."
+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."
+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
diff --git a/source/sq/helpcontent2/source/text/sdatabase.po b/source/sq/helpcontent2/source/text/sdatabase.po
new file mode 100644
index 00000000000..bcb78a91063
--- /dev/null
+++ b/source/sq/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/sq/helpcontent2/source/text/shared/00.po b/source/sq/helpcontent2/source/text/shared/00.po
index 3cf46a5eafb..35a80016a1c 100644
--- a/source/sq/helpcontent2/source/text/shared/00.po
+++ b/source/sq/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: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\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,24 +4237,42 @@ msgctxt ""
 msgid "OpenOffice.org 3, StarOffice 9, Oracle Open Office"
 msgstr ""
 
-#. vD7AT
+#. yDRTc
 #: 00000021.xhp
 msgctxt ""
 "00000021.xhp\n"
-"par_id1001200912381153\n"
+"par_id1001200912381154\n"
 "help.text"
-msgid "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 ""
 
+#. 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
 msgctxt ""
@@ -4246,22 +4282,58 @@ msgctxt ""
 msgid "OpenOffice.org 3.2 or StarOffice 9.2"
 msgstr "OpenOffice.org 3.2 ose 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."
+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
@@ -8539,13 +8611,13 @@ 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 ""
 
-#. 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>"
+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
diff --git a/source/sq/helpcontent2/source/text/shared/01.po b/source/sq/helpcontent2/source/text/shared/01.po
index af0615d410f..88cd74c5163 100644
--- a/source/sq/helpcontent2/source/text/shared/01.po
+++ b/source/sq/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: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3742,166 +3742,184 @@ 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 ""
 
-#. EZWri
+#. gCAE7
 #: 01100400.xhp
 msgctxt ""
 "01100400.xhp\n"
 "hd_id3153311\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Cells:</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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+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>"
+msgid "<ahelp hid=\"modules/swriter/ui/statisticsinfopage/update\">Updates the statistics.</ahelp>"
 msgstr ""
 
 #. HpTwh
@@ -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 "Gjuhë"
 
-#. 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 ""
 
-#. wf4vi
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3148739\n"
-"help.text"
-msgid "_self"
-msgstr ""
-
 #. E9CvG
 #: 05020400.xhp
 msgctxt ""
@@ -19771,15 +19780,6 @@ msgctxt ""
 msgid "File opens in the current frame."
 msgstr ""
 
-#. PdCyG
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3151210\n"
-"help.text"
-msgid "_blank"
-msgstr "Sllajd i zbrazët"
-
 #. Kv599
 #: 05020400.xhp
 msgctxt ""
@@ -19789,15 +19789,6 @@ msgctxt ""
 msgid "File opens in a new page."
 msgstr ""
 
-#. GhVRg
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3148451\n"
-"help.text"
-msgid "_parent"
-msgstr ""
-
 #. 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 ""
 
-#. FP7B6
-#: 05020400.xhp
-msgctxt ""
-"05020400.xhp\n"
-"par_id3154153\n"
-"help.text"
-msgid "_top"
-msgstr "Lartë"
-
 #. 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 ""
 
-#. 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 ""
-
 #. EEgg6
 #: 05040200.xhp
 msgctxt ""
@@ -44872,13 +44845,13 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/notebook_bar.xhp\">Using the notebook bar</link>"
 msgstr ""
 
-#. 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>"
+msgid "<ahelp hid=\".\">The notebook bar is a new form of displaying commands icons for a quicker usage.</ahelp>"
 msgstr ""
 
 #. roAUi
@@ -44908,22 +44881,22 @@ 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 ""
 
-#. 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."
+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>"
+msgid "Choose menu <menuitem>View - User Interface</menuitem>"
 msgstr ""
 
 #. SJiku
@@ -45052,13 +45025,13 @@ msgctxt ""
 msgid "The Tabbed and Groupedbar modes are also available as compact variants."
 msgstr ""
 
-#. 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."
+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
@@ -45070,13 +45043,13 @@ msgctxt ""
 msgid "The notebook bar cannot be customized."
 msgstr ""
 
-#. 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."
+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
@@ -45088,6 +45061,15 @@ msgctxt ""
 msgid "<link href=\"text/shared/guide/floating_toolbar.xhp\">Toolbars</link>"
 msgstr ""
 
+#. 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/sq/helpcontent2/source/text/shared/06.po b/source/sq/helpcontent2/source/text/shared/06.po
index 103ece77826..0662e715809 100644
--- a/source/sq/helpcontent2/source/text/shared/06.po
+++ b/source/sq/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: 2018-09-03 13:27+0000\n"
 "Last-Translator: Anonymous Pootle User\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/sq/helpcontent2/source/text/shared/explorer/database.po b/source/sq/helpcontent2/source/text/shared/explorer/database.po
index e63f8d8d976..7256d5c25e2 100644
--- a/source/sq/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/sq/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: 2018-11-12 14:07+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -6568,13 +6568,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\">The database file window organizes the tables, views, queries, and reports of a database in %PRODUCTNAME.</ahelp>"
 msgstr ""
 
-#. 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>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
 msgstr ""
 
 #. ptEgp
@@ -8674,22 +8674,22 @@ msgctxt ""
 msgid "<link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link>"
 msgstr ""
 
-#. QCKtt
+#. Y4EFA
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "tit\n"
 "help.text"
-msgid "MySQL Connection"
-msgstr "Gjendja e lidhjes"
+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 ""
 
-#. cLmBi
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"tit\n"
-"help.text"
-msgid "%PRODUCTNAME Database"
-msgstr "%PRODUCTNAME fajll i databazës"
-
-#. 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 ""
-
-#. 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 ""
-
-#. 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 "Të gjithë fajllat (*.*)"
-
-#. U7fFX
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id3786736\n"
-"help.text"
-msgid "Text files"
-msgstr "Importo fajlet tekstuale"
-
-#. WPAC3
-#: main.xhp
-msgctxt ""
-"main.xhp\n"
-"par_id6747337\n"
-"help.text"
-msgid "Address book data"
-msgstr "Të dhëna të adresave LDAP"
-
-#. 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 ""
-
 #. rw2xT
 #: menubar.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/shared/guide.po b/source/sq/helpcontent2/source/text/shared/guide.po
index 8d5a9c82d5b..9929f51105c 100644
--- a/source/sq/helpcontent2/source/text/shared/guide.po
+++ b/source/sq/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: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5344,42 +5344,6 @@ msgctxt ""
 msgid "MOV - QuickTime File Format"
 msgstr ""
 
-#. VSUDs
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter54\n"
-"help.text"
-msgid "Macromedia Flash (SWF)"
-msgstr ""
-
-#. ojK6F
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter55\n"
-"help.text"
-msgid "None"
-msgstr ""
-
-#. SqSpc
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter57\n"
-"help.text"
-msgid "Macromedia Flash (SWF)"
-msgstr ""
-
-#. 3D8p5
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_graphicfilter58\n"
-"help.text"
-msgid "None"
-msgstr ""
-
 #. oAAov
 #: convertfilters.xhp
 msgctxt ""
@@ -8251,13 +8215,13 @@ msgctxt ""
 msgid "<variable id=\"database_main\"><link href=\"text/shared/guide/database_main.xhp\" name=\"Data Source Overview\">Database Overview</link></variable>"
 msgstr ""
 
-#. 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>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
 msgstr ""
 
 #. VPAta
@@ -16801,13 +16765,13 @@ msgctxt ""
 msgid "Data Sources"
 msgstr "Burimet e të dhënave"
 
-#. 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>"
+msgid "<link href=\"text/sdatabase/main.xhp\">Working with databases in %PRODUCTNAME</link>"
 msgstr ""
 
 #. CGeKT
@@ -23308,13 +23272,13 @@ msgctxt ""
 msgid "<emph>Math Formula</emph> opens %PRODUCTNAME <link href=\"text/smath/main0000.xhp\">Math</link>"
 msgstr ""
 
-#. 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>"
+msgid "<emph>Base Database</emph> opens %PRODUCTNAME <link href=\"text/sdatabase/main.xhp\">Base</link>"
 msgstr ""
 
 #. MvEcH
diff --git a/source/sq/helpcontent2/source/text/shared/optionen.po b/source/sq/helpcontent2/source/text/shared/optionen.po
index 9850a2804e6..ea03dd722ca 100644
--- a/source/sq/helpcontent2/source/text/shared/optionen.po
+++ b/source/sq/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: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1078,58 +1078,67 @@ msgctxt ""
 msgid "ODF format version"
 msgstr "Ruaj versionin e ri"
 
-#. 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."
+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."
+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."
+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."
+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>"
+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."
+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
diff --git a/source/sq/helpcontent2/source/text/simpress/01.po b/source/sq/helpcontent2/source/text/simpress/01.po
index 372fbadc123..b1b267a3fbd 100644
--- a/source/sq/helpcontent2/source/text/simpress/01.po
+++ b/source/sq/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: 2018-09-03 13:27+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -25,13 +25,13 @@ msgctxt ""
 msgid "Export"
 msgstr "Eksporto"
 
-#. 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>"
+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
@@ -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 ""
-
 #. oyYNp
 #: 01170000.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/simpress/guide.po b/source/sq/helpcontent2/source/text/simpress/guide.po
index 6b70fab93d3..2ed7a8e6166 100644
--- a/source/sq/helpcontent2/source/text/simpress/guide.po
+++ b/source/sq/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: 2018-09-03 13:27+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -340,13 +340,13 @@ msgctxt ""
 msgid "To create an animated GIF:"
 msgstr "Dështoi në krijimin e filesistemit"
 
-#. 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>."
+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
diff --git a/source/sq/helpcontent2/source/text/swriter.po b/source/sq/helpcontent2/source/text/swriter.po
index 95b75e7df7e..09bad9ee33d 100644
--- a/source/sq/helpcontent2/source/text/swriter.po
+++ b/source/sq/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: 2018-10-21 20:35+0000\n"
 "Last-Translator: Anonymous Pootle User\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/sq/helpcontent2/source/text/swriter/01.po b/source/sq/helpcontent2/source/text/swriter/01.po
index e0b4bcaddf0..d5803e20851 100644
--- a/source/sq/helpcontent2/source/text/swriter/01.po
+++ b/source/sq/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: 2018-10-21 20:35+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -20275,13 +20275,13 @@ msgctxt ""
 msgid "Remaining space"
 msgstr "Hapësira e mbetur"
 
-#. 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>"
+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
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-05-27 13:41:26 +0200
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-05-27 13:51:17 +0200
commit	13d55bb42d2f5617f568fd8b000e3d0c8bc4be6b (patch)
tree	02b3b1e0eb9d8c674f39a80375f862a5565622ff /source/sq/helpcontent2
parent	3d85ba95fa37f794cb08d0c4adce45621c1d8a4d (diff)