update translations for master

and force-fix errors using pocheck

Change-Id: I95203f89a4148dd4f91a2a438c5c9811ac2dbe44

6 files changed, 261 insertions, 639 deletions

diff --git a/source/om/helpcontent2/source/text/sbasic/shared.po b/source/om/helpcontent2/source/text/sbasic/shared.po
index d7e834dcfdf..ab9d04c3a49 100644
--- a/source/om/helpcontent2/source/text/sbasic/shared.po
+++ b/source/om/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-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-07 17:18+0200\n"
 "PO-Revision-Date: 2018-10-21 20:29+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -609,6 +609,15 @@ msgctxt ""
 msgid "<variable id=\"functexample\">Example:</variable>"
 msgstr ""
 
+#. TV2YL
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id161599082457466\n"
+"help.text"
+msgid "<variable id=\"stringfunctions\"><link href=\"text/sbasic/shared/03120300.xhp\" name=\"string functions\">String functions</link></variable>"
+msgstr ""
+
 #. CGSvh
 #: 00000003.xhp
 msgctxt ""
@@ -2418,14 +2427,23 @@ msgctxt ""
 msgid "String Variables"
 msgstr "Jijjiiramaawwan diraa"
 
-#. ft56J
+#. zes9e
 #: 01020100.xhp
 msgctxt ""
 "01020100.xhp\n"
 "par_id3151393\n"
 "help.text"
-msgid "String variables can hold character strings with up to 65,535 characters. Each character is stored as the corresponding Unicode value. String variables are suitable for word processing within programs and for temporary storage of any non-printable character up to a maximum length of 64 Kbytes. The memory required for storing string variables depends on the number of characters in the variable. The type-declaration character is \"$\"."
-msgstr "Jijjiiramaawwan diraa diraawwan arfii hanga arfiilee 65,535ti ni qabata. Jijjiiramaawwan diraa hojii jecha sagantaalee fi kuusaa yeroo kan arfii maxxansamuu hin dandeenye hanga dheerina alaantoo baayitiisi 64tiif mijataadha. Yaadduuun lakkoofsa  arfiilee jijjiiramaa irratti hundaa`uudhaan jijjiiramaawwan diraa olkaa`uuf ni barbaachisa. Arfii ibsa akaakuu \"$\" dha."
+msgid "String variables can hold character strings with up to 2,147,483,648 characters. Each character is stored as the corresponding Unicode value. String variables are suitable for word processing within programs and for temporary storage of any non-printable character up to a maximum length of 2 Gbytes. The memory required for storing string variables depends on the number of characters in the variable. The type-declaration character is \"$\"."
+msgstr ""
+
+#. RBcLt
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id381599081637549\n"
+"help.text"
+msgid "In BASIC String functions, the first character of the string has index 1."
+msgstr ""
 
 #. wDbuF
 #: 01020100.xhp
@@ -16548,86 +16566,41 @@ msgctxt ""
 msgid "The following functions and statements set or return the system date and time."
 msgstr "Himoonni fi faankishiniin armaan gadii sirna guyyaa deebisu ykn olkaa'u."
 
-#. YWfEf
+#. wJjQV
 #: 03030301.xhp
 msgctxt ""
 "03030301.xhp\n"
 "tit\n"
 "help.text"
-msgid "Date Statement"
+msgid "Date Function"
 msgstr ""
 
-#. xpFBx
+#. HEEFx
 #: 03030301.xhp
 msgctxt ""
 "03030301.xhp\n"
 "bm_id3156027\n"
 "help.text"
-msgid "<bookmark_value>Date statement</bookmark_value>"
-msgstr "<bookmark_value>Hima Guyyaa </bookmark_value>"
+msgid "<bookmark_value>Date function</bookmark_value>"
+msgstr ""
 
-#. vDWSN
+#. u9AkG
 #: 03030301.xhp
 msgctxt ""
 "03030301.xhp\n"
 "hd_id3156027\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03030301.xhp\" name=\"Date Statement\">Date Statement</link>"
+msgid "<link href=\"text/sbasic/shared/03030301.xhp\" name=\"Date Function\">Date Function</link>"
 msgstr ""
 
-#. GMwEL
+#. AaA3G
 #: 03030301.xhp
 msgctxt ""
 "03030301.xhp\n"
 "par_id3147291\n"
 "help.text"
-msgid "Returns the current system date as a string, or resets the date. The date format depends on your local system settings."
-msgstr "Sirna diraan guyyaa ammaa deebisi ykn guyyaa haromsi.Akkataan guyyaa sirna yoomessa  keessaa kee irratti hundaa'a."
-
-#. CUY3q
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3148686\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
-#. QoCJW
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"par_id3146794\n"
-"help.text"
-msgid "Date ; Date = Text As String"
-msgstr "Date ; Date = Text As String"
-
-#. 8QFeW
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
-#. 57eNx
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"par_id3145069\n"
-"help.text"
-msgid "<emph>Text:</emph> Only required in order to reset the system date. In this case, the string expression must correspond to the date format defined in your local settings."
-msgstr "<emph>Text:</emph> Sirna guyyaa qofa haaromsuuf gaafatama. Haala kanaan,himamsi diraanii akkaataa guyyaa keesaa yomessattiin wal gituu qaba."
-
-#. waEYM
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3150793\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
+msgid "Returns the current system date as a string, or date variant."
+msgstr ""
 
 #. BUc3C
 #: 03030301.xhp
@@ -16638,31 +16611,31 @@ msgctxt ""
 msgid "MsgBox \"The date is \" & Date"
 msgstr "msgbox \"Guyyaan \" & Date"
 
-#. CCirC
+#. W99bB
 #: 03030302.xhp
 msgctxt ""
 "03030302.xhp\n"
 "tit\n"
 "help.text"
-msgid "Time Statement"
+msgid "Time Function"
 msgstr ""
 
-#. Ypbnk
+#. peCLU
 #: 03030302.xhp
 msgctxt ""
 "03030302.xhp\n"
 "bm_id3145090\n"
 "help.text"
