final update of translations for 6.2.0 beta1

and force-fix using pocheck

Change-Id: I355e7331efc15474a5b4e8277d8c375b5cac7c42

5 files changed, 314 insertions, 31 deletions

diff --git a/source/lv/helpcontent2/source/text/sbasic/shared.po b/source/lv/helpcontent2/source/text/sbasic/shared.po
index 32c6abc8c32..b8a29f02e24 100644
--- a/source/lv/helpcontent2/source/text/sbasic/shared.po
+++ b/source/lv/helpcontent2/source/text/sbasic/shared.po
@@ -3,9 +3,9 @@ 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: 2018-10-21 20:57+0200\n"
-"PO-Revision-Date: 2017-02-16 17:19+0000\n"
-"Last-Translator: Ingmārs Dīriņš <melhiors14@gmail.com>\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
+"PO-Revision-Date: 2018-10-21 20:25+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: lv\n"
 "MIME-Version: 1.0\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1487265585.000000\n"
+"X-POOTLE-MTIME: 1540153547.000000\n"
 
 #: 00000002.xhp
 msgctxt ""
@@ -15275,6 +15275,30 @@ msgstr ""
 #: 03040000.xhp
 msgctxt ""
 "03040000.xhp\n"
+"par_id671542197262160\n"
+"help.text"
+msgid "Part of vbTriState enumeration."
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id351542197255532\n"
+"help.text"
+msgid "Part of vbTriState enumeration."
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id251542197274514\n"
+"help.text"
+msgid "Part of vbTriState enumeration."
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
 "par_id611512313731233\n"
 "help.text"
 msgid "CR - Carriage return"
@@ -34936,6 +34960,158 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060106.xhp#bm_id3158121\">Calc ROUND function</link>"
 msgstr ""
 
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"tit\n"
+"help.text"
+msgid "FormatNumber Function [VBA]"
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"bm_id661542193659245\n"
+"help.text"
+msgid "<bookmark_value>FormatNumber function</bookmark_value>"
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"hd_id871542193473857\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03170010.xhp\" name=\"FormatNumber Function [VBA]\">FormatNumber [VBA]</link>"
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id351542193473858\n"
+"help.text"
+msgid "Returns a string with a number formatting applied to a numeric expression."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id761542194361212\n"
+"help.text"
+msgid "String"
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>expression</emph>: Required. The numeric expression to be formatted."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id631542195798758\n"
+"help.text"
+msgid "<emph>numDigitsAfterDecimal</emph>: Optional. A numeric value specifying the number of digits that should be displayed after the decimal. If omitted, it defaults to the value -1, meaning that the default settings for user interface  locale should be used."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id961542200034362\n"
+"help.text"
+msgid "<emph>includeLeadingDigit</emph>: Optional. A <link href=\"text/sbasic/shared/03040000.xhp#addvbaconstants\" name=\"vbtristate\">vbTriState</link> enumeration value, specifying whether a leading zero should be displayed for fractional values."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id561542198440051\n"
+"help.text"
+msgid "<emph>vbTrue or -1</emph>: Display a leading zero."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id21542198550868\n"
+"help.text"
+msgid "<emph>vbFalse or 0</emph>: Do not display leading zeros."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id241542199046808\n"
+"help.text"
+msgid "<emph>vbUseDefaults or -2</emph>: Use the user interface locale settings. This is the default when omitted."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id311542201637647\n"
+"help.text"
+msgid "<emph>useParensForNegativeNumbers</emph>: Optional. A <link href=\"text/sbasic/shared/03040000.xhp#addvbaconstants\" name=\"vbtristate\">vbTriState</link> enumeration value  specifying whether negative numbers should be encased in parenthesis."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id561543198440051\n"
+"help.text"
+msgid "<emph>vbTrue or -1</emph>: Use parenthesis for negative numbers."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id21542398550868\n"
+"help.text"
+msgid "<emph>vbFalse or 0</emph>: Do not display parenthesis."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id241542191246808\n"
+"help.text"
+msgid "<emph>vbUseDefaults or -2</emph>: Same as vbFalse. This is the default when omitted."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id531542201968815\n"
+"help.text"
+msgid "<emph>groupDigits</emph>: Optional. A <link href=\"text/sbasic/shared/03040000.xhp#addvbaconstants\" name=\"vbtristate\">vbTriState</link> enumeration value  specifying the number should be grouped (into thousands, etc.), using the group delimiter that is specified on the system's regional settings."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id561543198560051\n"
+"help.text"
+msgid "<emph>vbTrue or -1</emph>: Group digits."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id215423985506768\n"
+"help.text"
+msgid "<emph>vbFalse or 0</emph>: Do not group digits."
+msgstr ""
+
+#: 03170010.xhp
+msgctxt ""
+"03170010.xhp\n"
+"par_id241542191267808\n"
+"help.text"
+msgid "<emph>vbUseDefaults or -2</emph>: Same as vbFalse. This is the default when omitted."
+msgstr ""
+
 #: 05060700.xhp
 msgctxt ""
 "05060700.xhp\n"
