update translations for master

and force-fix errors using pocheck

Change-Id: I95203f89a4148dd4f91a2a438c5c9811ac2dbe44

6 files changed, 262 insertions, 640 deletions

diff --git a/source/fi/helpcontent2/source/text/sbasic/shared.po b/source/fi/helpcontent2/source/text/sbasic/shared.po
index d0c9fe88320..745440777c5 100644
--- a/source/fi/helpcontent2/source/text/sbasic/shared.po
+++ b/source/fi/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2020-03-27 22:16+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/fi/>\n"
@@ -610,6 +610,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 ""
@@ -2419,14 +2428,23 @@ msgctxt ""
 msgid "String Variables"
 msgstr "Merkkijonomuuttujat"
 
-#. 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 "Merkkijonomuuttujissa (String) voi olla enintään 65 535 merkkiä pitkiä merkkijonoja. Jokainen merkki on tallennettu sitä vastaavana Unicode-arvona. Merkkijonomuuttujat ovat sopivia tekstinkäsittelyyn ohjelmissa ja tilapäisiksi varastoiksi tulostumattomille merkeille aina 64 kt jonoihin asti. String-muuttujien muistin tarve on riippuvainen merkkijonon pituudesta. Tyypin määritysmerkkinä on \"$\"."
+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
@@ -16549,86 +16567,41 @@ msgctxt ""
 msgid "The following functions and statements set or return the system date and time."
 msgstr "Oheiset funktion ja lauseet palauttavat tai asettavat järjestelmäkellon päivämäärän ja kellonajan."
 
-#. 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>Date-lause</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 "Date-lause palauttaa senhetkisen käyttöjärjestelmän päivämäärän merkkijonona tai asettaa uuden päivämäärän. Päivämäärän muoto on maa-asetuksista riippuvainen."
-
-#. CUY3q
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3148686\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
-#. QoCJW
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"par_id3146794\n"
-"help.text"
-msgid "Date ; Date = Text As String"
-msgstr "Date ; Date = teksti1 As String"
-
-#. 8QFeW
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
-#. 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>Teksti1:</emph> on tarpeen vain asetettaessa järjestelmäaikaa. Tässä tapauksessa merkkijonolausekkeen pitää vastata paikallisten asetusten mukaista päivämäärämuotoa."
-
-#. waEYM
-#: 03030301.xhp
-msgctxt ""
-"03030301.xhp\n"
-"hd_id3150793\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
+msgid "Returns the current system date as a string, or date variant."
+msgstr ""
 
 #. BUc3C
 #: 03030301.xhp
@@ -16639,31 +16612,31 @@ msgctxt ""
 msgid "MsgBox \"The date is \" & Date"
 msgstr "msgbox \"Järjestelmän päivämäärä on \" & 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>Time-lause</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
@@ -16675,42 +16648,6 @@ msgctxt ""
 msgid "This function returns the current system time as a string in the format \"HH:MM:SS\"."
 msgstr "Time-lause palauttaa senhetkisen järjestelmäajan merkkijonona, joka on muotoa \"HH:MM:SS\"."
 
-#. G29nS
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3154346\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
-#. rG5UZ
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3150792\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
-#. 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>Teksti1:</emph> merkkijonolause, jossa on määrittelee kellonajan muodossa \"HH:MM:SS\"."
-
-#. psu4B
-#: 03030302.xhp
-msgctxt ""
-"03030302.xhp\n"
-"hd_id3145173\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. Aguz5
 #: 03030302.xhp
 msgctxt ""
@@ -22291,15 +22228,6 @@ msgctxt ""
 msgid "Returns one of two possible function results, depending on the logical value of the evaluated expression."
 msgstr "Iif palauttaa toisen kahdesta funktion tulosvaihtoehdostaan, riippuen tulkitun lausekkeen totuusarvosta."
 
-#. DMbgx
-#: 03090103.xhp
-msgctxt ""
-"03090103.xhp\n"
-"hd_id3159413\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. dDDFQ
 #: 03090103.xhp
 msgctxt ""