-msgid "<bookmark_value>Time statement</bookmark_value>"
-msgstr "<bookmark_value>Hima Yeroo</bookmark_value>"
+msgid "<bookmark_value>Time function</bookmark_value>"
+msgstr ""
 
-#. xLpG8
+#. tBoRS
 #: 03030302.xhp
 msgctxt ""
 "03030302.xhp\n"
 "hd_id3145090\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03030302.xhp\">Time Statement</link>"
+msgid "<link href=\"text/sbasic/shared/03030302.xhp\" name=\"Time Function\">Time Function</link>"
 msgstr ""
 
 #. FHKSk
@@ -16674,42 +16647,6 @@ msgctxt ""
 msgid "This function returns the current system time as a string in the format \"HH:MM:SS\"."
 msgstr "Faankishinin kun sirna diraan yeroo ammaa haala kanaan \"HH:MM:SS\" deebisa."
 
-#. G29nS
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3154346\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
-#. rG5UZ
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3150792\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
-#. 6LxaE
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"par_id3149656\n"
-"help.text"
-msgid "<emph>Text:</emph> Any string expression that specifies the new time in the format \"HH:MM:SS\"."
-msgstr "<emph>Text:</emph> Diraan kammiyyuu yeroo haraa ibsuuf haala kanaan  \"HH:MM:SS\" ta'a."
-
-#. psu4B
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3145173\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. Aguz5
 #: 03030302.xhp
 msgctxt ""
@@ -22290,15 +22227,6 @@ msgctxt ""
 msgid "Returns one of two possible function results, depending on the logical value of the evaluated expression."
 msgstr "Gatii Yaayaa himannoo madaalame irratti hundaa'itii, bu'aa faankishinii lamaan danda'amu keessa tokko deebisi."
 
-#. DMbgx
-#: 03090103.xhp
-msgctxt ""
-"03090103.xhp\n"
-"hd_id3159413\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. dDDFQ
 #: 03090103.xhp
 msgctxt ""
@@ -22308,15 +22236,6 @@ msgctxt ""
 msgid "IIf (Expression, ExpressionTrue, ExpressionFalse)"
 msgstr "IIf (Expression, ExpressionTrue, ExpressionFalse)"
 
-#. Jr9BS
-#: 03090103.xhp
-msgctxt ""
-"03090103.xhp\n"
-"hd_id3150541\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. TXHsN
 #: 03090103.xhp
 msgctxt ""
@@ -22335,6 +22254,33 @@ msgctxt ""
 msgid "<emph>ExpressionTrue, ExpressionFalse:</emph> Any expression, one of which will be returned as the function result, depending on the logical evaluation."
 msgstr "<emph>HimannooDhugaa, HimannooSoba:</emph> Himannoo kamuu,tokkoon isaa akka bu'aa faankishiniitti deebi'u, yaayaa madaalli irratti hundaa'a."
 
+#. iEQga
+#: 03090103.xhp
+msgctxt ""
+"03090103.xhp\n"
+"par_id541598638231139\n"
+"help.text"
+msgid "IIf evaluates both <literal>ExpressionTrue</literal> and <literal>ExpressionFalse</literal> even if it returns only one of them. If one of the expressions results in error, the function returns the error. For example, do not use IIF to bypass a possible division by zero result."
+msgstr ""
+
+#. vGAma
+#: 03090103.xhp
+msgctxt ""
+"03090103.xhp\n"
+"par_id1001598638460925\n"
+"help.text"
+msgid "REM Returns the maximum of 3 values"
+msgstr ""
+
+#. 9JAJ5
+#: 03090103.xhp
+msgctxt ""
+"03090103.xhp\n"
+"par_id161598638840133\n"
+"help.text"
+msgid "REM Bad usage of function IIf"
+msgstr ""
+
 #. dNxFE
 #: 03090103.xhp
 msgctxt ""
@@ -31452,13 +31398,13 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. gunCB
+#. nYDuW
 #: 03120201.xhp
 msgctxt ""
 "03120201.xhp\n"
 "par_id3143228\n"
 "help.text"
-msgid "<emph>n:</emph> Numeric expression that defines the number of spaces in the string. The maximum allowed value of <emph>n</emph> is 65535."
+msgid "<emph>n:</emph> Numeric expression that defines the number of spaces in the string. The maximum allowed value of <emph>n</emph> is 2,147,483,648."
 msgstr ""
 
 #. xfAcE
@@ -31506,15 +31452,6 @@ msgctxt ""
 msgid "Creates a string according to the specified character, or the first character of a string expression that is passed to the function."
 msgstr "Akkaataa arfii ibsameen ,ykn arfii jalqabaa himata diraa kan faankishinichatti darbeetiin diraa uuma."
 
-#. YEQWe
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. EVKUs
 #: 03120202.xhp
 msgctxt ""
@@ -31524,15 +31461,6 @@ msgctxt ""
 msgid "String (n As Long, {expression As Integer | character As String})"
 msgstr "String (n As Long, {expression As Integer | character As String})"
 
-#. Uaxak
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3143270\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. GfqGg
 #: 03120202.xhp
 msgctxt ""
@@ -31542,23 +31470,14 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. 5gnCP
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3154923\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
-#. xvDy5
+#. FTqT4
 #: 03120202.xhp
 msgctxt ""
 "03120202.xhp\n"
 "par_id3154347\n"
 "help.text"
-msgid "<emph>n:</emph> Numeric expression that indicates the number of characters to return in the string. The maximum allowed value of n is 65535."
-msgstr "<emph>n:</emph> Himata lakkoofsaa kan baay'ina arfiilee diraa keessatti deebi'anii agarsiisa. Gatiin guddaan n, 65535 dha."
+msgid "<emph>n:</emph> Numeric expression that indicates the number of characters to return in the string. The maximum allowed value of n is 2,147,483,648."
+msgstr ""
 
 #. uARjD
 #: 03120202.xhp
@@ -31578,15 +31497,6 @@ msgctxt ""
 msgid "<emph>Character:</emph> Any single character used to build the return string, or any string of which only the first character will be used."
 msgstr "<emph>Arfii:</emph>Arfii qeenxee kamiyyuu kan diraa deebii ijaaruuf fayyade, ykn diraa kamiyyuu kan arfiin duraa isaa fayyadu dha."
 
