final update of translations for 6.2.0 beta1

and force-fix using pocheck

Change-Id: I355e7331efc15474a5b4e8277d8c375b5cac7c42

5 files changed, 318 insertions, 35 deletions

diff --git a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po b/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po
index cb40d1917e5..672bcc6e533 100644
--- a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ca-valencia/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: 2018-01-15 13:19+0000\n"
-"Last-Translator: joamuran <joamuran@gmail.com>\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
+"PO-Revision-Date: 2018-10-21 20:06+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ca-valencia\n"
 "MIME-Version: 1.0\n"
@@ -15,7 +15,7 @@ msgstr ""
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
 "X-Language: ca-XV\n"
-"X-POOTLE-MTIME: 1516022361.000000\n"
+"X-POOTLE-MTIME: 1540152382.000000\n"
 
 #: 00000002.xhp
 msgctxt ""
@@ -15276,6 +15276,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"
@@ -34937,6 +34961,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"
@@ -35750,7 +35926,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/ca-valencia/helpcontent2/source/text/scalc/01.po b/source/ca-valencia/helpcontent2/source/text/scalc/01.po
index 8b817584944..1b093b14d6a 100644
--- a/source/ca-valencia/helpcontent2/source/text/scalc/01.po
+++ b/source/ca-valencia/helpcontent2/source/text/scalc/01.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-11-12 12:22+0100\n"
-"PO-Revision-Date: 2018-01-15 13:19+0000\n"
-"Last-Translator: joamuran <joamuran@gmail.com>\n"
+"POT-Creation-Date: 2018-11-16 22:41+0100\n"
+"PO-Revision-Date: 2018-11-12 13:23+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ca-valencia\n"
 "MIME-Version: 1.0\n"
@@ -15,7 +15,7 @@ msgstr ""
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
 "X-Language: ca-XV\n"
-"X-POOTLE-MTIME: 1516022392.000000\n"
+"X-POOTLE-MTIME: 1542028997.000000\n"
 
 #: 01120000.xhp
 msgctxt ""
@@ -55121,6 +55121,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/ca-valencia/helpcontent2/source/text/shared/guide.po b/source/ca-valencia/helpcontent2/source/text/shared/guide.po
index 95b07f0f72f..1563fdae3bc 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/guide.po
+++ b/source/ca-valencia/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 11:53+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=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Language: ca-XV\n"
 "X-POOTLE-MTIME: 1542196426.000000\n"
 
@@ -17438,7 +17438,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/ca-valencia/helpcontent2/source/text/shared/help.po b/source/ca-valencia/helpcontent2/source/text/shared/help.po
index 05cb3c26e39..964e069bb90 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/help.po
+++ b/source/ca-valencia/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:23+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
+"Language: ca-valencia\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1542029017.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/ca-valencia/helpcontent2/source/text/shared/optionen.po b/source/ca-valencia/helpcontent2/source/text/shared/optionen.po
index 273152b7981..b38e3d54356 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/optionen.po
+++ b/source/ca-valencia/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 11:53+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=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Language: ca-XV\n"
 "X-POOTLE-MTIME: 1542196428.000000\n"
 
@@ -14838,16 +14838,16 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361088\n"
 "help.text"
-msgid "Pre-installed theme (if available)"
-msgstr "Tema preinstal·lat (si està disponible)"
+msgid "Preinstalled theme"
+msgstr ""
 
 #: persona_firefox.xhp
 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."
-msgstr "<ahelp hid=\"cui/ui/personalization_tab/default_persona\">Mostra el tema del sistema, si està disponible. </ahelp>El vostre administrador del sistema pot haver afegit un tema global (en tot el sistema) durant la instal·lació del %PRODUCTNAME. Esta opció el mostrarà."
+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
 msgctxt ""
@@ -14886,15 +14886,15 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361084\n"
 "help.text"
-msgid "Custom Search"
-msgstr "Busca personalitzada"
+msgid "Search"
+msgstr ""
 
 #: persona_firefox.xhp
 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
@@ -14902,8 +14902,8 @@ msgctxt ""
 "persona_firefox.xhp\n"
 "hd_id1309201511361099\n"
 "help.text"
-msgid "Suggested Themes by Category"
-msgstr "Temes suggerits per categoria"
+msgid "Exploring themes by category"
+msgstr ""
 
 #: persona_firefox.xhp
 msgctxt ""
@@ -14929,14 +14929,6 @@ msgctxt ""
 msgid "To select one of the displayed themes, click on its image and press <item type=\"menuitem\">OK</item>."
 msgstr "Per seleccionar un dels temes mostrats, feu clic a la seua imatge i premeu <item type=\"menuitem\">D'acord</item>."
 
-#: 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"