@@ -22309,15 +22237,6 @@ msgctxt ""
 msgid "IIf (Expression, ExpressionTrue, ExpressionFalse)"
 msgstr "Iif (lauseke1, lauseke_on_True, lauseke_on_False)"
 
-#. Jr9BS
-#: 03090103.xhp
-msgctxt ""
-"03090103.xhp\n"
-"hd_id3150541\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. TXHsN
 #: 03090103.xhp
 msgctxt ""
@@ -22336,6 +22255,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>Lauseke_on_True, lauseke_on_False:</emph> mitä tahansa lausekkeita, joista toinen palautetaan iif-funktion tuloksena, riippuen lauseke1:n arvioidusta totuusarvosta."
 
+#. 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 ""
@@ -31453,13 +31399,13 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. 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
@@ -31507,15 +31453,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 "String luo merkkijonon tiettyä merkkiä toistaen tai ensimmäisestä merkkijonolausekkeen merkistä, joka välitetään funktiolle."
 
-#. YEQWe
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. EVKUs
 #: 03120202.xhp
 msgctxt ""
@@ -31525,15 +31462,6 @@ msgctxt ""
 msgid "String (n As Long, {expression As Integer | character As String})"
 msgstr "String (n As Long, {lauseke1 As Integer | merkki1 As String})"
 
-#. Uaxak
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3143270\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. GfqGg
 #: 03120202.xhp
 msgctxt ""
@@ -31543,23 +31471,14 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. 5gnCP
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3154923\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
-#. 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> numeerinen lauseke, joka osoittaa palautettavien merkkien määrän. Suurin sallittu n:n arvo on 65535."
+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
@@ -31579,15 +31498,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>Merkki1:</emph> mikä tahansa yksittäinen merkki, josta rakennetaan palautettava merkkijono tai mikä tahansa merkkijono, josta vain ensimmäistä merkkiä käytetään."
 
-#. iApAt
-#: 03120202.xhp
-msgctxt ""
-"03120202.xhp\n"
-"hd_id3152920\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. avFC9
 #: 03120300.xhp
 msgctxt ""
@@ -31660,15 +31570,6 @@ msgctxt ""
 msgid "Converts a number to a string, and then formats it according to the format that you specify."
 msgstr "Format muuntaa luvun merkkijonoksi ja sitten muotoilee sen määrätyn muotoilun mukaisesti."
 
-#. ESujY
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3145090\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. wp4Ae
 #: 03120301.xhp
 msgctxt ""
@@ -31678,15 +31579,6 @@ msgctxt ""
 msgid "Format (Number [, Format As String])"
 msgstr "Format (luku1 [, muotoilu1 As String])"
 
-#. SrkYm
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3149178\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. gddga
 #: 03120301.xhp
 msgctxt ""
@@ -31696,15 +31588,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. WGjGQ
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3159176\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. 6Dyxg
 #: 03120301.xhp
 msgctxt ""
@@ -31984,15 +31867,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 "Muotoilukoodi on jaettavissa kolmeen osaan, jotka erotellaan toisistaan puolipistein. Ensimmäinen osa muotoilee positiiviset luvut, toinen osa on negatiivisille luvuille ja kolmas nollalle. Jos määritellään vain yksi muotoilukoodi, sitä käytetään kaikkiin lukuihin."
 
-#. GXmDT
-#: 03120301.xhp
-msgctxt ""
-"03120301.xhp\n"
-"hd_id3149019\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. ZsNPC
 #: 03120301.xhp
 msgctxt ""
@@ -32146,15 +32020,6 @@ msgctxt ""
 msgid "Returns the number of leftmost characters that you specify of a string expression."
 msgstr "Left palauttaa määritellyn määrän merkkijonolausekkeen merkkejä vasemmalta lukien."
 
-#. UF45c
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3156153\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. H2Ftq
 #: 03120303.xhp
 msgctxt ""
@@ -32164,15 +32029,6 @@ msgctxt ""
 msgid "Left (Text As String, n As Long)"
 msgstr "Left (teksti1 As String, n As Long)"
 