-#. iApAt
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3152920\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. avFC9
 #: 03120300.xhp
 msgctxt ""
@@ -31659,15 +31569,6 @@ msgctxt ""
 msgid "Converts a number to a string, and then formats it according to the format that you specify."
 msgstr "Lakkoofsa gara diraatti jijjiiree,dhangii ati fayyadamteen lakkoofsicha dhangi'a."
 
-#. ESujY
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3145090\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. wp4Ae
 #: 03120301.xhp
 msgctxt ""
@@ -31677,15 +31578,6 @@ msgctxt ""
 msgid "Format (Number [, Format As String])"
 msgstr "Format (Number [, Format As String])"
 
-#. SrkYm
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3149178\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. gddga
 #: 03120301.xhp
 msgctxt ""
@@ -31695,15 +31587,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. WGjGQ
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3159176\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. 6Dyxg
 #: 03120301.xhp
 msgctxt ""
@@ -31983,15 +31866,6 @@ msgctxt ""
 msgid "A format code can be divided into three sections that are separated by semicolons. The first part defines the format for positive values, the second part for negative values, and the third part for zero. If you only specify one format code, it applies to all numbers."
 msgstr "Lakkaddaan dhangiisuu kutaa sadi kanneen buufata xiqqaadhaan addaan bahanitti qoodamuu danda'a. Kutaan duraa dhangiisuu gatiiwwan poozatiivii, inni lammataan dhangiisuu gatiiwwan nagatiivii fi inni sadaffaan Zeeroodhaafi. Yoo lakkaddaa dhangiisuu tokko qofaa ibsite, lakkoofsota hundaaf raawwachuu ni danda'a."
 
-#. GXmDT
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3149019\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. ZsNPC
 #: 03120301.xhp
 msgctxt ""
@@ -32145,15 +32019,6 @@ msgctxt ""
 msgid "Returns the number of leftmost characters that you specify of a string expression."
 msgstr "Baay'ina arfiilee Moggaa bitaa kanneen himata diraa ibsan deebisa."
 
-#. UF45c
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3156153\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. H2Ftq
 #: 03120303.xhp
 msgctxt ""
@@ -32163,15 +32028,6 @@ msgctxt ""
 msgid "Left (Text As String, n As Long)"
 msgstr "Left (Text As String, n As Long)"
 
-#. 48Gmp
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3153824\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. to74m
 #: 03120303.xhp
 msgctxt ""
@@ -32181,15 +32037,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. ZJXfA
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3148946\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. hRWZH
 #: 03120303.xhp
 msgctxt ""
@@ -32199,14 +32046,14 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to return the leftmost characters from."
 msgstr "<emph>Barruu:</emph> Himata diraa kanneen arfiilee moggaa bitaa irraa deebisuuf barbaaddu dha."
 
-#. jVzCK
+#. BPXpD
 #: 03120303.xhp
 msgctxt ""
 "03120303.xhp\n"
 "par_id3149456\n"
 "help.text"
-msgid "<emph>n:</emph> Numeric expression that specifies the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 65535."
-msgstr "<emph>n:</emph> Himata lakkoofsaa kan baay'ina arfiilee akka deebi'an barbaadduu ibsa. Yoo <emph>n</emph> = 0 ta'e, Diraa dheerinni isaa zeeroo ta'etu deebi'a. Gatii eeyyamamaa inni guddaan 65535 dha."
+msgid "<emph>n:</emph> Numeric expression that specifies the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 2,147,483,648."
+msgstr ""
 
 #. FPXvk
 #: 03120303.xhp
@@ -32217,15 +32064,6 @@ msgctxt ""
 msgid "The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format."
 msgstr "Fakkeenyi armaan gadii haala guyyaa bifa YYYY.MM.DD irraa gara bifa MM/DD/YYYY tti jijjiira."
 
-#. YQQDH
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3125863\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. TJBfC
 #: 03120303.xhp
 msgctxt ""
@@ -32271,15 +32109,6 @@ msgctxt ""
 msgid "Aligns a string to the left of a string variable, or copies a variable of a user-defined type to another variable of a different user-defined type."
 msgstr "Diraa gara bitaa jijjiirama diraatti hiriirsisa, ykn jijjiramaa akaakuu hiika fayyadamaa tokkoo gara jijjiramaa akaakuu hiika fayyadamaa biraatti garagalcha."
 
-#. wKtHD
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3145317\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. tFaav
 #: 03120304.xhp
 msgctxt ""
@@ -32289,15 +32118,6 @@ msgctxt ""
 msgid "LSet Var As String = Text or LSet Var1 = Var2"
 msgstr "LSet Var As String = Text or LSet Var1 = Var2"
 
-#. 2vzrB
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3143271\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. M99uG
 #: 03120304.xhp
 msgctxt ""
@@ -32343,15 +32163,6 @@ msgctxt ""
 msgid "If the string is shorter than the string variable, <emph>LSet</emph> left-aligns the string within the string variable. Any remaining positions in the string variable are replaced by spaces. If the string is longer than the string variable, only the leftmost characters up to the length of the string variable are copied. With the <emph>LSet</emph> statement, you can also copy a user-defined type variable to another variable of the same type."
 msgstr "Yoo diraan jijjiirama diraarra gabaabaa ta'e,  <emph>LSet</emph> 'n diraa jijjiirama diraa keessaa bitaarratti hiriirsisa. Bakki jijjiirama diraa keessatti hafe kamiyyuu iddoo duwwaadhaan bakka bu'amu. Yoo diraan jijjiiramaa diraarra dheeraa ta'e, arfiiwwan moggaa bitaa haga dheerina jijjiramaa diraatti jiran qofti ni garagalfamu. Hima <emph>LSet</emph> tiin, akaakuu jijjiiramaa hiika fayyadamaa tokko gara jijjiiramaa akaakuu gosa tokkootti garagalchuu ni dandeessa."
 
-#. BQw4P
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3156282\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. jJepi
 #: 03120304.xhp
 msgctxt ""