@@ -35749,7 +35925,7 @@ msgctxt ""
 "special_vba_func.xhp\n"
 "bm_id051920170358346963\n"
 "help.text"
-msgid "<bookmark_value>VBA Functions;Mathematical Functions</bookmark_value>"
+msgid "<bookmark_value>VBA Functions;Mathematical Functions</bookmark_value>  <bookmark_value>VBA Functions;formatting numbers</bookmark_value>"
 msgstr ""
 
 #: special_vba_func.xhp
diff --git a/source/lv/helpcontent2/source/text/scalc/01.po b/source/lv/helpcontent2/source/text/scalc/01.po
index 3d6cb7e6670..9480326729b 100644
--- a/source/lv/helpcontent2/source/text/scalc/01.po
+++ b/source/lv/helpcontent2/source/text/scalc/01.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-11-12 12:22+0100\n"
-"PO-Revision-Date: 2016-12-22 19:31+0000\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
+"PO-Revision-Date: 2018-11-12 13:52+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: lv\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1482435080.000000\n"
+"X-POOTLE-MTIME: 1542030748.000000\n"
 
 #: 01120000.xhp
 msgctxt ""
@@ -55120,6 +55120,118 @@ msgctxt ""
 msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765)</item> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
 msgstr ""
 
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"tit\n"
+"help.text"
+msgid "REGEX Function"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"bm_id831542233029549\n"
+"help.text"
+msgid "<bookmark_value>REGEX function</bookmark_value>            <bookmark_value>regular expressions;extracting in spreadsheets</bookmark_value>            <bookmark_value>regular expressions;REGEX function</bookmark_value>"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"hd_id961542230672100\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/func_regex.xhp\" name=\"function REGEX\">REGEX</link>"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id541542230672101\n"
+"help.text"
+msgid "<variable id=\"func_regex_desc\"><ahelp hid=\".\">Matches and extracts or optionally replaces text using regular expressions.</ahelp></variable>"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "REGEX( Text ; Expression [ ; [ Replacement ] [ ; Flags ] ] )"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id621542232197446\n"
+"help.text"
+msgid "<emph>Text</emph>: A text or reference to a cell where the regular expression is to be applied."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id211542232209275\n"
+"help.text"
+msgid "<emph>Expression</emph>: A text representing the regular expression, using <link href=\"https://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>. If there is no match, #N/A is returned."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id581542232755604\n"
+"help.text"
+msgid "<emph>Replacement</emph>: Optional. The replacement text and references to capture groups. If there is no match, <emph>Text</emph> is returned unmodified."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id421542232246840\n"
+"help.text"
+msgid "<emph>Flags</emph>: Optional. \"g\" replaces all matches of <emph>Expression</emph> in <emph>Text</emph>, not extracted. If there is no match, <emph>Text</emph> is returned unmodified."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id371542291684176\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\")</item>  returns \"Z23456ABCDEF\", where the first match of a digit is replaced by \"Z\"."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id891542291697194\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\";\"g\")</item>  returns \"ZZZZZZABCDEF\", where all digits were replaced by \"Z\"."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id21542291705695\n"
+"help.text"
+msgid "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[1|2|6]\";\"\";\"g\")</item>  returns \"345ABCDEF\", where any occurrence of \"1\", \"2\" or \"6\" is replaced by the empty string, thus deleted."
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id711542233602553\n"
+"help.text"
+msgid "<link href=\"text/shared/01/02100001.xhp\" name=\"regex lists\">List of regular expressions</link>"
+msgstr ""
+
+#: func_regex.xhp
+msgctxt ""
+"func_regex.xhp\n"
+"par_id431542233650614\n"
+"help.text"
+msgid "<link href=\"https://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>"
+msgstr ""
+
 #: func_roundsig.xhp
 msgctxt ""
 "func_roundsig.xhp\n"
diff --git a/source/lv/helpcontent2/source/text/shared/guide.po b/source/lv/helpcontent2/source/text/shared/guide.po
index bae41e067bd..8a98eba3439 100644
--- a/source/lv/helpcontent2/source/text/shared/guide.po
+++ b/source/lv/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-11-14 12:22+0100\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1542197098.000000\n"
 
 #: aaa_start.xhp
@@ -17437,7 +17437,7 @@ msgctxt ""
 "start_parameters.xhp\n"
 "par_id315053o\n"
 "help.text"