-#. 48Gmp
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3153824\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. to74m
 #: 03120303.xhp
 msgctxt ""
@@ -32182,15 +32038,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. ZJXfA
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3148946\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. hRWZH
 #: 03120303.xhp
 msgctxt ""
@@ -32200,14 +32047,14 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to return the leftmost characters from."
 msgstr "<emph>Teksti1:</emph> Mikä tahansa merkkijonolauseke, josta palautetaan merkkejä vasemmalta lukien."
 
-#. 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> numeerinen lauseke, joka määrittää kuinka monta merkkiä halutaan palauttaa. Jos <emph>n</emph> = 0, palautetaan merkkijono, jonka pituus on nolla. Suurin sallittu arvo on 65535."
+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
@@ -32218,15 +32065,6 @@ msgctxt ""
 msgid "The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format."
 msgstr "Seuraava esimerkki muuntaa päivämäärän muodosta VVVV.KK.PP muotoon MM/DD/YYYY."
 
-#. YQQDH
-#: 03120303.xhp
-msgctxt ""
-"03120303.xhp\n"
-"hd_id3125863\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. TJBfC
 #: 03120303.xhp
 msgctxt ""
@@ -32272,15 +32110,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 "Lset-lause kohdistaa merkkijonon vasemmalle merkkijonomuuttujassa tai kopioi käyttäjän määrittämän muuttujan toiseen käyttäjän määrittämään muuttujaan."
 
-#. wKtHD
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3145317\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. tFaav
 #: 03120304.xhp
 msgctxt ""
@@ -32290,15 +32119,6 @@ msgctxt ""
 msgid "LSet Var As String = Text or LSet Var1 = Var2"
 msgstr "LSet muuttuja1 As String = teksti1 tai LSet muuttuja2 = muuttuja3"
 
-#. 2vzrB
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3143271\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. M99uG
 #: 03120304.xhp
 msgctxt ""
@@ -32344,15 +32164,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 "Jos teksti1 on lyhyempi kuin muuttuja1, <emph>LSet</emph> kohdistaa teksti1:n vasemmalle muuttuja1:een. Jäljelle jäävä tila täytetään välilyönneillä. Jos merkkijono on pitempi kuin merkkijonomuuttuja, merkit kopioidaan vasemmalta alkaen vain muuttujan pituuteen asti. <emph>LSet</emph>-lauseella voidaan kopioida myös käyttäjän määrittämää tyyppiä oleva muuttuja toiseen samanlaiseen."
 
-#. BQw4P
-#: 03120304.xhp
-msgctxt ""
-"03120304.xhp\n"
-"hd_id3156282\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. jJepi
 #: 03120304.xhp
 msgctxt ""
@@ -32416,15 +32227,6 @@ msgctxt ""
 msgid "Removes all leading spaces at the start of a string expression."
 msgstr "LTrim poistaa välilyönnit merkkijonon alusta."
 
-#. vG8YP
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3154924\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. cepxM
 #: 03120305.xhp
 msgctxt ""
@@ -32434,15 +32236,6 @@ msgctxt ""
 msgid "LTrim (Text As String)"
 msgstr "LTrim (teksti1 As String)"
 
-#. KzzDh
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3156344\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. LyUCE
 #: 03120305.xhp
 msgctxt ""
@@ -32452,15 +32245,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. 8hNZD
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3150543\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. x85WJ
 #: 03120305.xhp
 msgctxt ""
@@ -32479,15 +32263,6 @@ msgctxt ""
 msgid "Use this function to remove spaces at the beginning of a string expression."
 msgstr "Tätä funktiota käytetään merkkijonon alussa olevien välilyöntien poistamiseen."
 
-#. FExzu
-#: 03120305.xhp
-msgctxt ""
-"03120305.xhp\n"
-"hd_id3145419\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. Afrvq
 #: 03120306.xhp
 msgctxt ""