@@ -32415,15 +32226,6 @@ msgctxt ""
 msgid "Removes all leading spaces at the start of a string expression."
 msgstr "Iddoowwan duraa mara  jalqaba himata diraarra jiran haqa."
 
-#. vG8YP
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3154924\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. cepxM
 #: 03120305.xhp
 msgctxt ""
@@ -32433,15 +32235,6 @@ msgctxt ""
 msgid "LTrim (Text As String)"
 msgstr "LTrim (Text As String)"
 
-#. KzzDh
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3156344\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. LyUCE
 #: 03120305.xhp
 msgctxt ""
@@ -32451,15 +32244,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. 8hNZD
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3150543\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. x85WJ
 #: 03120305.xhp
 msgctxt ""
@@ -32478,15 +32262,6 @@ msgctxt ""
 msgid "Use this function to remove spaces at the beginning of a string expression."
 msgstr "Iddoo jalqaba himata diraarra jiran haquuf, faankishinii kanatti fayyadami."
 
-#. FExzu
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3145419\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. Afrvq
 #: 03120306.xhp
 msgctxt ""
@@ -32523,15 +32298,6 @@ msgctxt ""
 msgid "Returns the specified portion of a string expression (<emph>Mid function</emph>), or replaces the portion of a string expression with another string (<emph>Mid statement</emph>)."
 msgstr "Xiqqaa himata diraa adda baafamee deebisa (<emph>Mid function</emph>), yookiin xiqqaa himata diraa, diraa biraatiin bakka buusa (<emph>Hima Mid </emph>)."
 
-#. ye7Tj
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3154285\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. 32BvU
 #: 03120306.xhp
 msgctxt ""
@@ -32541,15 +32307,6 @@ msgctxt ""
 msgid "Mid (Text As String, Start As Long [, Length As Long]) or Mid (Text As String, Start As Long , Length As Long, Text As String)"
 msgstr "Mid (Text As String, Start As Long [, Length As Long]) or Mid (Text As String, Start As Long , Length As Long, Text As String)"
 
-#. Bw3Yb
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3145068\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. 5MG4F
 #: 03120306.xhp
 msgctxt ""
@@ -32559,15 +32316,6 @@ msgctxt ""
 msgid "String (only by Function)"
 msgstr "String (only by Function)"
 
-#. rLmbA
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. hRXCE
 #: 03120306.xhp
 msgctxt ""
@@ -32577,23 +32325,23 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to modify."
 msgstr "<emph>Barruu:</emph> Himata diraa kamiyyuu kan akka jijjiiramu barbaaddu dha."
 
-#. MkjPp
+#. DGPaB
 #: 03120306.xhp
 msgctxt ""
 "03120306.xhp\n"
 "par_id3150359\n"
 "help.text"
-msgid "<emph>Start: </emph>Numeric expression that indicates the character position within the string where the string portion that you want to replace or to return begins. The maximum allowed value is 65535."
-msgstr "<emph>Jalqaba: </emph> Himata lakkoofsaa kan bakka arfii diraa keessaa itti jalqabuu fi xiqqaan diraa ati bakka buusuuf ykn deebisuuf barbaaddu jalqabu agarsiisa."
+msgid "<emph>Start: </emph>Numeric expression that indicates the character position within the string where the string portion that you want to replace or to return begins. The minimum allowed value is 1. The maximum allowed value is 2,147,483,648."
+msgstr ""
 
-#. 49ArA
+#. dtyT5
 #: 03120306.xhp
 msgctxt ""
 "03120306.xhp\n"
 "par_id3148451\n"
 "help.text"
-msgid "<emph>Length:</emph> Numeric expression that returns the number of characters that you want to replace or return. The maximum allowed value is 65535."
-msgstr "<emph>Dheerina:</emph> Himata lakkoofsaa kan baay'ina arfiilee akka bakka bu'aman yookiin deebi'an barbaaddu deebisa. 65535 gatii guddaa isa eeyyamamaa dha."
+msgid "<emph>Length:</emph> Numeric expression that returns the number of characters that you want to replace or return. The maximum allowed value is 2,147,483,648."
+msgstr ""
 
 #. Cw9Ts
 #: 03120306.xhp
@@ -32622,15 +32370,6 @@ msgctxt ""
 msgid "<emph>Text:</emph> The string to replace the string expression (<emph>Mid statement</emph>)."
 msgstr "<emph>Barruu:</emph> Diraa himata diraa (<emph>Mid statement</emph>) bakka buusuudhaaf fayyadu dha."
 
-#. jK3U3
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3149560\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. NFDUA
 #: 03120306.xhp
 msgctxt ""
@@ -32685,15 +32424,6 @@ msgctxt ""
 msgid "See also: <link href=\"text/sbasic/shared/03120303.xhp\" name=\"Left Function\">Left Function</link>."
 msgstr "Dabalataan: <link href=\"text/sbasic/shared/03120303.xhp\" name=\"Left Function\">Faankishinii Bitaa</link> ilaali."
 
-#. Xy4Fw
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. A3Rzn
 #: 03120307.xhp
 msgctxt ""
@@ -32703,15 +32433,6 @@ msgctxt ""
 msgid "Right (Text As String, n As Long)"
 msgstr "Right (Text As String, n As Long)"
 
-#. 8sZ7E
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3145068\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. SKQUo
 #: 03120307.xhp
 msgctxt ""
@@ -32721,15 +32442,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. CyX7H
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3146795\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. hErZb
 #: 03120307.xhp
 msgctxt ""
@@ -32739,14 +32451,14 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to return the rightmost characters of."
 msgstr "<emph>Barruu:</emph> Himata diraa kanneen moggaa mirga diraa ta'anii akka deebi'an barbaaddu dha."
 
-#. D8HQ5
+#. NwQkG
 #: 03120307.xhp
 msgctxt ""
 "03120307.xhp\n"
 "par_id3151211\n"
 "help.text"