-msgid "Forces an input filter type, if possible. For example:<br/><item type=\"input\">--infilter=\"Calc Office Open XML\"</item><br/><item type=\"input\">--infilter=\"Text (encoded):UTF8,LF,,,.\"</item>"
+msgid "Forces an input filter type, if possible. For example:<br/><item type=\"input\">--infilter=\"Calc Office Open XML\"</item><br/><item type=\"input\">--infilter=\"Text (encoded):UTF8,LF,Liberation Mono,en-US\"</item>."
 msgstr ""
 
 #: start_parameters.xhp
diff --git a/source/lv/helpcontent2/source/text/shared/help.po b/source/lv/helpcontent2/source/text/shared/help.po
index 05cb3c26e39..97bd2eddc2c 100644
--- a/source/lv/helpcontent2/source/text/shared/help.po
+++ b/source/lv/helpcontent2/source/text/shared/help.po
@@ -3,15 +3,18 @@ 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: 2018-11-12 12:23+0100\n"
-"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
-"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
+"PO-Revision-Date: 2018-11-12 13:52+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
+"Language: lv\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1542030760.000000\n"
 
 #: browserhelp.xhp
 msgctxt ""
@@ -50,7 +53,7 @@ msgctxt ""
 "browserhelp.xhp\n"
 "par_id601525734140935\n"
 "help.text"
-msgid "<variable id=\"index\">Index of chosen module</variable>"
+msgid "<variable id=\"index\">Index</variable>"
 msgstr ""
 
 #: browserhelp.xhp
diff --git a/source/lv/helpcontent2/source/text/shared/optionen.po b/source/lv/helpcontent2/source/text/shared/optionen.po
index 72bf93bd709..40ed51739cf 100644
--- a/source/lv/helpcontent2/source/text/shared/optionen.po
+++ b/source/lv/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: 2018-11-14 12:22+0100\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n != 0 ? 1 : 2);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1542197099.000000\n"
 
 #: 01000000.xhp
@@ -14837,7 +14837,7 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361088\n"
 "help.text"
-msgid "Pre-installed theme (if available)"
+msgid "Preinstalled theme"
 msgstr ""
 
 #: persona_firefox.xhp
@@ -14845,7 +14845,7 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "par_id1309201511361194\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/personalization_tab/default_persona\">Display the system theme, if available.</ahelp>Your system administrator may have added a global (system-wide) theme during the %PRODUCTNAME installation. This option will display it."
+msgid "<ahelp hid=\"cui/ui/personalization_tab/default_persona\">Choose this option to use one of the preinstalled themes.</ahelp> In addition to the default options, your system administrator may have added a custom theme during the %PRODUCTNAME installation. This option will display it."
 msgstr ""
 
 #: persona_firefox.xhp
@@ -14885,7 +14885,7 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361084\n"
 "help.text"
-msgid "Custom Search"
+msgid "Search"
 msgstr ""
 
 #: persona_firefox.xhp
@@ -14893,7 +14893,7 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "par_id1309201511361068\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/select_persona_dialog/search_term\">Type or paste the URL of the theme’s webpage.</ahelp> To get the URL, navigate with your browser to the theme’s webpage and copy the URL displayed in the navigation bar of your browser. Then paste it in the dialog’s text box. Click the <item type=\"menuitem\">Search</item> button to download and install it in %PRODUCTNAME."
+msgid "<ahelp hid=\"cui/ui/select_persona_dialog/search_term\">Provide a search term to look for themes from Mozilla’s add-ons site, or paste in a theme address to retrieve a specific theme directly.</ahelp> To get the address, use your browser to navigate to the theme’s web page and copy the URL displayed in the address bar. Then, paste it in the dialog’s search box. Click <item type=\"menuitem\">Search</item> or press <item type=\"keycode\">Enter</item> to download and install it in %PRODUCTNAME."
 msgstr ""
 
 #: persona_firefox.xhp
@@ -14901,8 +14901,8 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361099\n"
 "help.text"
-msgid "Suggested Themes by Category"
-msgstr "Ieteiktie motīvi pēc kategorijas"
+msgid "Exploring themes by category"
+msgstr ""
 
 #: persona_firefox.xhp
 msgctxt ""
@@ -14928,14 +14928,6 @@ msgctxt ""
 msgid "To select one of the displayed themes, click on its image and press <item type=\"menuitem\">OK</item>."
 msgstr ""
 
-#: persona_firefox.xhp
-msgctxt ""
-"persona_firefox.xhp\n"
-"par_id1309201511361094\n"
-"help.text"
-msgid "Since the themes will be fetched from the Mozilla Firefox theme website, you may have to wait some time to have all nine themes image filled. Please be patient."
-msgstr ""
-
 #: securityoptionsdialog.xhp
 msgctxt ""
 "securityoptionsdialog.xhp\n"