@@ -32524,15 +32299,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 "<emph>Mid-funktio</emph> palauttaa määrätyn osan merkkijonolausekkeesta. <emph>Mid-lause</emph> korvaa osan merkkijonosta toisella merkkijonolla."
 
-#. ye7Tj
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3154285\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. 32BvU
 #: 03120306.xhp
 msgctxt ""
@@ -32542,15 +32308,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 (teksti1 As String, alku1 As Long [, pituus1 As Long]) tai Mid (teksti1 As String, alku1 As Long , pituus1 As Long, teksti2 As String)"
 
-#. Bw3Yb
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3145068\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. 5MG4F
 #: 03120306.xhp
 msgctxt ""
@@ -32560,15 +32317,6 @@ msgctxt ""
 msgid "String (only by Function)"
 msgstr "merkkijono (String, vain funktiolla)"
 
-#. rLmbA
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. hRXCE
 #: 03120306.xhp
 msgctxt ""
@@ -32578,23 +32326,23 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to modify."
 msgstr "<emph>Teksti1:</emph> mikä tahansa muutettava merkkijonolauseke."
 
-#. 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>Alku1: </emph>numeerinen lauseke, joka osoittaa merkin sijainnin merkkijonossa, josta alkaen korvataan tai luetaan palautettavaksi. Suurin sallittu arvo on 65535."
+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>Pituus1:</emph> numeerinen lauseke, joka määrittää sen merkkien lukumäärän, joka korvataan tai palautetaan. Suurin sallittu arvo on 65535."
+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
@@ -32623,15 +32371,6 @@ msgctxt ""
 msgid "<emph>Text:</emph> The string to replace the string expression (<emph>Mid statement</emph>)."
 msgstr "<emph>Teksti2:</emph> merkkijono, joka korvaa osan teksti1:stä (<emph>Mid-lauseessa</emph>)."
 
-#. jK3U3
-#: 03120306.xhp
-msgctxt ""
-"03120306.xhp\n"
-"hd_id3149560\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. NFDUA
 #: 03120306.xhp
 msgctxt ""
@@ -32686,15 +32425,6 @@ msgctxt ""
 msgid "See also: <link href=\"text/sbasic/shared/03120303.xhp\" name=\"Left Function\">Left Function</link>."
 msgstr "Katso myös: <link href=\"text/sbasic/shared/03120303.xhp\" name=\"Left Function\">funktio Left</link>."
 
-#. Xy4Fw
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. A3Rzn
 #: 03120307.xhp
 msgctxt ""
@@ -32704,15 +32434,6 @@ msgctxt ""
 msgid "Right (Text As String, n As Long)"
 msgstr "Right (teksti1 As String, n As Long)"
 
-#. 8sZ7E
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3145068\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. SKQUo
 #: 03120307.xhp
 msgctxt ""
@@ -32722,15 +32443,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. CyX7H
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3146795\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. hErZb
 #: 03120307.xhp
 msgctxt ""
@@ -32740,14 +32452,14 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that you want to return the rightmost characters of."
 msgstr "<emph>Teksti1:</emph> Mikä tahansa merkkijonolauseke, josta palautetaan merkkejä oikealta lukien."
 
-#. 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> numeerinen lauseke, joka määrittää kuinka monta merkkiä halutaan palauttaa. Jos <emph>n</emph> = 0, palautetaan merkkijono, jonka pituus on nolla. Suurin sallittu arvo on 65535."
+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
@@ -32758,15 +32470,6 @@ msgctxt ""
 msgid "The following example converts a date in YYYY-MM-DD format to the US date format (MM/DD/YYYY)."
 msgstr "Seuraava esimerkkiohjelma muuntaa päivämäärän muodosta YYYY-MM-DD US-päivämäärämuotoon (MM/DD/YYYY)."
 
-#. wgEnG
-#: 03120307.xhp
-msgctxt ""
-"03120307.xhp\n"
-"hd_id3156212\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. ZbKt5
 #: 03120307.xhp
 msgctxt ""