-msgid "<emph>n:</emph> Numeric expression that defines the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 65535."
-msgstr "<emph>n:</emph> Himata lakkoofsaa kan hamma arfiilee akka siif deebi'an barbaaddu ibsu deebisa.Yoo <emph>n</emph> = 0 ta'e, diraa dheerinni isaa zeeroo ta'etu deebi'a. 65535 gatii eeyyamamaa isa guddaa dha."
+msgid "<emph>n:</emph> Numeric expression that defines the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 2,147,483,648."
+msgstr ""
 
 #. ezXrq
 #: 03120307.xhp
@@ -32757,15 +32469,6 @@ msgctxt ""
 msgid "The following example converts a date in YYYY-MM-DD format to the US date format (MM/DD/YYYY)."
 msgstr "Fakkeenyi armaan gadii haala guyyaa bifa YYYY-MM-DD tiin dhiyaatu gara bifa itti fayyadama US ((MM/DD/YYYY)) tti jijjiira."
 
-#. wgEnG
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3156212\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. ZbKt5
 #: 03120307.xhp
 msgctxt ""
@@ -32811,15 +32514,6 @@ msgctxt ""
 msgid "Right-aligns a string within a string variable, or copies a user-defined variable type into another."
 msgstr "Diraa jijjiirama diraa keessaa, gara mirgaatti hiriirsisuuf;yookiin akaakuu jijjiiramtoota"
 
-#. aHsZH
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3149234\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. uDqvq
 #: 03120308.xhp
 msgctxt ""
@@ -32829,15 +32523,6 @@ msgctxt ""
 msgid "RSet Text As String = Text or RSet Variable1 = Variable2"
 msgstr "RSet Text As String = Text or RSet Variable1 = Variable2"
 
-#. tpDDD
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3156024\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. YfmCj
 #: 03120308.xhp
 msgctxt ""
@@ -32901,15 +32586,6 @@ msgctxt ""
 msgid "The following example uses the <emph>RSet</emph> and <emph>LSet</emph> statements to modify the left and right alignment of a string."
 msgstr "Fakkeenyi armaan gadii;Hiriira bitaa fi mirgaa diraa Fooyyessuuf hima <emph>RSet</emph> fi <emph>LSet</emph> tti fayyadama."
 
-#. BdFxA
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3154909\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. u4Dwb
 #: 03120308.xhp
 msgctxt ""
@@ -32982,15 +32658,6 @@ msgctxt ""
 msgid "See also: <link href=\"text/sbasic/shared/03120305.xhp\" name=\"LTrim Function\">LTrim Function</link>"
 msgstr "Dabalataan: <link href=\"text/sbasic/shared/03120305.xhp\" name=\"LTrim Function\">Faankishinii LTrim </link> ilaali"
 
-#. z57JG
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3154924\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. 3KFbV
 #: 03120309.xhp
 msgctxt ""
@@ -33000,15 +32667,6 @@ msgctxt ""
 msgid "RTrim (Text As String)"
 msgstr "RTrim( Barruu Akka diraa )"
 
-#. qfPg6
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3149457\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. awasf
 #: 03120309.xhp
 msgctxt ""
@@ -33018,15 +32676,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. p2Uwz
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. UW5Fx
 #: 03120309.xhp
 msgctxt ""
@@ -33036,15 +32685,6 @@ msgctxt ""
 msgid "<emph>Text: </emph>Any string expression."
 msgstr "<emph>Text:</emph> Himata Diraa kamiyyuu"
 
-#. Tq2QX
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3151041\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. qdGRW
 #: 03120310.xhp
 msgctxt ""
@@ -33171,15 +32811,6 @@ msgctxt ""
 msgid "Removes all leading and trailing spaces from a string expression."
 msgstr "Iddoowwan duraa fi boodaa, himata diraarraa haqa."
 
-#. xTgNw
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3159157\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. EEu5H
 #: 03120311.xhp
 msgctxt ""
@@ -33189,15 +32820,6 @@ msgctxt ""
 msgid "Trim( Text As String )"
 msgstr "Trim( Barruu Akka diraa )"
 
-#. ZUuwF
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3155388\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. f9pGG
 #: 03120311.xhp
 msgctxt ""
@@ -33207,15 +32829,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. VwME3
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3145609\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. kLdYS
 #: 03120311.xhp
 msgctxt ""
@@ -33225,15 +32838,6 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression."
 msgstr "<emph>Text:</emph> Himata Diraa kamiyyuu"
 
-#. 3GonF
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3148663\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. ZBDyG
 #: 03120312.xhp
 msgctxt ""
@@ -33270,15 +32874,6 @@ msgctxt ""
 msgid "Converts a system file name to a file URL."
 msgstr "Maqaa faayilii sirna gara faayilii URL itti jijjiira."
 
-#. 7EFtr
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3150669\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. zU9U9
 #: 03120312.xhp
 msgctxt ""
@@ -33288,15 +32883,6 @@ msgctxt ""
 msgid "ConvertToURL(filename)"
 msgstr "ConvertToURL(filename)"
 
-#. eq2Gx
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3150984\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. V6WhB
 #: 03120312.xhp
 msgctxt ""
@@ -33306,15 +32892,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. m42nR
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3148550\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. Dka3U
 #: 03120312.xhp
 msgctxt ""
@@ -33324,15 +32901,6 @@ msgctxt ""
 msgid "<emph>Filename:</emph> A file name as string."
 msgstr "<emph>Maqaafaayilii:</emph> Maqaa faayilii akka diraa."
 
-#. iFPRX
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3153361\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. AHBLc
 #: 03120312.xhp
 msgctxt ""
@@ -33378,15 +32946,6 @@ msgctxt ""
 msgid "Converts a file URL to a system file name."
 msgstr "Faayilii URL gara maqaa faayilii sirnatti jijjiiri"
 
-#. Gyuop
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3143267\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. i96Ej
 #: 03120313.xhp
 msgctxt ""
@@ -33396,15 +32955,6 @@ msgctxt ""
 msgid "ConvertFromURL(filename)"
 msgstr "ConvertFromURL(filename)"
 
-#. wq6Jz
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3159157\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. ESx7C
 #: 03120313.xhp
 msgctxt ""
@@ -33414,15 +32964,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. GmBuj
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3143270\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. 8R25b
 #: 03120313.xhp
 msgctxt ""
@@ -33468,15 +33009,6 @@ msgctxt ""
 msgid "Returns an array of substrings from a string expression."
 msgstr "Tarreeffama qurxa diraawwanii, himata diraarraa deebisa."
 
-#. fqDbn
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3149177\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. FGCEc
 #: 03120314.xhp
 msgctxt ""
@@ -33486,15 +33018,6 @@ msgctxt ""
 msgid "Split (Text As String, delimiter, number)"
 msgstr "Split (Text As String, delimiter, number)"
 
-#. XdWY5
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3149763\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. BNdCD
 #: 03120314.xhp
 msgctxt ""
@@ -33504,15 +33027,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. G7w77
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. PRupM
 #: 03120314.xhp
 msgctxt ""
@@ -33540,15 +33054,6 @@ msgctxt ""
 msgid "<emph>number (optional):</emph> The number of substrings that you want to return."
 msgstr "<emph>number (optional):</emph> Lakkoofsa qurxa diraawwanii akka deebi'u barbaaddu deebisa."
 
-#. XZAoD
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3150398\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. 9qGtg
 #: 03120315.xhp
 msgctxt ""
@@ -33585,15 +33090,6 @@ msgctxt ""
 msgid "Returns a string from a number of substrings in a string array."
 msgstr "Diraa qurxa diraawwanii baay'ee, tarree diraa keessa jiran deebisa."
 
-#. Tavaa
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "caasimaa:"
-
 #. FrGPB
 #: 03120315.xhp
 msgctxt ""
@@ -33603,15 +33099,6 @@ msgctxt ""
 msgid "Join (Text As String Array, delimiter)"
 msgstr "Join (Text As String Array, delimiter)"
 
-#. zKGLo
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3150400\n"
-"help.text"
-msgid "Return value:"
-msgstr "Gatii deebii:"
-
 #. Sx96w
 #: 03120315.xhp
 msgctxt ""
@@ -33621,15 +33108,6 @@ msgctxt ""
 msgid "String"
 msgstr "Diraa"
 
-#. uMb7W
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Ulaagaalee:"
-
 #. sEXB3
 #: 03120315.xhp
 msgctxt ""
@@ -33648,15 +33126,6 @@ msgctxt ""
 msgid "<emph>delimiter (optional):</emph> A string character that is used to separate the substrings in the resulting string. The default delimiter is the space character. If delimiter is a string of length zero \"\", the substrings are joined without separator."
 msgstr "<emph>delimiter (optional):</emph> Arfii diraa kan qurxa diraawwanii, diraa keessatti argaman addaan baasuuf fayyadu dha. Durtii daangessuun iddoo arfiiti. Yoo daangessaan diraa dheerinni isaa duwwaa \"\" ta'e, qurxaawwan diraa kan walqabatan fo'aa malee dha."
 
-#. rYFAB
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3154218\n"
-"help.text"
-msgid "Example:"
-msgstr "Fakkeenya:"
-
 #. u25ah
 #: 03120400.xhp
 msgctxt ""
@@ -33774,14 +33243,14 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Ulaagaalee:"
 
-#. jDRQw
+#. KqLff
 #: 03120401.xhp
 msgctxt ""
 "03120401.xhp\n"
 "par_id3153126\n"
 "help.text"
-msgid "<emph>Start: </emph>A numeric expression that marks the position in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the first character of the string. The maximum allowed value is 65535."
-msgstr "<emph>Start: </emph> Himata lakkoofsaa kan jalqaba barbaachuu qurxa diraa adda baafame, dira tokko keessaa agarsiisa. yoo ulaagaa kana dhiifte,barbaachi kan jalqabu arfii jalqabaa diraa irraati. 65535 gatii guddaa eeyyamamu dha."
+msgid "<emph>Start: </emph>A numeric expression that marks the position in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the first character of the string. The minimum allowed value is 1. The maximum allowed value is 2,147,483,648."
+msgstr ""
 
 #. SnP3c
 #: 03120401.xhp
diff --git a/source/om/helpcontent2/source/text/scalc/01.po b/source/om/helpcontent2/source/text/scalc/01.po
index 6d7ebe076e1..c7e34e7a4e2 100644
--- a/source/om/helpcontent2/source/text/scalc/01.po
+++ b/source/om/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-08-21 14:00+0200\n"
+"POT-Creation-Date: 2020-09-07 17:18+0200\n"
 "PO-Revision-Date: 2018-11-12 13:58+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12840,6 +12840,15 @@ msgctxt ""
 msgid "<item type=\"literal\">Base^Exponent</item>"
 msgstr "<item type=\"literal\">Beerii^Paaworii</item>"
 
+#. dRQh7
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id241599040594931\n"
+"help.text"
+msgid "<literal>=POWER(0,0)</literal> returns 1."
+msgstr ""
+
 #. D3Ghv
 #: 04060106.xhp
 msgctxt ""
@@ -52143,6 +52152,15 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
 msgstr ""
 
+#. ZjDq9
+#: 12090106.xhp
+msgctxt ""
+"12090106.xhp\n"
+"par_id681598453957935\n"
+"help.text"
+msgid "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details\"."
+msgstr ""
+
 #. B9FE5
 #: 12090200.xhp
 msgctxt ""
@@ -53133,6 +53151,15 @@ msgctxt ""
 msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
 msgstr ""
 
+#. BFcB6
+#: ODFF.xhp
+msgctxt ""
+"ODFF.xhp\n"
+"hd_id1000013\n"
+"help.text"
+msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3."
+msgstr ""
+
 #. SGHPh
 #: calculate.xhp
 msgctxt ""
diff --git a/source/om/helpcontent2/source/text/shared/01.po b/source/om/helpcontent2/source/text/shared/01.po
index 58da4fd2c3d..4f2ee54dab4 100644
--- a/source/om/helpcontent2/source/text/shared/01.po
+++ b/source/om/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-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-07 17:18+0200\n"
 "PO-Revision-Date: 2018-11-14 12:07+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -49326,13 +49326,13 @@ msgctxt ""
 msgid "<bookmark_value>digital signature;signing existing PDF</bookmark_value>"
 msgstr ""
 