@@ -32812,15 +32515,6 @@ msgctxt ""
 msgid "Right-aligns a string within a string variable, or copies a user-defined variable type into another."
 msgstr "Rset-lause kohdistaa merkkijonon oikealle merkkijonomuuttujassa tai kopioi käyttäjän määrittämän muuttujan toiseen."
 
-#. aHsZH
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3149234\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. uDqvq
 #: 03120308.xhp
 msgctxt ""
@@ -32830,15 +32524,6 @@ msgctxt ""
 msgid "RSet Text As String = Text or RSet Variable1 = Variable2"
 msgstr "RSet teksti1 As String = teksti2 tai LSet muuttuja1 = muuttuja2"
 
-#. tpDDD
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3156024\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. YfmCj
 #: 03120308.xhp
 msgctxt ""
@@ -32902,15 +32587,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 "Seuraavassa esimerkissä käytetään <emph>RSet</emph>- ja <emph>LSet</emph>-lauseita merkkijonon vasemmalle ja oikealle kohdistukseen."
 
-#. BdFxA
-#: 03120308.xhp
-msgctxt ""
-"03120308.xhp\n"
-"hd_id3154909\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. u4Dwb
 #: 03120308.xhp
 msgctxt ""
@@ -32983,15 +32659,6 @@ msgctxt ""
 msgid "See also: <link href=\"text/sbasic/shared/03120305.xhp\" name=\"LTrim Function\">LTrim Function</link>"
 msgstr "Katso myös: <link href=\"text/sbasic/shared/03120305.xhp\" name=\"LTrim Function\">Funktio LTrim</link>"
 
-#. z57JG
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3154924\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. 3KFbV
 #: 03120309.xhp
 msgctxt ""
@@ -33001,15 +32668,6 @@ msgctxt ""
 msgid "RTrim (Text As String)"
 msgstr "RTrim (teksti1 As String)"
 
-#. qfPg6
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3149457\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. awasf
 #: 03120309.xhp
 msgctxt ""
@@ -33019,15 +32677,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. p2Uwz
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. UW5Fx
 #: 03120309.xhp
 msgctxt ""
@@ -33037,15 +32686,6 @@ msgctxt ""
 msgid "<emph>Text: </emph>Any string expression."
 msgstr "<emph>Teksti1: </emph>mikä tahansa merkkijonolauseke."
 
-#. Tq2QX
-#: 03120309.xhp
-msgctxt ""
-"03120309.xhp\n"
-"hd_id3151041\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. qdGRW
 #: 03120310.xhp
 msgctxt ""
@@ -33172,15 +32812,6 @@ msgctxt ""
 msgid "Removes all leading and trailing spaces from a string expression."
 msgstr "Trim poistaa välilyönnit merkkijonon alusta ja lopusta."
 
-#. xTgNw
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3159157\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. EEu5H
 #: 03120311.xhp
 msgctxt ""
@@ -33190,15 +32821,6 @@ msgctxt ""
 msgid "Trim( Text As String )"
 msgstr "Trim( teksti1 As String )"
 
-#. ZUuwF
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3155388\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. f9pGG
 #: 03120311.xhp
 msgctxt ""
@@ -33208,15 +32830,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. VwME3
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3145609\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. kLdYS
 #: 03120311.xhp
 msgctxt ""
@@ -33226,15 +32839,6 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression."
 msgstr "<emph>Teksti1:</emph> mikä tahansa merkkijonolauseke."
 
-#. 3GonF
-#: 03120311.xhp
-msgctxt ""
-"03120311.xhp\n"
-"hd_id3148663\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. ZBDyG
 #: 03120312.xhp
 msgctxt ""
@@ -33271,15 +32875,6 @@ msgctxt ""
 msgid "Converts a system file name to a file URL."
 msgstr "ConvertToURL muuntaa järjestelmän tiedostonimen tiedosto-URL:äksi."
 
-#. 7EFtr
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3150669\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. zU9U9
 #: 03120312.xhp
 msgctxt ""
@@ -33289,15 +32884,6 @@ msgctxt ""
 msgid "ConvertToURL(filename)"
 msgstr "ConvertToURL(tiedostonimi1)"
 