-#. zBtBC
+#. ohSz3
 #: signexistingpdf.xhp
 msgctxt ""
 "signexistingpdf.xhp\n"
 "hd_id201526432498222\n"
 "help.text"
-msgid "<variable id=\"signexisitingpdf\"><link href=\"text/shared/01/signexistingpdf.xhp\" name=\"Sign Existing PDF Files\">Signing Existing PDF files</link></variable>"
+msgid "<variable id=\"signexistingpdf\"><link href=\"text/shared/01/signexistingpdf.xhp\" name=\"Sign Existing PDF Files\">Signing Existing PDF files</link></variable>"
 msgstr ""
 
 #. RM32g
@@ -49524,13 +49524,13 @@ msgctxt ""
 msgid "Time Stamp Authorities for Digital Signatures"
 msgstr ""
 
-#. 53EtS
+#. HgFt5
 #: timestampauth.xhp
 msgctxt ""
 "timestampauth.xhp\n"
 "bm_id371597437796483\n"
 "help.text"
-msgid "<bookmark_value>time stamp;digital signature</bookmark_value>    <bookmark_value>digital signature;time stamp</bookmark_value>    <bookmark_value>time stamp authority</bookmark_value>    <bookmark_value>time stamp for PDF digital signature</bookmark_value>"
+msgid "<bookmark_value>time stamp;digital signature</bookmark_value>    <bookmark_value>digital signature;time stamp</bookmark_value>    <bookmark_value>time stamp authority</bookmark_value>    <bookmark_value>TSA</bookmark_value>    <bookmark_value>time stamp for PDF digital signature</bookmark_value>"
 msgstr ""
 
 #. QwKC7
diff --git a/source/om/helpcontent2/source/text/shared/05.po b/source/om/helpcontent2/source/text/shared/05.po
index 0a2ae0b4b54..7bfb5222c52 100644
--- a/source/om/helpcontent2/source/text/shared/05.po
+++ b/source/om/helpcontent2/source/text/shared/05.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-07-21 11:19+0200\n"
+"POT-Creation-Date: 2020-08-31 14:55+0200\n"
 "PO-Revision-Date: 2018-10-21 20:30+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1275,22 +1275,22 @@ msgctxt ""
 msgid "That is an error. Possible causes are:"
 msgstr ""
 
-#. kFHZY
+#. afzNC
 #: err_html.xhp
 msgctxt ""
 "err_html.xhp\n"
 "par_id131592238966436\n"
 "help.text"
-msgid "The page does not exists and must be created."
+msgid "The page does not exist and must be created."
 msgstr ""
 
-#. wBHiJ
+#. BDKK7
 #: err_html.xhp
 msgctxt ""
 "err_html.xhp\n"
 "par_id201592238985883\n"
 "help.text"
-msgid "The page exists, but the Help ID is wrong or missing."
+msgid "The page exist, but the Help ID is wrong or missing."
 msgstr ""
 
 #. Bbuu2
diff --git a/source/om/helpcontent2/source/text/shared/optionen.po b/source/om/helpcontent2/source/text/shared/optionen.po
index 87fb42fee2f..48b9e467ad1 100644
--- a/source/om/helpcontent2/source/text/shared/optionen.po
+++ b/source/om/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-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-07 17:18+0200\n"
 "PO-Revision-Date: 2018-11-14 12:07+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -8079,6 +8079,42 @@ msgctxt ""
 msgid "Specifies the characters that are considered as word separators when counting words, in addition to spaces, tabs and line and paragraph breaks."
 msgstr ""
 
+#. LBDBF
+#: 01040900.xhp
+msgctxt ""
+"01040900.xhp\n"
+"hd_id691599000315902\n"
+"help.text"
+msgid "Show standardized page count"
+msgstr ""
+
+#. 67L2A
+#: 01040900.xhp
+msgctxt ""
+"01040900.xhp\n"
+"par_id581599002628645\n"
+"help.text"
+msgid "Editors and publishers often define a “standard” page as containing a specified number of characters or words. Mark this field to allows quick calculation of the number of these pages."
+msgstr ""
+
+#. eQjAd
+#: 01040900.xhp
+msgctxt ""
+"01040900.xhp\n"
+"hd_id511599000321915\n"
+"help.text"
+msgid "Characters per standardized page"
+msgstr ""
+
+#. AFkck
+#: 01040900.xhp
+msgctxt ""
+"01040900.xhp\n"
+"par_id271599002636069\n"
+"help.text"
+msgid "Set the number of characters for the standardized page."
+msgstr ""
+
 #. RPuAH
 #: 01041000.xhp
 msgctxt ""
diff --git a/source/om/helpcontent2/source/text/swriter/01.po b/source/om/helpcontent2/source/text/swriter/01.po
index ba7a413bec7..1227b665b08 100644
--- a/source/om/helpcontent2/source/text/swriter/01.po
+++ b/source/om/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-08-17 12:39+0200\n"
+"POT-Creation-Date: 2020-09-07 17:18+0200\n"
 "PO-Revision-Date: 2018-10-21 20:30+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13677,6 +13677,15 @@ msgctxt ""
 msgid "You can use the Find All button on the Find & Replace dialog to highlight all places where a word appears, then open the Insert Index Entry dialog to add that word and places to the alphabetical index. However, if you need the same set of alphabetical indexes in multiple documents, the concordance file allows you to enter every word just once, then use the list many times."
 msgstr "Qabduu Hunda Barbaadii, bakka jechi itti mul'atu mara shoolessuudhaaf, qaaqa Barbaadi fi Bakkabuusi fayyadamuu, itti aansuudhaan, jecha sana fi bakkawwan kasaa aabaa keessatti ida'uuf ammoo, qaaqa Galfata Kasaa Saagi banuu nidandeessa. Haa tahu malee, tuuta kasaa aabaa innumti sun yoo galmeewwan hedduu keessatti si barbaachisa tahe, faayiliin walta'iinsaa, tokko tokkee jechaa naqa tokkittii galchuu, sana booda tarricha yeroo baayyee fayyadamuu ni hayyama."
 