-#. eq2Gx
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3150984\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. V6WhB
 #: 03120312.xhp
 msgctxt ""
@@ -33307,15 +32893,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. m42nR
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3148550\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. Dka3U
 #: 03120312.xhp
 msgctxt ""
@@ -33325,15 +32902,6 @@ msgctxt ""
 msgid "<emph>Filename:</emph> A file name as string."
 msgstr "<emph>Tiedostonimi1:</emph> tiedoston nimi merkkijonona."
 
-#. iFPRX
-#: 03120312.xhp
-msgctxt ""
-"03120312.xhp\n"
-"hd_id3153361\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. AHBLc
 #: 03120312.xhp
 msgctxt ""
@@ -33379,15 +32947,6 @@ msgctxt ""
 msgid "Converts a file URL to a system file name."
 msgstr "ConvertFromURL muuntaa tiedosto-URL:än järjestelmän tiedostonimeksi."
 
-#. Gyuop
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3143267\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. i96Ej
 #: 03120313.xhp
 msgctxt ""
@@ -33397,15 +32956,6 @@ msgctxt ""
 msgid "ConvertFromURL(filename)"
 msgstr "ConvertFromURL(tiedostonimi1)"
 
-#. wq6Jz
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3159157\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. ESx7C
 #: 03120313.xhp
 msgctxt ""
@@ -33415,15 +32965,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. GmBuj
-#: 03120313.xhp
-msgctxt ""
-"03120313.xhp\n"
-"hd_id3143270\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. 8R25b
 #: 03120313.xhp
 msgctxt ""
@@ -33469,15 +33010,6 @@ msgctxt ""
 msgid "Returns an array of substrings from a string expression."
 msgstr "Split palauttaa merkkijonotaulukon merkkijonolausekkeesta."
 
-#. fqDbn
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3149177\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. FGCEc
 #: 03120314.xhp
 msgctxt ""
@@ -33487,15 +33019,6 @@ msgctxt ""
 msgid "Split (Text As String, delimiter, number)"
 msgstr "Split (teksti1 As String[, erotin1][, luku1])"
 
-#. XdWY5
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3149763\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. BNdCD
 #: 03120314.xhp
 msgctxt ""
@@ -33505,15 +33028,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. G7w77
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. PRupM
 #: 03120314.xhp
 msgctxt ""
@@ -33541,15 +33055,6 @@ msgctxt ""
 msgid "<emph>number (optional):</emph> The number of substrings that you want to return."
 msgstr "<emph>Luku1 (valinnainen):</emph> niiden merkkijonojen lukumäärä, jotka halutaan palauttaa."
 
-#. XZAoD
-#: 03120314.xhp
-msgctxt ""
-"03120314.xhp\n"
-"hd_id3150398\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. 9qGtg
 #: 03120315.xhp
 msgctxt ""
@@ -33586,15 +33091,6 @@ msgctxt ""
 msgid "Returns a string from a number of substrings in a string array."
 msgstr "Join palauttaa yhdistetyn merkkijonon merkkijonotaulukon merkkijonoista."
 
-#. Tavaa
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
 #. FrGPB
 #: 03120315.xhp
 msgctxt ""
@@ -33604,15 +33100,6 @@ msgctxt ""
 msgid "Join (Text As String Array, delimiter)"
 msgstr "Join (teksti1 As String Array, erotin1)"
 
-#. zKGLo
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3150400\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
 #. Sx96w
 #: 03120315.xhp
 msgctxt ""
@@ -33622,15 +33109,6 @@ msgctxt ""
 msgid "String"
 msgstr "merkkijono (String)"
 
-#. uMb7W
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
 #. sEXB3
 #: 03120315.xhp
 msgctxt ""
@@ -33649,15 +33127,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>Erotin1 (valinnainen):</emph> merkki, jota käytetään tuloksen osamerkkijonojen erottimena. Oletuksena on välilyöntimerkki. Jos erottimen pituus on nolla \"\", osamerkkijonot liitetään ilman erotinta."
 
-#. rYFAB
-#: 03120315.xhp
-msgctxt ""
-"03120315.xhp\n"
-"hd_id3154218\n"
-"help.text"
-msgid "Example:"
-msgstr "Esimerkki:"
-
 #. u25ah
 #: 03120400.xhp
 msgctxt ""
@@ -33775,14 +33244,14 @@ msgctxt ""
 msgid "Parameters:"
 msgstr "Parametrit:"
 
-#. 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>Alku1: </emph> numeerinen lauseke, joka tarkoittaa sitä sijaintia merkkijonossa, josta määrätyn osamerkkijonon etsintä aloitetaan. Jos parametri jätetään pois, etsintä alkaa merkkijonon ensimmäisestä merkistä. Suurin sallittu arvo on 65535."
+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/fi/helpcontent2/source/text/scalc/01.po b/source/fi/helpcontent2/source/text/scalc/01.po
index daa652df1c7..ba0526a3c07 100644
--- a/source/fi/helpcontent2/source/text/scalc/01.po
+++ b/source/fi/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: 2020-03-27 22:16+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/fi/>\n"
@@ -12841,6 +12841,15 @@ msgctxt ""
 msgid "<item type=\"literal\">Base^Exponent</item>"
 msgstr ""
 
+#. 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 ""
@@ -52144,6 +52153,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 ""
@@ -53134,6 +53152,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/fi/helpcontent2/source/text/shared/01.po b/source/fi/helpcontent2/source/text/shared/01.po
index 3779753e74c..feddd711438 100644
--- a/source/fi/helpcontent2/source/text/shared/01.po
+++ b/source/fi/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2020-06-05 22:27+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textshared01/fi/>\n"
@@ -49327,13 +49327,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
@@ -49525,13 +49525,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/fi/helpcontent2/source/text/shared/05.po b/source/fi/helpcontent2/source/text/shared/05.po
index 9a80792c0ad..7f2048d8a7b 100644
--- a/source/fi/helpcontent2/source/text/shared/05.po
+++ b/source/fi/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: 2020-07-28 14:35+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textshared05/fi/>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Weblate 4.1.1\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1540152953.000000\n"
 
 #. WPTtk
@@ -1280,22 +1280,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/fi/helpcontent2/source/text/shared/optionen.po b/source/fi/helpcontent2/source/text/shared/optionen.po
index cdc53269fff..1c58f2fdd71 100644
--- a/source/fi/helpcontent2/source/text/shared/optionen.po
+++ b/source/fi/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2020-05-23 22:45+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedoptionen/fi/>\n"
@@ -8082,6 +8082,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 "Sanamäärää laskettaessa näitä merkkejä pidetään sanojen välisinä erotinmerkkeinä välilyöntien, sarkainmerkkien, rivivaihtomerkkien ja kappalevaihtomerkkien lisäksi."
 
+#. 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/fi/helpcontent2/source/text/swriter/01.po b/source/fi/helpcontent2/source/text/swriter/01.po
index ee3efbb56cc..e9a2ebc74a7 100644
--- a/source/fi/helpcontent2/source/text/swriter/01.po
+++ b/source/fi/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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:15+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Finnish <discuss@fi.libreoffice.org>\n"
@@ -13678,6 +13678,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 "Etsi ja korvaa -valintaikkunan Etsi kaikki -painiketta voidaan käyttää korostamaan kaikki sanan esiintymät ja sitten voidaan avata Lisää hakemistomerkintä -valintaikkuna tämän sanan lisäämiseksi ja sijoittamiseksi aakkoselliseen hakemistoon. Jos kuitenkin tarvitaan samaa aakkosellista hakemistoa useissa asiakirjoissa, vastaavuustiedosto tekee mahdolliseksi sanan syöttämisen vain kerran ja sitten sen käyttämisen useita kertoja."
 
+#. 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 ""
@@ -13732,6 +13741,33 @@ msgctxt ""
 msgid "A concordance file contains the following fields:"
 msgstr "Vastaavuustiedostossa on seuraavat kentät:"
 