+#. FVXZ4
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id771599006446118\n"
+"help.text"
+msgid "The default filter for creating or opening concordance files is <literal>*.sdi</literal>. However, the file format of the concordance file is plain text."
+msgstr ""
+
 #. cFHDU
 #: 04120250.xhp
 msgctxt ""
@@ -13731,6 +13740,33 @@ msgctxt ""
 msgid "A concordance file contains the following fields:"
 msgstr "Faayili walta'iinsaa, dirreewwan kanaan gaddii of keessaa qaba:"
 
+#. 9wETm
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id91599005949275\n"
+"help.text"
+msgid "Term"
+msgstr ""
+
+#. zMi8V
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id461599005949276\n"
+"help.text"
+msgid "Meaning"
+msgstr ""
+
+#. e7Npc
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id291599005949278\n"
+"help.text"
+msgid "Search term"
+msgstr ""
+
 #. zFwbQ
 #: 04120250.xhp
 msgctxt ""
@@ -13740,6 +13776,15 @@ msgctxt ""
 msgid "\"Search term\" refers to the index entry that you want to mark in the document."
 msgstr "\"Jecha barbadii\" gara galfatoowwan kasaa isa ati akka galmee keessatti mallaateefamu barbaaddu wabeessa."
 
+#. CEahq
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id811599006053151\n"
+"help.text"
+msgid "Alternative entry"
+msgstr ""
+
 #. rxooN
 #: 04120250.xhp
 msgctxt ""
@@ -13749,6 +13794,15 @@ msgctxt ""
 msgid "\"Alternative entry\" refers to the index entry that you want to appear in the index."
 msgstr "\"Galfata filmaataa\" gara galfatoowwan kasaa isa ati akka kasaa keessatti mul'atu barbaaddu wabeessa."
 
+#. q3DFC
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id661599006090921\n"
+"help.text"
+msgid "1st and 2nd Keys"
+msgstr ""
+
 #. VRBtF
 #: 04120250.xhp
 msgctxt ""
@@ -13758,6 +13812,33 @@ msgctxt ""
 msgid "The 1st and 2nd Keys are parent index entries. The \"Search term\" or the \"Alternative entry\" appears as a subentry under the 1st and 2nd Keys."
 msgstr "Furtuuwwanii 1ffaa fi 2ffaan galfatoota kasaatiif haadhoodha. \"Jecha barbadii\" yk \"Galfata filmaataa\" akka galfata xixiqqaa tokkootti qabduuwwanii 1ffaa fi 2ffaa jalatti mul'atu."
 
+#. DuJqR
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id521599007507727\n"
+"help.text"
+msgid "Comment"
+msgstr ""
+
+#. GCW2W
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id981599007507728\n"
+"help.text"
+msgid "Add a comment line above the entry. Commented lines start with #."
+msgstr ""
+
+#. MPT5J
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id441599006128506\n"
+"help.text"
+msgid "Match case"
+msgstr ""
+
 #. PqJ9t
 #: 04120250.xhp
 msgctxt ""
@@ -13767,6 +13848,15 @@ msgctxt ""
 msgid "\"Match case\" means that uppercase and lowercase letters are considered."
 msgstr "\"Walsima qubee\" jechuun, qubeewwan qubeeguddaaa fi qubee xixiqqaa ilallaa jechuudha."
 
+#. 9Zvp6
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id361599006161460\n"
+"help.text"
+msgid "Word only"
+msgstr ""
+
 #. hFig3
 #: 04120250.xhp
 msgctxt ""
@@ -13830,14 +13920,14 @@ msgctxt ""
 msgid "Use the following format for the entries:"
 msgstr "Galfatootaaf dhangii kanaan gaddii fayyadami:"
 
-#. vDSMm
+#. GoFzo
 #: 04120250.xhp
 msgctxt ""
 "04120250.xhp\n"
 "par_id3149172\n"
 "help.text"
-msgid "Search term;Alternative entry;1st key;2nd key;Match case;Word only"
-msgstr "Jecha barbaachaa;Galfata filachiisaa;Qabduu 1ffaa;Qabduu 2ffaa;Walsima qubee;Jecha qofa"
+msgid "<literal>Search term;Alternative entry;1st key;2nd key;Match case;Word only</literal>"
+msgstr ""
 
 #. FWVnU
 #: 04120250.xhp
@@ -13866,14 +13956,14 @@ msgctxt ""
 msgid "For example, to include the word \"Boston\" in your alphabetical index under the \"Cities\" entry, enter the following line in the concordance file:"
 msgstr "Fakkenyaaf, jecha \"Boston\" jedhu galfata \"Magaalootaatti\" dabaluudhaaf, faayilii walta'iinsaa keessatti sarara kanaan gadii galchi."
 
-#. BqcRU
+#. hqr4T
 #: 04120250.xhp
 msgctxt ""
 "04120250.xhp\n"
 "par_id3151370\n"
 "help.text"
-msgid "Boston;Boston;Cities;;0;0"
-msgstr "Boston;Boston;Magaaloota;;0;0"
+msgid "<literal>Boston;Boston;Cities;;0;0</literal>"
+msgstr ""
 
 #. NQkQN
 #: 04120250.xhp
@@ -13893,14 +13983,14 @@ msgctxt ""
 msgid "To include the \"Beacon Hill\" district in Boston under the \"Cities\" entry, enter the following line:"
 msgstr "aanaa \"Beacon Hill\" galfata \"Magaalootaa\" jalatti Boston keessatti dabaluudhaaf, sarara kanaan gadii galchi."
 
-#. MiuPA
+#. J8EX4
 #: 04120250.xhp
 msgctxt ""
 "04120250.xhp\n"
 "par_id3150116\n"
 "help.text"
-msgid "Beacon Hill;Boston;Cities;"
-msgstr "Finfinnee;Shaashmannee;Magaaloota;"
+msgid "<literal>Beacon Hill;Boston;Cities;</literal>"
+msgstr ""
 
 #. aG6Cj
 #: 04120300.xhp