+#. 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 ""
@@ -13741,6 +13777,15 @@ msgctxt ""
 msgid "\"Search term\" refers to the index entry that you want to mark in the document."
 msgstr "\"Etsittävä termi\" viittaa hakemistomerkintään, joka merkitään asiakirjasta."
 
+#. CEahq
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id811599006053151\n"
+"help.text"
+msgid "Alternative entry"
+msgstr ""
+
 #. rxooN
 #: 04120250.xhp
 msgctxt ""
@@ -13750,6 +13795,15 @@ msgctxt ""
 msgid "\"Alternative entry\" refers to the index entry that you want to appear in the index."
 msgstr "\"Vaihtoehtoinen merkintä\" viittaa hakemistomerkintään sellaisena, kuin se näkyy hakemistossa."
 
+#. q3DFC
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id661599006090921\n"
+"help.text"
+msgid "1st and 2nd Keys"
+msgstr ""
+
 #. VRBtF
 #: 04120250.xhp
 msgctxt ""
@@ -13759,6 +13813,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 "Avaimet 1 ja 2 ovat isähakemiston merkintöjä. \"Etsittävä termi\" tai \"Vaihtoehtoinen merkintä\" näkyvät alakohtina 1. ja 2. avaimelle."
 
+#. 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 ""
@@ -13768,6 +13849,15 @@ msgctxt ""
 msgid "\"Match case\" means that uppercase and lowercase letters are considered."
 msgstr "\"Sama kirjainkoko\" tarkoittaa, että suur- ja pienaakkoset katsotaan eri kirjaimiksi."
 
+#. 9Zvp6
+#: 04120250.xhp
+msgctxt ""
+"04120250.xhp\n"
+"par_id361599006161460\n"
+"help.text"
+msgid "Word only"
+msgstr ""
+
 #. hFig3
 #: 04120250.xhp
 msgctxt ""
@@ -13831,14 +13921,14 @@ msgctxt ""
 msgid "Use the following format for the entries:"
 msgstr "Käytä merkinnöille seuraavaa muotoilua:"
 
-#. 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 "Etsittävä termi;Vaihtoehtoinen merkintä;1. avain;2. avain;Sama kirjainkoko;Vain sana"
+msgid "<literal>Search term;Alternative entry;1st key;2nd key;Match case;Word only</literal>"
+msgstr ""
 
 #. FWVnU
 #: 04120250.xhp
@@ -13867,14 +13957,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 "Esimerkiksi sanan \"Boston\" sisällyttäminen aakkoselliseen hakemistoon \"Kaupungit\"-merkinnän alle, syötetään seuraava rivi vastaavuustiedostoon:"
 
-#. BqcRU
+#. hqr4T
 #: 04120250.xhp
 msgctxt ""
 "04120250.xhp\n"
 "par_id3151370\n"
 "help.text"
-msgid "Boston;Boston;Cities;;0;0"
-msgstr "Boston;Boston;Kaupungit;;0;0"
+msgid "<literal>Boston;Boston;Cities;;0;0</literal>"
+msgstr ""
 
 #. NQkQN
 #: 04120250.xhp
@@ -13894,14 +13984,14 @@ msgctxt ""
 msgid "To include the \"Beacon Hill\" district in Boston under the \"Cities\" entry, enter the following line:"
 msgstr "\"Nummenkylä\"-alueen sisällyttämiseksi Järvenpäähän \"Kaupungit\"-merkinnän alle syötetään seuraava rivi:"
 
-#. MiuPA
+#. J8EX4
 #: 04120250.xhp
 msgctxt ""
 "04120250.xhp\n"
 "par_id3150116\n"
 "help.text"
-msgid "Beacon Hill;Boston;Cities;"
-msgstr "Nummenkylä;Järvenpää;Kaupungit;"
+msgid "<literal>Beacon Hill;Boston;Cities;</literal>"
+msgstr ""
 
 #. aG6Cj
 #: 04120300.xhp