update translations for master

and force-fix errors using pocheck Change-Id: I9bbea708cab941400c98f6a83b67215bb19469fa
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-04-29 23:23:16 +0200
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2020-04-29 23:28:46 +0200
commit: 2a61ce8496f6a5633af3ec710882358c3836abd0 (patch)
tree: e7ce6b15f564f773937ba697696b6f89aea04667 /source/ca-valencia/helpcontent2
parent: 6b2e705c5e47924cfa7c0ae90ab9d5d69cf87cb8 (diff)
15 files changed, 858 insertions, 760 deletions
diff --git a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po b/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po
index aadd9b007fd..0a2fd534ca3 100644
--- a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ca-valencia/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-04-15 12:52+0200\n"
+"POT-Creation-Date: 2020-04-29 22:17+0200\n"
 "PO-Revision-Date: 2018-10-21 20:06+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -9224,14 +9224,14 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03010305.xhp\" name=\"RGB Function\">RGB Function</link>"
 msgstr ""
 
-#. 7ME9i
+#. iRBsy
 #: 03010305.xhp
 msgctxt ""
 "03010305.xhp\n"
 "par_id3150447\n"
 "help.text"
-msgid "Returns a <link href=\"text/sbasic/shared/00000003.xhp#farbcodes\" name=\"long integer color value\">long integer color value</link> consisting of red, green, and blue components."
-msgstr "Torna un <link href=\"text/sbasic/shared/00000003.xhp#farbcodes\" name=\"valor de color d'enter llarg\">valor de color d'enter llarg</link> que consta de components rojos, verds i blaus."
+msgid "Returns a <literal>Long</literal> integer color value consisting of red, green, and blue components."
+msgstr ""
 
 #. MiCPe
 #: 03010305.xhp
@@ -9305,6 +9305,15 @@ msgctxt ""
 msgid "<emph>Blue</emph>: Any integer expression that represents the blue component (0-255) of the composite color."
 msgstr "<emph>Blau</emph>: Qualsevol expressió d'enter que representa el component blau (0-255) del color compost."
 
+#. dFrtY
+#: 03010305.xhp
+msgctxt ""
+"03010305.xhp\n"
+"par_id211587653651037\n"
+"help.text"
+msgid "The <link href=\"text/shared/optionen.xhp/01010501.xhp\" name=\"color picker dialog\">color picker dialog</link> helps computing red, green and blue components of a composite color. <link href=\"text/shared/guide/text_color.xhp\" name=\"Changing the color of text\">Changing the color of text</link> and selecting <emph>Custom color</emph> displays the color picker dialog."
+msgstr ""
+
 #. Vn6Jr
 #: 03010305.xhp
 msgctxt ""
@@ -13886,13 +13895,13 @@ msgctxt ""
 msgid "<bookmark_value>WeekDay function</bookmark_value>"
 msgstr "<bookmark_value>Funció WeekDay</bookmark_value>"
 
-#. qnjFp
+#. QNFTv
 #: 03030105.xhp
 msgctxt ""
 "03030105.xhp\n"
 "hd_id3153127\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03030105.xhp\" name=\"WeekDay Function\">WeekDay Function</link>"
+msgid "<link href=\"text/sbasic/shared/03030105.xhp\" name=\"WeekDay Function\">WeekDay Function (BASIC)</link>"
 msgstr ""
 
 #. UpMwa
@@ -13904,15 +13913,6 @@ msgctxt ""
 msgid "Returns the number corresponding to the weekday represented by a serial date number that is generated by the DateSerial or the DateValue function."
 msgstr "Torna el número corresponent al dia de la setmana representat per un número de data de sèrie que es genera amb les funcions DateSerial o DateValue."
 
-#. MDM2Q
-#: 03030105.xhp
-msgctxt ""
-"03030105.xhp\n"
-"hd_id3145068\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaxi:"
-
 #. ExFvM
 #: 03030105.xhp
 msgctxt ""
@@ -13922,15 +13922,6 @@ msgctxt ""
 msgid "WeekDay (Number)"
 msgstr "DiaSetmana (Nombre)"
 
-#. WqJFm
-#: 03030105.xhp
-msgctxt ""
-"03030105.xhp\n"
-"hd_id3148799\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valor de retorn:"
-
 #. CPXVo
 #: 03030105.xhp
 msgctxt ""
@@ -13940,15 +13931,6 @@ msgctxt ""
 msgid "Integer"
 msgstr "Enter"
 
-#. rd8BW
-#: 03030105.xhp
-msgctxt ""
-"03030105.xhp\n"
-"hd_id3150768\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paràmetres:"
-
 #. tC2Mw
 #: 03030105.xhp
 msgctxt ""
@@ -13967,15 +13949,6 @@ msgctxt ""
 msgid "The following example determines the day of the week using the WeekDay function when you enter a date."
 msgstr "A l'exemple següent es determina el dia de la setmana amb la funció WeekDay que introduïu una data."
 
-#. hgfzk
-#: 03030105.xhp
-msgctxt ""
-"03030105.xhp\n"
-"hd_id3148616\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple:"
-
 #. bR8LQ
 #: 03030105.xhp
 msgctxt ""
@@ -25442,6 +25415,15 @@ msgctxt ""
 msgid "A Type structure is an ordered collection of data fields, that can be manipulated as a single item."
 msgstr ""
 
+#. WfsVY
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/Type_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Type statement diagram</alt></image>"
+msgstr ""
+
 #. TTALN
 #: 03090413.xhp
 msgctxt ""
@@ -27629,122 +27611,122 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03102100.xhp\" name=\"Dim Statement\">Dim Statement</link>"
 msgstr ""
 
-#. bm7E7
+#. 9gRSS
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3143271\n"
 "help.text"
-msgid "Declares a variable or an array."
-msgstr "Declara una variable o una matriu."
+msgid "Declares variables or arrays."
+msgstr ""
 
-#. QpjCG
+#. vWsXg
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3154686\n"
 "help.text"
-msgid "If the variables are separated by commas (for example, DIM sPar1, sPar2, sPar3 AS STRING), only Variant variables can be defined. Use a separate definition line for each variable."
-msgstr "Si les variables estan separades per comes (per exemple, DIM sPar1, sPar2, sPar3 AS STRING), només les variables Variant es poden definir. Utilitzeu una línia de definició separada per a cada variable."
+msgid "If the variables are separated by commas - for example <literal>Dim sPar1, sPar2, sPar3 As String</literal> - first ones get defined as Variant variables. A new line, or colon sign (<emph>:</emph>), help separate variable definitions."
+msgstr ""
 
-#. pGPXy
+#. sZ9H8
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3152576\n"
 "help.text"
-msgid "Dim declares local variables within subroutines. Global variables are declared with the PUBLIC or the PRIVATE statement."
-msgstr "Dim declara les variables locals dins de subrutines. Les variables globals es declaren amb les expressions PUBLIC o PRIVATE."
+msgid "<literal>Dim</literal> declares local variables within subroutines. Global variables are declared with the <literal>Global</literal>, <literal>Public</literal> or the <literal>Private</literal> statement."
+msgstr ""
 
-#. BZADe
+#. RWfkr
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"hd_id3156443\n"
+"par_id971587473488701\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaxi:"
+msgid "<image src=\"media/helpimg/sbasic/Dim_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Dim Statement diagram</alt></image>"
+msgstr ""
 
-#. gcgux
+#. yKMdt
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3149412\n"
 "help.text"
-msgid "[ReDim]Dim VarName [(start To end)] [As VarType][, VarName2 [(start To end)] [As VarType][,...]]"
-msgstr "[ReDim]Dim VarName [(start To end)] [As VarType][, VarName2 [(start To end)] [As VarType][,...]]"
+msgid "Dim variable [(start To end)] [As type-name][, variable2[type-char] [(start To end)] [,...]]"
+msgstr ""
 
-#. DF2ha
+#. JBuCh
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"hd_id3147397\n"
+"par_id3154730\n"
 "help.text"
-msgid "Parameters:"
-msgstr "Paràmetres:"
+msgid "<emph>variable:</emph> Any variable or array name."
+msgstr ""
 
-#. qPBJU
+#. BaEsN
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3154730\n"
+"par_id3147125\n"
 "help.text"
-msgid "<emph>VarName:</emph> Any variable or array name."
-msgstr "<emph>VarName:</emph> Qualsevol nom de variable o de matriu."
+msgid "<emph>start, end:</emph> Numerical values or constants that define the number of elements (NumberElements=(end-start)+1) and the index range."
+msgstr ""
 
-#. PPY3B
+#. T2g5D
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3147125\n"
+"par_id3153877\n"
 "help.text"
-msgid "<emph>Start, End:</emph> Numerical values or constants that define the number of elements (NumberElements=(end-start)+1) and the index range."
-msgstr "<emph>Start, End:</emph> Valors numèrics o constants que defineixen el nombre d'elements (NombreElements=(fi-inici)+1) i l'interval d'índex."
+msgid "<emph>start</emph> and <emph>end</emph> can be numerical expressions if <literal>ReDim</literal> is applied at the procedure level."
+msgstr ""
 
-#. 3GDzQ
+#. upQJe
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3153877\n"
+"par_id3154510\n"
 "help.text"
-msgid "Start and End can be numerical expressions if ReDim is applied at the procedure level."
-msgstr "Start i End poden ser expressions numèriques si ReDim s'aplica al nivell de procediment."
+msgid "<emph>type-name:</emph> Keyword that declares the data type of a variable."
+msgstr ""
 
-#. oTp9v
+#. HDgeB
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3153510\n"
+"par_id971587473508701\n"
 "help.text"
-msgid "<emph>VarType:</emph> Key word that declares the data type of a variable."
-msgstr "<emph>VarType:</emph> Paraula clau que declara els tipus de dades d'una variable."
+msgid "<image src=\"media/helpimg/sbasic/type-name_fragment.svg\" id=\"img_id4156296484515\"><alt id=\"alt_id15152796484515\">primitive data types fragment</alt></image>"
+msgstr ""
 
-#. ESbgw
+#. pFWdb
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3154015\n"
+"par_id21587557790810\n"
 "help.text"
-msgid "<emph>Keyword:</emph> Variable type"
-msgstr "<emph>Paraula clau:</emph> Tipus de variable"
+msgid "<emph>Byte:</emph> Byte variable (0-255)"
+msgstr ""
 
-#. ybpn5
+#. fQsgi
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3153949\n"
 "help.text"
-msgid "<emph>Bool:</emph> Boolean variable (True, False)"
-msgstr "<emph>Bool:</emph> Variable booleana (Cert, Fals)"
+msgid "<emph>Boolean:</emph> Boolean variable (True, False)"
+msgstr ""
 
-#. hB7hK
+#. PouUE
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3156275\n"
 "help.text"
-msgid "<emph>Currency:</emph> Currency-Variable (Currency with 4 Decimal places)"
-msgstr "<emph>Currency:</emph> Variable Currency (Currency amb 4 llocs decimals)"
+msgid "<emph>Currency:</emph> Currency variable (Currency with 4 Decimal places)"
+msgstr ""
 
 #. BHPpy
 #: 03102100.xhp
@@ -27755,14 +27737,14 @@ msgctxt ""
 msgid "<emph>Date:</emph> Date variable"
 msgstr "<emph>Data:</emph> Variable de data"
 
-#. D43GE
+#. jyVtV
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3148405\n"
 "help.text"
-msgid "<emph>Double:</emph> Double-precision floating-point variable (1,79769313486232 x 10E308 - 4,94065645841247 x 10E-324)"
-msgstr "<emph>Double:</emph> Variable de coma flotant de precisió doble (1,79769313486232 x 10E308 - 4,94065645841247 x 10E-324)"
+msgid "<emph>Double:</emph> Double-precision floating-point variable (1,79769313486232 x 10E308 - 4,94065645841247 x 10E-324)"
+msgstr ""
 
 #. kBUDz
 #: 03102100.xhp
@@ -27782,14 +27764,14 @@ msgctxt ""
 msgid "<emph>Long:</emph> Long integer variable (-2.147.483.648 - 2.147.483.647)"
 msgstr "<emph>Long:</emph> Variable d'enter llarga (-2.147.483.648 - 2.147.483.647)"
 
-#. gFGxF
+#. z9CEA
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3149255\n"
 "help.text"
-msgid "<emph>Object:</emph> Object variable (Note: this variable can only subsequently be defined with Set!)"
-msgstr "<emph>Object:</emph> Variable d'objecte (Nota: esta variable només es pot definir posteriorment amb Set!)"
+msgid "<emph>Object:</emph> Object variable (Note: this variable can only subsequently be defined with <literal>Set</literal>!)"
+msgstr ""
 
 #. iBZ3a
 #: 03102100.xhp
@@ -27809,122 +27791,149 @@ msgctxt ""
 msgid "<emph>String:</emph> String variable consisting of a maximum of 64,000 ASCII characters."
 msgstr "<emph>Cadena:</emph> Variable de cadena que consta d'un màxim de 64.000 caràcters ASCII."
 
-#. j63Bt
+#. UkswY
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3154704\n"
 "help.text"
-msgid "<emph>[Variant]:</emph> Variant variable type (contains all types, specified by definition). If a key word is not specified, variables are automatically defined as Variant Type, unless a statement from DefBool to DefVar is used."
-msgstr "<emph>[Variant]:</emph> Tipus de variable de variant (conté tots els tipus, especificats per definició). Si no s'especifica una paraula clau, les variables es defineixen automàticament com a tipus variant, a menys que s'utilitze una expressió de DefBool a DefVar."
+msgid "<emph>Variant:</emph> Variant variable type (contains all types, specified by definition). If a type name is not specified, variables are automatically defined as Variant Type, unless a statement from <literal>DefBool</literal> to <literal>DefVar</literal> is used."
+msgstr ""
 
-#. cyiCt
+#. DPnaK
+#: 03102100.xhp
+msgctxt ""
+"03102100.xhp\n"
+"par_id3153510\n"
+"help.text"
+msgid "<emph>type-char:</emph> Special character that declares the data type of a variable."
+msgstr ""
+
+#. bCFDG
+#: 03102100.xhp
+msgctxt ""
+"03102100.xhp\n"
+"par_id971587473518701\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/type-car_fragment.svg\" id=\"img_id4156296484516\"><alt id=\"alt_id15152796484516\">Type declaration characters fragment</alt></image>"
+msgstr ""
+
+#. JgnAC
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "par_id3146316\n"
 "help.text"
-msgid "In $[officename] Basic, you do not need to declare variables explicitly. However, you need to declare an array before you can use them. You can declare a variable with the Dim statement, using commas to separate multiple declarations. To declare a variable type, enter a type-declaration character following the name or use a corresponding key word."
-msgstr "Al $[officename] Basic no cal que declareu les variables explícitament. No obstant això, cal que declareu una matriu abans de poder utilitzar-les. Podeu declarar una variable amb l'expressió Dim, fent servir comes per separar múltiples declaracions. Per declarar un tipus de variable, introduïu un caràcter de declaració de tipus després del nom, o utilitzeu la paraula clau corresponent."
+msgid "In %PRODUCTNAME Basic, you do not need to declare variables explicitly. However, you need to declare arrays before you can use them. You can declare a variable with the <literal>Dim</literal> statement, using commas (<emph>,</emph>) to separate multiple declarations. To declare a variable type, enter a type-declaration character following the name or use a corresponding type keyword name."
+msgstr ""
 
-#. JkDDD
+#. XodQr
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3149924\n"
+"par_id411587558178871\n"
 "help.text"
-msgid "$[officename] Basic supports single or multi-dimensional arrays that are defined by a specified variable type. Arrays are suitable if the program contains lists or tables that you want to edit. The advantage of arrays is that it is possible to address individual elements according to indexes, which can be formulated as numeric expressions or variables."
-msgstr "El $[officename] Basic admet matrius de dimensió senzilla o múltiple que es defineixen amb un tipus de variable especificat. Les matrius són adequades si el programa conté llistes o taules que voleu editar. L'avantatge de les matrius és que és possible adreçar elements individuals segons els índexs, que es poden formular com a expressions numèriques o variables."
+msgid "Declaration character"
+msgstr ""
 
-#. y72jG
+#. 6ZFgR
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3148488\n"
+"par_id851587558178871\n"
 "help.text"
-msgid "Arrays are declared with the Dim statement. There are two methods to define the index range:"
-msgstr "Les matrius es declaren amb l'expressió Dim. Existeixen dos mètodes per definir l'interval d'índex:"
+msgid "Variable type name"
+msgstr ""
 
-#. hHahF
+#. VDkAN
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3154662\n"
+"par_id441587477911298\n"
 "help.text"
-msgid "DIM text(20) as String REM 21 elements numbered from 0 to 20"
-msgstr "DIM text(20) as String REM 21 elements numerats del 0 al 20"
+msgid "<emph>array:</emph> Array declaration."
+msgstr ""
 
-#. Hi7Nv
+#. TmrKG
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3155604\n"
+"par_id971587473519701\n"
 "help.text"
-msgid "DIM text(5 to 25) as String REM 21 elements numbered from 5 to 25"
-msgstr "DIM text(5 to 25) as String REM 21 elements numerats del 5 al 25"
+msgid "<image src=\"media/helpimg/sbasic/array_fragment.svg\" id=\"img_id4156296485516\"><alt id=\"alt_id15152796485516\">array fragment</alt></image>"
+msgstr ""
 
-#. Y9rBz
+#. JkDDD
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3151274\n"
+"par_id3149924\n"
 "help.text"
-msgid "DIM text(-15 to 5) as String REM 21 elements (including 0)"
-msgstr "DIM text(-15 to 5) as String REM 21 elements (inclòs el 0)"
+msgid "$[officename] Basic supports single or multi-dimensional arrays that are defined by a specified variable type. Arrays are suitable if the program contains lists or tables that you want to edit. The advantage of arrays is that it is possible to address individual elements according to indexes, which can be formulated as numeric expressions or variables."
+msgstr "El $[officename] Basic admet matrius de dimensió senzilla o múltiple que es defineixen amb un tipus de variable especificat. Les matrius són adequades si el programa conté llistes o taules que voleu editar. L'avantatge de les matrius és que és possible adreçar elements individuals segons els índexs, que es poden formular com a expressions numèriques o variables."
 
-#. rgjVA
+#. ZuZBj
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3152774\n"
+"par_id3148488\n"
 "help.text"
-msgid "REM numbered from -15 to 5"
-msgstr "REM numerat de -15 a 5"
+msgid "Arrays are declared with the <literal>Dim</literal> statement. There are multiple ways to define the index range:"
+msgstr ""
 
-#. tZwqq
+#. iXgDy
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3150829\n"
+"bas_id381587475057846\n"
 "help.text"
-msgid "Two-dimensional data field"
-msgstr "Camp de dades de dues dimensions"
+msgid "Dim text(20) As String ' 21 elements numbered from 0 to 20"
+msgstr ""
 
-#. LF3Qa
+#. Du5a3
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3149529\n"
+"bas_id1001587475058292\n"
 "help.text"
-msgid "DIM text(20,2) as String REM 63 elements; form 0 to 20 level 1, from 0 to 20 level 2 and from 0 to 20 level 3."
-msgstr "DIM text(20,2) as String REM 63 elements; form 0 to 20 level 1, from 0 to 20 level 2 and from 0 to 20 level 3."
+msgid "Dim value(5 to 25) As Integer ' 21 values numbered from 5 to 25"
+msgstr ""
 
-#. J3Lir
+#. 66C57
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3159239\n"
+"bas_id481587475059423\n"
 "help.text"
-msgid "You can declare an array types as dynamic if a ReDim statement defines the number of dimensions in the subroutine or the function that contains the array. Generally, you can only define an array dimension once, and you cannot modify it. Within a subroutine, you can declare an array with ReDim. You can only define dimensions with numeric expressions. This ensures that the fields are only as large as necessary."
-msgstr "Podeu declarar un tipus de matriu com a dinàmic si l'expressió ReDim defineix el nombre de dimensions a la subrutina o a la funció que conté la matriu. Generalment, només podeu definir una dimensió de matriu un cop, i no podeu modificar-la. Dins d'una subrutina, podeu declarar una matriu amb ReDim. Només podeu definir dimensions amb expressions numèriques. Això garanteix que els camps només són tan grans com és necessari."
+msgid "Dim amount(-15 to 5) As Currency ' 21 amounts (including 0), numbered from -15 to 5"
+msgstr ""
 
-#. EDdP3
+#. Q6d4T
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"hd_id3150344\n"
+"bas_id621587475059824\n"
 "help.text"
-msgid "Example:"
-msgstr "Exemple:"
+msgid "REM Two-dimensional data field"
+msgstr ""
 
-#. cgxpk
+#. 9gAsN
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
-"par_id3154657\n"
+"bas_id11587475060830\n"
 "help.text"
-msgid "sVar = \"Office\""
-msgstr "sVar = \"Office\""
+msgid "Dim table$(20,2) ' 63 items; from 0 to 20 level 1, from 0 to 20 level 2 and from 0 to 20 level 3."
+msgstr ""
+
+#. FLoRP
+#: 03102100.xhp
+msgctxt ""
+"03102100.xhp\n"
+"par_id3159239\n"
+"help.text"
+msgid "You can declare an array types as dynamic if a <literal>ReDim</literal> statement defines the number of dimensions in the subroutine or the function that contains the array. Generally, you can only define an array dimension once, and you cannot modify it. Within a subroutine, you can declare an array with <literal>ReDim</literal>. You can only define dimensions with numeric expressions. This ensures that the fields are only as large as necessary."
+msgstr ""
 
 #. cGpY9
 #: 03102100.xhp
@@ -27971,248 +27980,41 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03102101.xhp\" name=\"ReDim Statement\">ReDim Statement</link>"
 msgstr ""
 
-#. AwErM
+#. F9HMw
 #: 03102101.xhp
 msgctxt ""
 "03102101.xhp\n"
 "par_id3154685\n"
 "help.text"
-msgid "Declares a variable or an array."
-msgstr "Declara una variable o una matriu."
+msgid "Declares or redefines variables or arrays."
+msgstr ""
 
-#. fZ9yj
+#. dTArZ
 #: 03102101.xhp
 msgctxt ""
 "03102101.xhp\n"
-"hd_id3154218\n"
+"par_id971587473488701\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaxi:"
+msgid "<image src=\"media/helpimg/sbasic/ReDim_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">ReDim Statement diagram</alt></image>"
+msgstr ""
 
-#. dGFJk
+#. bD6eG
 #: 03102101.xhp
 msgctxt ""
 "03102101.xhp\n"
 "par_id3156214\n"
 "help.text"
-msgid "[ReDim]Dim VarName [(start To end)] [As VarType][, VarName2 [(start To end)] [As VarType][,...]]"
-msgstr "[ReDim]Dim VarName [(start To end)] [As VarType][, VarName2 [(start To end)] [As VarType][,...]]"
+msgid "ReDim [Preserve] variable [(start To end)] [As type-name][, variable2 [(start To end)] [As type-name][,...]]"
+msgstr ""
 
-#. HCVxq
+#. 5wDoD
 #: 03102101.xhp
 msgctxt ""
 "03102101.xhp\n"
 "par_id711996\n"
 "help.text"
-msgid "Optionally, you can add the <emph>Preserve</emph> keyword as a parameter to preserve the contents of the array that is redimensioned."
-msgstr "Opcionalment, podeu afegir la paraula clau <emph>Preserve</emph> com a paràmetre per conservar el contingut de la matriu que es redimensiona."
-
-#. KeaqP
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"hd_id3148451\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paràmetres:"
-
-#. 5VjHG
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3156423\n"
-"help.text"
-msgid "<emph>VarName:</emph> Any variable or array name."
-msgstr "<emph>VarName:</emph> Qualsevol nom de variable o de matriu."
-
-#. 4gHFh
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3149562\n"
-"help.text"
-msgid "<emph>Start, End:</emph> Numerical values or constants that define the number of elements (NumberElements=(end-start)+1) and the index range."
-msgstr "<emph>Start, End:</emph> Valors numèrics o constants que defineixen el nombre d'elements (NombreElements=(fi-inici)+1) i l'interval d'índex."
-
-#. vP6dA
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3155307\n"
-"help.text"
-msgid "Start and End can be numeric expressions if ReDim is used at the procedure level."
-msgstr "Start i End poden ser expressions numèriques si ReDim s'utilitza al nivell de procediment."
-
-#. A3MnD
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3153951\n"
-"help.text"
-msgid "<emph>VarType:</emph> Keyword that declares the data type of a variable."
-msgstr "<emph>VarType:</emph> Paraula clau que declara el tipus de dades d'una variable."
-
-#. 43NDu
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3147317\n"
-"help.text"
-msgid "<emph>Keyword:</emph> Variable type"
-msgstr "<emph>Paraula clau:</emph> Tipus de variable"
-
-#. hrAde
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3153728\n"
-"help.text"
-msgid "<emph>Bool: </emph>Boolean variable (True, False)"
-msgstr "<emph>Bool: </emph>Variable booleana (Cert, Fals)"
-
-#. VCYQt
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3146121\n"
-"help.text"
-msgid "<emph>Date:</emph> Date variable"
-msgstr "<emph>Data:</emph> Variable de data"
-
-#. LCL7Q
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3159156\n"
-"help.text"
-msgid "<emph>Double:</emph> Double floating point variable (1.79769313486232x10E308 - 4.94065645841247x10E-324)"
-msgstr "<emph>Double:</emph> Variable de coma flotant doble (1.79769313486232x10E308 - 4.94065645841247x10E-324)"
-
-#. wzD36
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3148616\n"
-"help.text"
-msgid "<emph>Integer:</emph> Integer variable (-32768 - 32767)"
-msgstr "<emph>Integer:</emph> Variable d'enter (-32768 - 32767)"
-
-#. ZSesV
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3147348\n"
-"help.text"
-msgid "<emph>Long:</emph> Long integer variable (-2,147,483,648 - 2,147,483,647)"
-msgstr "<emph>Llarg:</emph> Variable d'enter llarga (-2,147,483,648 - 2,147,483,647)"
-
-#. 6EtG6
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3149412\n"
-"help.text"
-msgid "<emph>Object:</emph> Object variable (can only be subsequently defined by Set!)"
-msgstr "<emph>Object:</emph> Variable Object (només es pot definir posteriorment amb Set!)"
-
-#. EM7eN
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3154729\n"
-"help.text"
-msgid "<emph>[Single]:</emph> Single floating-point variable (3.402823x10E38 - 1.401298x10E-45). If no key word is specified, a variable is defined as Single, unless a statement from DefBool to DefVar is used."
-msgstr "<emph>[Single]:</emph> Variable de coma flotant senzilla (3,402823x10E38 - 1,401298x10E-45). Si no s'especifica cap paraula clau, una variable es defineix com a senzilla, a menys que s'utilitze una expressió de DefBool a DefVar."
-
-#. LLYEo
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3148458\n"
-"help.text"
-msgid "<emph>String:</emph> String variable containing a maximum of 64,000 ASCII characters."
-msgstr "<emph>Cadena:</emph> Variable de cadena que consta d'un màxim de 64.000 caràcters ASCII."
-
-#. VhzLs
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3149581\n"
-"help.text"
-msgid "<emph>Variant: </emph>Variant variable type (can contain all types and is set by definition)."
-msgstr "<emph>Variant: </emph>Tipus de variable de variant (pot contindre tots els tipus i s'estableix per definició)."
-
-#. yxCux
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3155601\n"
-"help.text"
-msgid "In $[officename] Basic, you do not need to declare variables explicitly. However, you need to declare an array before you can use them. You can declare a variable with the Dim statement, using commas to separate multiple declarations. To declare a variable type, enter a type-declaration character following the name or use a corresponding key word."
-msgstr "Al $[officename] Basic no cal que declareu les variables explícitament. No obstant això, cal que declareu una matriu abans de poder utilitzar-les. Podeu declarar una variable amb l'expressió Dim, fent servir comes per separar múltiples declaracions. Per declarar un tipus de variable, introduïu un caràcter de declaració de tipus després del nom, o utilitzeu la paraula clau corresponent."
-
-#. bBe4t
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3153415\n"
-"help.text"
-msgid "$[officename] Basic supports single or multi-dimensional arrays that are defined by a specified variable type. Arrays are suitable if the program contains lists or tables that you want to edit. The advantage of arrays is that it is possible to address individual elements according to indexes, which can be formulated as numeric expressions or variables."
-msgstr "El $[officename] Basic admet matrius de dimensió senzilla o múltiple que es defineixen amb un tipus de variable especificat. Les matrius són adequades si el programa conté llistes o taules que voleu editar. L'avantatge de les matrius és que és possible adreçar elements individuals segons els índexs, que es poden formular com a expressions numèriques o variables."
-
-#. zMCfu
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3146971\n"
-"help.text"
-msgid "There are two ways to set the range of indices for arrays declared with the Dim statement:"
-msgstr "Existeixen dues maneres de definir l'interval d'índexs per a matrius declarades amb l'expressió Dim:"
-
-#. GC3Bz
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3153950\n"
-"help.text"
-msgid "DIM text(20) As String REM 21 elements numbered from 0 to 20"
-msgstr "DIM text(20) As String REM 21 elements numerats de 0 a 20"
-
-#. MYHME
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3146912\n"
-"help.text"
-msgid "DIM text(5 to 25) As String REM 21 elements numbered from 5 to 25"
-msgstr "DIM text(5 to 25) As String REM 21 elements numerats del 5 al 25"
-
-#. Ynkyg
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3153709\n"
-"help.text"
-msgid "DIM text$(-15 to 5) As String REM 21 elements (0 inclusive),"
-msgstr "DIM text$(-15 to 5) As String REM 21 elements (0 inclòs),"
-
-#. YCEPk
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3150321\n"
-"help.text"
-msgid "rem numbered from -15 to 5"
-msgstr "rem numbered from -15 to 5"
-
-#. AvMQE
-#: 03102101.xhp
-msgctxt ""
-"03102101.xhp\n"
-"par_id3149018\n"
-"help.text"
-msgid "Variable fields, regardless of type, can be made dynamic if they are dimensioned by ReDim at the procedure level in subroutines or functions. Normally, you can only set the range of an array once and you cannot modify it. Within a procedure, you can declare an array using the ReDim statement with numeric expressions to define the range of the field sizes."
-msgstr "Els camps de variable, independentment del tipus, poden convertir-se en dinàmics si es dimensionen amb ReDim al nivell de procediment en subrutines o funcions. Normalment, només podeu establir l'interval d'una matriu un cop i no podeu modificar-lo. Dins d'un procediment, podeu declarar una matriu amb l'expressió ReDim amb expressions numèriques per definir l'interval de les mides del camp."
+msgid "Optionally, add the <literal>Preserve</literal> keyword to preserve the contents of the array that is redimensioned. <literal>ReDim</literal> can only be used in subroutines."
+msgstr ""
 
 #. TTGyB
 #: 03102101.xhp
@@ -29861,6 +29663,15 @@ msgctxt ""
 msgid "Boolean variable"
 msgstr "Variable booleana"
 
+#. zrorE
+#: 03103600.xhp
+msgctxt ""
+"03103600.xhp\n"
+"par_id3158645\n"
+"help.text"
+msgid "Byte variable"
+msgstr ""
+
 #. N3udA
 #: 03103600.xhp
 msgctxt ""
@@ -39752,13 +39563,22 @@ msgctxt ""
 msgid "<variable id=\"ErrVBAh1\"><link href=\"text/sbasic/shared/ErrVBA.xhp\" name=\"Err object [VBA]\">Err Object [VBA]</link></variable>"
 msgstr ""
 
-#. KxDJt
+#. RZpQL
 #: ErrVBA.xhp
 msgctxt ""
 "ErrVBA.xhp\n"
 "N0012\n"
 "help.text"
-msgid "Use VBA <literal>Err</literal> object to raise or handle runtime errors. <literal>Err</literal> is a VBA built-in global object which permits:"
+msgid "Use VBA <literal>Err</literal> object to raise or handle runtime errors."
+msgstr ""
+
+#. D7JiE
+#: ErrVBA.xhp
+msgctxt ""
+"ErrVBA.xhp\n"
+"N0012b\n"
+"help.text"
+msgid "<literal>Err</literal> is a built-in VBA global object that allows:"
 msgstr ""
 
 #. VpE8g
@@ -39815,13 +39635,13 @@ msgctxt ""
 msgid "Properties"
 msgstr ""
 
-#. UG8Cx
+#. FSwVh
 #: ErrVBA.xhp
 msgctxt ""
 "ErrVBA.xhp\n"
 "N0020\n"
 "help.text"
-msgid "<emph>Description</emph> property gives the nature of the error. It details the various reasons that may cause the error. Ideally it provides the multiple course of actions that help solve the issue and prevent its reoccurrence. Its alias is Basic <link href=\"text/sbasic/shared/03050300.xhp\" name=\"Error function\">Error</link> function for %PRODUCTNAME predefined errors."
+msgid "<emph>Description</emph> property gives the nature of the error. It details the various reasons that may cause the error. Ideally, it provides the multiple course of actions to help solve the issue and prevent its reoccurrence. Its alias is Basic <link href=\"text/sbasic/shared/03050300.xhp\" name=\"Error function\">Error</link> function for %PRODUCTNAME predefined errors."
 msgstr ""
 
 #. PjWUG
@@ -40130,31 +39950,31 @@ msgctxt ""
 msgid "<image src=\"media/helpimg/sbasic/Resume_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Resume Statement diagram</alt></image>"
 msgstr ""
 
-#. KAJEM
+#. eafvm
 #: Resume.xhp
 msgctxt ""
 "Resume.xhp\n"
 "par_id481586090298901\n"
 "help.text"
-msgid "<emph>0: </emph>Resets error information and re-executes the instruction that caused the error. <emph>0</emph> is optional."
+msgid "<literal>0</literal>: Resets error information and re-executes the instruction that caused the error. <literal>0</literal> is optional."
 msgstr ""
 
-#. RTTux
+#. uukh4
 #: Resume.xhp
 msgctxt ""
 "Resume.xhp\n"
 "par_id331586090532804\n"
 "help.text"
-msgid "<emph>label: </emph>Resets error information and executes the instruction at the given label."
+msgid "<emph>label: </emph>: Resets error information and resumes execution at the specified label of the current subroutine."
 msgstr ""
 
-#. 7RP8z
+#. 7NaeS
 #: Resume.xhp
 msgctxt ""
 "Resume.xhp\n"
 "par_id331586090432804\n"
 "help.text"
-msgid "<emph>Next: </emph>Resets error information and executes the instruction following the one that caused the error."
+msgid "<literal>Next</literal>: Resets error information and executes the instruction following the one that caused the error."
 msgstr ""
 
 #. 3Jge7
@@ -40256,13 +40076,13 @@ msgctxt ""
 msgid "Use <literal>Resume Next</literal>, for example, when reporting anomalies encountered for an iterating process that must not be interrupted. In which case multiple handling routines may be required."
 msgstr ""
 
-#. AeVfB
+#. 4NKFt
 #: Resume.xhp
 msgctxt ""
 "Resume.xhp\n"
 "par_id461586091018138\n"
 "help.text"
-msgid "Using <literal>Resume</literal> without parameters to re-execute the faulty instruction can fit certain situations. However that may cause a never ending loop."
+msgid "Using <literal>Resume</literal> without parameters to re-execute the faulty instruction can fit certain situations. However that may cause a neverending loop."
 msgstr ""
 
 #. MqMrx
@@ -40850,6 +40670,231 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03090411.xhp\" name=\"With\">With</link> statement"
 msgstr ""
 
+#. FFWQn
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"tit\n"
+"help.text"
+msgid "Basic syntax diagrams fragments"
+msgstr ""
+
+#. y2yz2
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id541587044867073\n"
+"help.text"
+msgid "<variable id=\"fragmentsh1\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"Syntax fragments\">Syntax fragments</link></variable>"
+msgstr ""
+
+#. qdgmB
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id881587044839050\n"
+"help.text"
+msgid "%PRODUCTNAME Basic syntax fragments."
+msgstr ""
+
+#. ChERt
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id431587045941514\n"
+"help.text"
+msgid "<variable id=\"argumenth2\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"arguments in Function, Sub and Property statements\"/></variable>argument fragment"
+msgstr ""
+
+#. pfHq8
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/argument_fragment.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">argument fragment</alt></image>"
+msgstr ""
+
+#. zqKwG
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id811587303969210\n"
+"help.text"
+msgid "Parameters"
+msgstr ""
+
+#. E7GXy
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id481586090298901\n"
+"help.text"
+msgid "<literal>Optional</literal>: The argument is not mandatory."
+msgstr ""
+
+#. FEs39
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id331586090532804\n"
+"help.text"
+msgid "<literal>ByRef</literal>: The argument is passed by reference. <literal>ByRef</literal> is the default."
+msgstr ""
+
+#. WuCPC
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id331586090432804\n"
+"help.text"
+msgid "<literal>ByVal</literal>: The argument is passed by value. Its value can be modified by the called routine."
+msgstr ""
+
+#. GrfMS
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id651587044335713\n"
+"help.text"
+msgid "<emph>char:</emph> Type declaration character."
+msgstr ""
+
+#. Naxwg
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id651587044336713\n"
+"help.text"
+msgid "<emph>typename</emph>: Primitive data type name. Library or module defined types can also be specified."
+msgstr ""
+
+#. KwsyR
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id11587045141290\n"
+"help.text"
+msgid "<emph>= expression</emph>: Specify a default value for the argument, matching its declared type. <literal>Optional</literal>  is necessary for each argument specifying a default value."
+msgstr ""
+
+#. 4Atx8
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id331586091432804\n"
+"help.text"
+msgid "<literal>ParamArray</literal>: Use <literal>ParamArray</literal> when the number of parameters is undetermined. A typical scenario is that of a Calc user-defined function. Using <literal>ParamArray</literal> should be limited to the last argument of a routine."
+msgstr ""
+
+#. GWSD4
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id851587050837107\n"
+"help.text"
+msgid "Using<literal>ParamArray</literal> or <emph>= expression</emph> require <link href=\"text/sbasic/shared/compatible.xhp\" name=\"Option Compatible\">Option Compatible</link> to be placed before the executable program code in a module."
+msgstr ""
+
+#. EDCLX
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id391587571321063\n"
+"help.text"
+msgid "When using <link href=\"text/sbasic/shared/vbasupport.xhp\" name=\"Option VBASupport\">Option VBASupport 1</link>, <literal>Optional</literal> arguments with no default value (<emph>= expression</emph>) are initialized according to their data type, except if <literal>Variant</literal>."
+msgstr ""
+
+#. KG4tC
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id231587046013456\n"
+"help.text"
+msgid "<variable id=\"arrayh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"array syntax fragment\"/></variable>array fragment"
+msgstr ""
+
+#. YD32W
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id491586753339473\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/array_fragment.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">array fragment</alt></image>"
+msgstr ""
+
+#. zrpkq
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id731587304120258\n"
+"help.text"
+msgid "Parameters"
+msgstr ""
+
+#. dUCSu
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id951587051619162\n"
+"help.text"
+msgid "<emph>start:</emph> Lower bound of a dimension."
+msgstr ""
+
+#. yeb4H
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id951587052619162\n"
+"help.text"
+msgid "<emph>end:</emph> Upper bound of a dimension."
+msgstr ""
+
+#. wyE23
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id961587051702571\n"
+"help.text"
+msgid "Multiple dimensions for an array are denoted using comma (<emph>,</emph>) sign."
+msgstr ""
+
+#. bGJWo
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id231587046013458\n"
+"help.text"
+msgid "<variable id=\"typenameh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"data types fragment\"/></variable>typename fragment"
+msgstr ""
+
+#. AqfYj
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id501586753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/typename_fragment.svg\" id=\"img_id4157296484514\"><alt id=\"alt_id15152796484515\">primitive data types fragment</alt></image>"
+msgstr ""
+
+#. FcC7c
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"hd_id231587046013459\n"
+"help.text"
+msgid "<variable id=\"charh4\"><link href=\"text/sbasic/shared/fragments.xhp\" name=\"type declaration characters fragment\"/></variable>type-car fragment"
+msgstr ""
+
+#. JFwPg
+#: fragments.xhp
+msgctxt ""
+"fragments.xhp\n"
+"par_id511586753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/char_fragment.svg\" id=\"img_id4157296484514\"><alt id=\"alt_id15152796484516\">type declaration characters</alt></image>"
+msgstr ""
+
 #. onSEk
 #: keys.xhp
 msgctxt ""
@@ -41471,13 +41516,13 @@ msgctxt ""
 msgid "Replaces some string by another."
 msgstr ""
 
-#. 9uBGG
+#. 4cCHs
 #: replace.xhp
 msgctxt ""
 "replace.xhp\n"
 "par_id931552552227310\n"
 "help.text"
-msgid "Replace (Text As String, SearchStr As String, ReplStr As String [, Start As Long [, Count as long [, Compare As Boolean]]]"
+msgid "Replace (Text As String, SearchStr As String, ReplStr As String [, Start As Long [, Count as Long [, Compare As Boolean]]]"
 msgstr ""
 
 #. iMDGH
@@ -41516,13 +41561,13 @@ msgctxt ""
 msgid "<emph>ReplStr:</emph> Any string expression that shall replace the found search string."
 msgstr ""
 
-#. KfkZ4
+#. y6ZZR
 #: replace.xhp
 msgctxt ""
 "replace.xhp\n"
 "par_id111552552283060\n"
 "help.text"
-msgid "<emph>Start:</emph> Numeric expression that indicates the character position within the string where the search shall begin. The maximum allowed value is 65535."
+msgid "<emph>Start:</emph> Numeric expression that indicates the character position where the search starts and also the start of the substring to be returned."
 msgstr ""
 
 #. bLh8G
@@ -41579,6 +41624,15 @@ msgctxt ""
 msgid "REM * only first (respecting case) occurrence (parameter 5)"
 msgstr ""
 
+#. QEPtG
+#: replace.xhp
+msgctxt ""
+"replace.xhp\n"
+"par_id861587778446685\n"
+"help.text"
+msgid "REM returns D*FGHI because the search starts at position 4, which is also the start of the returned string."
+msgstr ""
+
 #. Z9NfM
 #: special_vba_func.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/scalc/00.po b/source/ca-valencia/helpcontent2/source/text/scalc/00.po
index 49ae778fa2c..0dd1c4af72f 100644
--- a/source/ca-valencia/helpcontent2/source/text/scalc/00.po
+++ b/source/ca-valencia/helpcontent2/source/text/scalc/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
 "PO-Revision-Date: 2018-11-14 11:53+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -593,13 +593,13 @@ msgctxt ""
 msgid "<variable id=\"einamen\">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable>"
 msgstr ""
 
-#. ASCUT
+#. VLxrw
 #: 00000404.xhp
 msgctxt ""
 "00000404.xhp\n"
 "par_id3146776\n"
 "help.text"
-msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External data</menuitem>.</variable>"
+msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External Data</menuitem>.</variable>"
 msgstr ""
 
 #. ECgNS
diff --git a/source/ca-valencia/helpcontent2/source/text/scalc/01.po b/source/ca-valencia/helpcontent2/source/text/scalc/01.po
index a3b678a2574..8cd0d3248ae 100644
--- a/source/ca-valencia/helpcontent2/source/text/scalc/01.po
+++ b/source/ca-valencia/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-04-15 12:52+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
 "PO-Revision-Date: 2018-11-12 13:23+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4814,6 +4814,15 @@ msgctxt ""
 msgid "If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
 msgstr "Si s'omet l'argument del CampDeBaseDeDades, BDCOMPTA retorna el recompte de tots els registres que complisquen els criteris. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
 
+#. ckYe4
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id301587321851330\n"
+"help.text"
+msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNT(Database; ; SearchCriteria)."
+msgstr ""
+
 #. F7cy4
 #: 04060101.xhp
 msgctxt ""
@@ -4886,6 +4895,15 @@ msgctxt ""
 msgid "If the DatabaseField argument is omitted, DCOUNTA returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
 msgstr ""
 
+#. ESpfH
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id31587322048553\n"
+"help.text"
+msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNTA(Database; ; SearchCriteria)."
+msgstr ""
+
 #. xX6ve
 #: 04060101.xhp
 msgctxt ""
@@ -55466,13 +55484,13 @@ msgctxt ""
 msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>"
 msgstr ""
 
-#. E9m3Y
+#. Co8xT
 #: func_ceiling.xhp
 msgctxt ""
 "func_ceiling.xhp\n"
 "par_id3153422\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
 msgstr ""
 
 #. PfT3s
@@ -55484,13 +55502,13 @@ msgctxt ""
 msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
 msgstr ""
 
-#. s9tRF
+#. 6AFh7
 #: func_ceiling.xhp
 msgctxt ""
 "func_ceiling.xhp\n"
 "par_id3163792\n"
 "help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions."
 msgstr ""
 
 #. mZwNV
@@ -55637,15 +55655,6 @@ msgctxt ""
 msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
 msgstr ""
 
-#. 6Vtow
-#: func_ceiling.xhp
-msgctxt ""
-"func_ceiling.xhp\n"
-"par_id461586211894475\n"
-"help.text"
-msgid "This function calculates identical results to the ISO.CEILING function"
-msgstr ""
-
 #. 8WiRx
 #: func_ceiling.xhp
 msgctxt ""
@@ -55700,6 +55709,15 @@ msgctxt ""
 msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
 msgstr ""
 
+#. aYczG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
 #. Km7yb
 #: func_ceiling.xhp
 msgctxt ""
@@ -55727,15 +55745,6 @@ msgctxt ""
 msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)."
 msgstr ""
 
-#. aYczG
-#: func_ceiling.xhp
-msgctxt ""
-"func_ceiling.xhp\n"
-"par_id291516998575663\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
-msgstr ""
-
 #. je22s
 #: func_ceiling.xhp
 msgctxt ""
@@ -55943,13 +55952,13 @@ msgctxt ""
 msgid "<input>=ISO.CEILING(3.45)</input> returns 4."
 msgstr ""
 
-#. ENMYD
+#. xS2zM
 #: func_ceiling.xhp
 msgctxt ""
 "func_ceiling.xhp\n"
 "par_id181586214438808\n"
 "help.text"
-msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44."
+msgid "<input>=ISO.CEILING(-45.67,2)</input> returns -44."
 msgstr ""
 
 #. GuEcB
@@ -57626,6 +57635,15 @@ msgctxt ""
 msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
 msgstr ""
 
+#. 5kHtR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3163894\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
+msgstr ""
+
 #. 2haGU
 #: func_floor.xhp
 msgctxt ""
@@ -57662,15 +57680,6 @@ msgctxt ""
 msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)."
 msgstr ""
 
-#. 5kHtR
-#: func_floor.xhp
-msgctxt ""
-"func_floor.xhp\n"
-"par_id3163894\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
-msgstr ""
-
 #. EU85r
 #: func_floor.xhp
 msgctxt ""
@@ -61496,22 +61505,22 @@ msgctxt ""
 msgid "The function should be called with at least two parameters."
 msgstr ""
 
-#. gwtEM
+#. hANRQ
 #: func_rawsubtract.xhp
 msgctxt ""
 "func_rawsubtract.xhp\n"
 "par_2016112109236\n"
 "help.text"
-msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765, 0.9876543210987)</item> returns 6.53921361504217E-14"
+msgid "<input>=RAWSUBTRACT(0.987654321098765, 0.9876543210987)</input> returns 6.53921361504217E-14"
 msgstr ""
 
-#. QZT3B
+#. bgohX
 #: func_rawsubtract.xhp
 msgctxt ""
 "func_rawsubtract.xhp\n"
 "par_2016112109237\n"
 "help.text"
-msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765)</item> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
+msgid "<input>=RAWSUBTRACT(0.987654321098765)</input> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
 msgstr ""
 
 #. d9DP3
@@ -65186,15 +65195,6 @@ msgctxt ""
 msgid "Between Groups"
 msgstr ""
 
-#. vuDTW
-#: statistics_anova.xhp
-msgctxt ""
-"statistics_anova.xhp\n"
-"par_id411554944014360\n"
-"help.text"
-msgid "3.340385558"
-msgstr ""
-
 #. tpzCU
 #: statistics_anova.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/scalc/guide.po b/source/ca-valencia/helpcontent2/source/text/scalc/guide.po
index 934cf821fea..d9c26cc229b 100644
--- a/source/ca-valencia/helpcontent2/source/text/scalc/guide.po
+++ b/source/ca-valencia/helpcontent2/source/text/scalc/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
 "PO-Revision-Date: 2018-11-14 11:53+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -11861,67 +11861,67 @@ msgctxt ""
 msgid "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range."
 msgstr ""
 
-#. owkFH
+#. QiBqE
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id421585177574387\n"
 "help.text"
-msgid "Select <menuitem>Data > Subtotals</menuitem>  from the Menu bar to open the Subtotals dialog."
+msgid "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog."
 msgstr ""
 
-#. AmnUD
+#. BwAst
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id41585177608508\n"
 "help.text"
-msgid "In the Group by drop-down list on the first Group page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column."
+msgid "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column."
 msgstr ""
 
-#. dq83u
+#. QmNL9
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id451585177625978\n"
 "help.text"
-msgid "In the Calculate subtotals for box on the first Group page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals."
+msgid "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals."
 msgstr ""
 
-#. xFgAD
+#. CQ9km
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id661585177644535\n"
 "help.text"
-msgid "In the Use function box on the first Group page, select a function to calculate the subtotals for the column selected in step 4."
+msgid "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4."
 msgstr ""
 
-#. EhUvq
+#. 3eTTE
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id351585177661529\n"
 "help.text"
-msgid "Repeat steps 4 and 5 to create subtotals for other columns on the first Group page."
+msgid "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page."
 msgstr ""
 
-#. aQRn7
+#. 6GLDr
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id511585177679372\n"
 "help.text"
-msgid "You can create two more subtotal categories by using the second Group and third Group pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”."
+msgid "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”."
 msgstr ""
 
-#. AaCGA
+#. HDB52
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id301585177698777\n"
 "help.text"
-msgid "Click OK. Calc will add subtotal and grand total rows to your cell range."
+msgid "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range."
 msgstr ""
 
 #. iMTer
@@ -11951,13 +11951,13 @@ msgctxt ""
 msgid "This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data."
 msgstr ""
 
-#. SEYEM
+#. C97jN
 #: subtotaltool.xhp
 msgctxt ""
 "subtotaltool.xhp\n"
 "par_id161585178829165\n"
 "help.text"
-msgid "To turn off outlines, select <menuitem>Data > Group and Outline > Remove Outline</menuitem>  from the Menu bar. To reinstate them, select <menuitem>Data > Group and Outline > AutoOutline</menuitem>."
+msgid "To turn off outlines, choose <menuitem>Data - Group and Outline - Remove Outline</menuitem>. To reinstate them, choose <menuitem>Data - Group and Outline - AutoOutline</menuitem>."
 msgstr ""
 
 #. oU9ew
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/00.po b/source/ca-valencia/helpcontent2/source/text/shared/00.po
index c17058a488d..634cb2d0fa7 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/00.po
+++ b/source/ca-valencia/helpcontent2/source/text/shared/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
 "PO-Revision-Date: 2018-11-14 11:53+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -6911,13 +6911,13 @@ msgctxt ""
 msgid "<variable id=\"senden\">Menu <emph>File - Send</emph>.</variable>"
 msgstr ""
 
-#. TEKGF
+#. E3vhr
 #: 00000401.xhp
 msgctxt ""
 "00000401.xhp\n"
 "par_id3145386\n"
 "help.text"
-msgid "Choose <emph>File - Send - E-mail Document</emph>."
+msgid "Choose <emph>File - Send - Email Document</emph>."
 msgstr ""
 
 #. ZaENF
@@ -12419,22 +12419,22 @@ msgctxt ""
 msgid "<variable id=\"verlauf\">Choose <emph>Format - </emph><switchinline select=\"appl\"><caseinline select=\"WRITER\"><emph>Text Box and Shape - </emph>                    </caseinline><caseinline select=\"CALC\"><emph>Object - </emph></caseinline></switchinline><emph>Area - Gradients</emph> tab.</variable>"
 msgstr ""
 
-#. rE5He
+#. Vez5y
 #: 00040502.xhp
 msgctxt ""
 "00040502.xhp\n"
 "par_id3155308\n"
 "help.text"
-msgid "<variable id=\"schraffur\">Choose <menuitem>Format - </menuitem><switchinline select=\"appl\"><caseinline select=\"WRITER\"><menuitem>Text Box and Shape - </menuitem>                    </caseinline><caseinline select=\"CALC\"><menuitem>Object - </menuitem></caseinline><caseinline select=\"IMPRESS\"><menuitem>Object and Shape - </menuitem></caseinline></switchinline><menuitem>Area</menuitem><emph> - Hatch</emph> tab.</variable>"
+msgid "<variable id=\"schraffur\">Choose <menuitem>Format - </menuitem>            <switchinline select=\"appl\">                <caseinline select=\"WRITER\"><menuitem>Text Box and Shape - </menuitem></caseinline>                <caseinline select=\"CALC\"><menuitem>Object - </menuitem></caseinline>                <caseinline select=\"IMPRESS\"><menuitem>Object and Shape - </menuitem></caseinline>            </switchinline>            <menuitem>Area - Hatch</menuitem> tab.        </variable>"
 msgstr ""
 
-#. poEmE
+#. phott
 #: 00040502.xhp
 msgctxt ""
 "00040502.xhp\n"
 "par_id3155314\n"
 "help.text"
-msgid "<variable id=\"page_hatch\"><switchinline select=\"appl\"><caseinline select=\"WRITER\">Choose <menuitem>Format - Page Style - Area</menuitem><emph> - Hatch</emph> tab.</caseinline>                    <caseinline select=\"DRAW\">Choose <menuitem>Page - Properties - Background</menuitem><emph> - Hatch</emph> tab.</caseinline><caseinline select=\"IMPRESS\">Choose <menuitem>Slide - Properties - Background</menuitem><emph> - Hatch</emph> tab.</caseinline></switchinline></variable>"
+msgid "<variable id=\"page_hatch\">            <switchinline select=\"appl\">                <caseinline select=\"WRITER\">Choose <menuitem>Format - Page Style - Area</menuitem></caseinline>                <caseinline select=\"DRAW\">Choose <menuitem>Page - Properties - Background</menuitem></caseinline>                <caseinline select=\"IMPRESS\">Choose <menuitem>Slide - Properties - Background</menuitem></caseinline>            </switchinline>            <emph> - Hatch</emph> tab.        </variable>"
 msgstr ""
 
 #. J5DJs
@@ -14021,13 +14021,13 @@ msgctxt ""
 msgid "Choose <menuitem>Edit - Paste Special - Paste Unformatted Text</menuitem>."
 msgstr ""
 
-#. ngeHG
+#. BUPSo
 #: edit_menu.xhp
 msgctxt ""
 "edit_menu.xhp\n"
 "par_id431584825207430\n"
 "help.text"
-msgid "Right click to open the context menu and choose <menuitem>Paste Special - Unformatted Text</menuitem>."
+msgid "Right-click to open the context menu and choose <menuitem>Paste Special - Unformatted Text</menuitem>."
 msgstr ""
 
 #. hUjhY
@@ -14048,13 +14048,13 @@ msgctxt ""
 msgid "Choose <menuitem>Edit - Paste Special - Paste Nested Table</menuitem>."
 msgstr ""
 
-#. oFtar
+#. AWiCd
 #: edit_menu.xhp
 msgctxt ""
 "edit_menu.xhp\n"
 "par_id701584824350359\n"
 "help.text"
-msgid "Right click on the target table cell to open the context menu and choose <menuitem>Paste Special - Nested Table</menuitem>."
+msgid "Right-click on the target table cell to open the context menu and choose <menuitem>Paste Special - Nested Table</menuitem>."
 msgstr ""
 
 #. fLFXd
@@ -14066,13 +14066,13 @@ msgctxt ""
 msgid "Choose <menuitem>Edit - Paste Special - Paste as Rows above</menuitem>."
 msgstr ""
 
-#. EjC8L
+#. 7CnTy
 #: edit_menu.xhp
 msgctxt ""
 "edit_menu.xhp\n"
 "par_id961584822968492\n"
 "help.text"
-msgid "Right click on the target table cell to open the context menu and choose <menuitem>Paste Special - Rows above</menuitem>."
+msgid "Right-click on the target table cell to open the context menu and choose <menuitem>Paste Special - Rows Above</menuitem>."
 msgstr ""
 
 #. 2xgA5
@@ -14084,13 +14084,13 @@ msgctxt ""
 msgid "Choose <menuitem>Edit - Paste Special - Paste as Columns Before</menuitem>."
 msgstr ""
 
-#. LBKGw
+#. CJBCG
 #: edit_menu.xhp
 msgctxt ""
 "edit_menu.xhp\n"
 "par_id61584824301756\n"
 "help.text"
-msgid "Right click on the target table cell to open the context menu and choose <menuitem>Paste Special - Columns Before</menuitem>."
+msgid "Right-click on the target table cell to open the context menu and choose <menuitem>Paste Special - Columns Before</menuitem>."
 msgstr ""
 
 #. RPFZr
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/01.po b/source/ca-valencia/helpcontent2/source/text/shared/01.po
index 9d26e91556a..95f22542cab 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/01.po
+++ b/source/ca-valencia/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-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-29 22:17+0200\n"
 "PO-Revision-Date: 2019-07-21 12:08+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5363,23 +5363,23 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/01160200.xhp\" name=\"Document as E-mail\">E-mail Document</link>"
 msgstr "<link href=\"text/shared/01/01160200.xhp\" name=\"Document as E-mail\">Document com a correu electrònic</link>"
 
-#. qLYd7
+#. Q86XQ
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id4546342\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens a new window in your default e-mail program with the current document as an attachment. The OpenDocument file format is used.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Obri una finestra nova del programa de correu electrònic per defecte amb el document actual com a adjunció. S'utilitza el format de fitxer OpenDocument.</ahelp>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens a new window in your default email program with the current document as an attachment. The OpenDocument file format is used.</ahelp>"
+msgstr ""
 
-#. g9Tk8
+#. EiZei
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id6845301\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens a new window in your default e-mail program with the current document as an attachment. The Microsoft file format is used.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Obri una finestra nova del programa de correu electrònic per defecte amb el document actual com a adjunció. S'utilitza el format de fitxer Microsoft.</ahelp>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens a new window in your default email program with the current document as an attachment. The Microsoft file format is used.</ahelp>"
+msgstr ""
 
 #. EyYsF
 #: 01160000.xhp
@@ -5390,13 +5390,13 @@ msgctxt ""
 msgid "E-mail as OpenDocument Spreadsheet"
 msgstr "Envia com a full de càlcul d'OpenDocument"
 
-#. 8SrQW
+#. ewW2i
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id5917844\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The OpenDocument file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The OpenDocument file format is used."
 msgstr ""
 
 #. FXCR6
@@ -5408,13 +5408,13 @@ msgctxt ""
 msgid "E-mail as Microsoft Excel"
 msgstr "Envia com a Microsoft Excel"
 
-#. 93SRR
+#. pLjdc
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id5759453\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The Microsoft Excel file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The Microsoft Excel file format is used."
 msgstr ""
 
 #. UrGaf
@@ -5426,13 +5426,13 @@ msgctxt ""
 msgid "E-mail as OpenDocument Presentation"
 msgstr "Envia com a presentació d'OpenDocument"
 
-#. CFww7
+#. Ai2i2
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id7829218\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The OpenDocument file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The OpenDocument file format is used."
 msgstr ""
 
 #. vtewB
@@ -5444,13 +5444,13 @@ msgctxt ""
 msgid "E-mail as Microsoft PowerPoint Presentation"
 msgstr "Envia com a presentació del Microsoft PowerPoint"
 
-#. 2YKU6
+#. uDGxn
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id8319650\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The Microsoft PowerPoint file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The Microsoft PowerPoint file format is used."
 msgstr ""
 
 #. XFixi
@@ -5462,13 +5462,13 @@ msgctxt ""
 msgid "E-mail as OpenDocument Text"
 msgstr "Envia com a text d'OpenDocument"
 
-#. 5bvD7
+#. Aewp6
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id9085055\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The OpenDocument file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The OpenDocument file format is used."
 msgstr ""
 
 #. c9WaG
@@ -5480,13 +5480,13 @@ msgctxt ""
 msgid "E-mail as Microsoft Word"
 msgstr "Envia com a Microsoft Word"
 
-#. sPUwY
+#. dcXm5
 #: 01160000.xhp
 msgctxt ""
 "01160000.xhp\n"
 "par_id5421918\n"
 "help.text"
-msgid "Opens a new window in your default e-mail program with the current document as an attachment. The Microsoft Word file format is used."
+msgid "Opens a new window in your default email program with the current document as an attachment. The Microsoft Word file format is used."
 msgstr ""
 
 #. 9Vye6
@@ -5534,13 +5534,13 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/01160200.xhp\">E-mail Document</link>"
 msgstr "<link href=\"text/shared/01/01160200.xhp\">Envia el document per correu electrònic</link>"
 
-#. 6LyWZ
+#. 8prjP
 #: 01160200.xhp
 msgctxt ""
 "01160200.xhp\n"
 "par_id3152823\n"
 "help.text"
-msgid "<variable id=\"versendentext\"><ahelp hid=\".uno:SendMail\">Opens a new window in your default e-mail program with the current document as an attachment. The current file format is used.</ahelp></variable> If the document is new and unsaved, the format specified in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Load/Save - General</emph> is used."
+msgid "<variable id=\"versendentext\"><ahelp hid=\".uno:SendMail\">Opens a new window in your default email program with the current document as an attachment. The current file format is used.</ahelp></variable> If the document is new and unsaved, the format specified in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Load/Save - General</emph> is used."
 msgstr ""
 
 #. w48Rf
@@ -13373,40 +13373,40 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/03170000.xhp\" name=\"Color Bar\">Color Bar</link>"
 msgstr "<link href=\"text/shared/01/03170000.xhp\" name=\"Barra de colors\">Barra de colors</link>"
 
-#. 9XrFG
+#. Cm952
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id3153255\n"
 "help.text"
-msgid "<ahelp hid=\".uno:ColorControl\">Show or hides the <emph>Color</emph> bar. To modify or change the color table that is displayed, choose <emph>Format - Area</emph>, and then click on the <emph>Colors</emph> tab.</ahelp>"
+msgid "<ahelp hid=\".uno:ColorControl\">Show or hide the <emph>Color</emph> bar. To modify or change the color table that is displayed, choose <emph>Format - Area</emph>, and then click on the <emph>Colors</emph> tab.</ahelp>"
 msgstr ""
 
-#. FeGUx
+#. EFZwD
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id3154186\n"
 "help.text"
-msgid "<ahelp hid=\"HID_COLOR_CTL_COLORS\">Click the color that you want to use. To change the fill color of an object in the current file, select the object and then click a color. To change the line color of the selected object, right-click a color. To change the color of text in a text object, double-click the text-object, select the text, and then click a color.</ahelp>"
-msgstr "<ahelp hid=\"HID_COLOR_CTL_COLORS\">Seleccioneu el color que voleu utilitzar. Per canviar el color d'emplenament d'un objecte del fitxer actual, seleccioneu l'objecte i, tot seguit, feu clic en un color. Per canviar el color de la línia de l'objecte seleccionat, feu clic amb el botó dret del ratolí en un color. Per canviar el color del text d'un objecte seleccionat, feu doble clic a l'objecte de text i seleccioneu el text; tot seguit, feu clic en un color.</ahelp>"
+msgid "<ahelp hid=\"HID_COLOR_CTL_COLORS\">To change the fill color of an object in the current file, select the object and then click a color. To change the line color of the selected object, right-click a color. To change the color of text in a text object, double-click the text-object, select the text, and then click a color.</ahelp>"
+msgstr ""
 
-#. B8AUe
+#. bo2uz
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id3147399\n"
 "help.text"
-msgid "You can also drag a color from the <emph>Color</emph> bar and drop it on a draw object on your slide."
+msgid "You can also drag a color from the <emph>Color</emph> bar and drop it on a draw object on your slide to change the fill color."
 msgstr ""
 
-#. Unnkj
+#. RxUos
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id3147009\n"
 "help.text"
-msgid "To detach the <emph>Color</emph> bar, click on a gray area of the toolbar and then drag. To reattach the <emph>Color</emph> bar, drag the title bar of the toolbar to the edge of the window."
+msgid "To detach the <emph>Color</emph> bar, click on a gray area of the toolbar and then drag. To reattach the <emph>Color</emph> bar, double click on an gray area of the color bar while pressing the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> key."
 msgstr ""
 
 #. pnFMd
@@ -22931,302 +22931,275 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/pageformatpage/spinMargBot\">Enter the amount of space to leave between the lower edge of the page and the document text.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/pageformatpage/spinMargBot\">Introduïu la quantitat d'espai que s'ha de deixar entre la vora inferior de la pàgina i el text del document.</ahelp>"
 
-#. LvDHs
-#: 05040200.xhp
-msgctxt ""
-"05040200.xhp\n"
-"par_id0522200809473735\n"
-"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Aligns the text on the selected Page Style to a vertical page grid.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Alinea el text de l'estil de pàgina seleccionat a una graella de pàgina vertical.</ahelp>"
-
-#. f6Gk9
+#. qBGYY
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3150488\n"
+"hd_id3147381\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Register-true</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Conforme al registre</caseinline></switchinline>"
+msgid "Layout settings"
+msgstr "Paràmetres de format"
 
-#. vFN34
+#. 5vzdZ
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3151112\n"
+"hd_id3145744\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><ahelp hid=\"cui/ui/pageformatpage/checkRegisterTrue\">Aligns the text on the selected Page Style to a vertical page grid.</ahelp> The spacing of the grid is defined by the <emph>Reference Style</emph>.</caseinline></switchinline>"
+msgid "Page layout"
 msgstr ""
 
-#. GQ3P2
-#: 05040200.xhp
-msgctxt ""
-"05040200.xhp\n"
-"par_id0522200809473732\n"
-"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Select the Paragraph Style that you want to use as a reference for lining up the text on the selected Page style. The height of the font that is specified in the reference style sets the spacing of the vertical page grid. </ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Seleccioneu l'estil de paràgraf que voleu utilitzar com a referència per alinear el text a l'estil de pàgina seleccionat. L'alçària del tipus de lletra que s'indica a l'estil de referència defineix l'espaiat de la graella de pàgina vertical. </ahelp>"
-
-#. hjY4c
-#: 05040200.xhp
-msgctxt ""
-"05040200.xhp\n"
-"hd_id3150686\n"
-"help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Reference Style</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Estil de referència</caseinline></switchinline>"
-
-#. UwDHV
+#. DMwZG
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3146146\n"
+"par_id3154218\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/pageformatpage/comboRegisterStyle\"><switchinline select=\"appl\"><caseinline select=\"WRITER\">Select the Paragraph Style that you want to use as a reference for lining up the text on the selected Page style. The height of the font that is specified in the reference style sets the spacing of the vertical page grid.</caseinline></switchinline></ahelp>"
-msgstr "<ahelp hid=\"cui/ui/pageformatpage/comboRegisterStyle\"><switchinline select=\"appl\"><caseinline select=\"WRITER\">Seleccioneu l'estil de paràgraf que voleu utilitzar com a referència per alinear el text amb l'estil de pàgina seleccionat. L'alçària del tipus de lletra indicada a l'estil de referència defineix l'espaiat de la graella de pàgina vertical.</caseinline></switchinline></ahelp>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/comboPageLayout\">Specify whether the current style should show odd pages, even pages, or both odd and even pages.</ahelp>"
+msgstr ""
 
-#. Dipg6
+#. GTUc7
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3147480\n"
+"hd_id3154946\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Table alignment</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Alineació de la taula</caseinline></switchinline>"
+msgid "Right and left"
+msgstr ""
 
-#. sBfv3
+#. PHbNi
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3150417\n"
+"par_id3153058\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Specify the alignment options for the cells on a printed page.</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Indiqueu les opcions d'alineació per a les cel·les en una pàgina impresa.</caseinline></switchinline>"
+msgid "The current page style shows both odd and even pages with left and right margins as specified."
+msgstr ""
 
-#. Rz6jD
+#. GDCeb
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id0522200809473845\n"
+"hd_id3147287\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Centers the cells horizontally on the printed page.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Centra les cel·les horitzontalment a la pàgina impresa.</ahelp>"
+msgid "Mirrored"
+msgstr ""
 
-#. P9pHm
+#. Nz3A7
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3147047\n"
+"par_id3147317\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Horizontal</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Horitzontal</caseinline></switchinline>"
+msgid "The current page style shows both odd and even pages with inner and outer margins as specified. Use this layout if you want to bind the printed pages like a book. Enter the binding space as the \"Inner\" margin."
+msgstr ""
 
-#. 3djJM
+#. HPAak
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3153878\n"
+"hd_id3155308\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonHorz\"><switchinline select=\"appl\"><caseinline select=\"CALC\">Centers the cells horizontally on the printed page.</caseinline></switchinline></ahelp>"
-msgstr "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonHorz\"><switchinline select=\"appl\"><caseinline select=\"CALC\">Centra les cel·les horitzontalment a la pàgina impresa.</caseinline></switchinline></ahelp>"
+msgid "Only right"
+msgstr ""
 
-#. TxE3H
+#. kxhBx
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id0522200809473811\n"
+"par_id3152885\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Centers the cells vertically on the printed page.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Centra les cel·les verticalment a la pàgina impresa.</ahelp>"
+msgid "The current page style shows only odd (right) pages. Even pages are shown as blank pages."
+msgstr ""
 
-#. 2e4aR
+#. VxnGV
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3153522\n"
+"hd_id3157309\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"CALC\">Vertical</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Vertical</caseinline></switchinline>"
+msgid "Only left"
+msgstr ""
 
-#. GXbtC
+#. 839AF
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3149413\n"
+"par_id3147326\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonVert\"><switchinline select=\"appl\"><caseinline select=\"CALC\">Centers the cells vertically on the printed page.</caseinline></switchinline></ahelp>"
-msgstr "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonVert\"><switchinline select=\"appl\"><caseinline select=\"CALC\">Centra les cel·les verticalment a la pàgina impresa.</caseinline></switchinline></ahelp>"
+msgid "The current page style shows only even (left) pages. Odd pages are shown as blank pages."
+msgstr ""
 
-#. qBGYY
+#. Dmugm
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3147381\n"
+"hd_id661587746131795\n"
 "help.text"
-msgid "Layout settings"
-msgstr "Paràmetres de format"
+msgid "Slide Numbers"
+msgstr ""
 
-#. HDL59
+#. 8Gvk9
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3151041\n"
+"par_id371587747950454\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Page Layout</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Format de la pàgina</defaultinline></switchinline>"
+msgid "Select the slide numbering format that you want to use for the current slide style."
+msgstr ""
 
-#. EtZD9
+#. Jr6w4
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3157962\n"
+"hd_id511587746163578\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Select the page layout style to use in the current document.</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Seleccioneu l'estil del format de pàgina que voleu utilitzar al document actual.</defaultinline></switchinline>"
+msgid "Page Numbers"
+msgstr ""
 
-#. GFSVh
+#. GnD6W
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3145744\n"
+"par_id3153745\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Page layout</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Format de la pàgina</defaultinline></switchinline>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/comboLayoutFormat\">Select the page numbering format that you want to use for the current page style.</ahelp>"
+msgstr "<ahelp hid=\"cui/ui/pageformatpage/comboLayoutFormat\">Seleccioneu el format de numeració de pàgina que voleu utilitzar per a l'estil de pàgina actual.</ahelp>"
 
-#. iyVDR
+#. z6iVY
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3154218\n"
+"hd_id3150488\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/pageformatpage/comboPageLayout\"><switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Specify whether the current style should show odd pages, even pages, or both odd and even pages.</defaultinline></switchinline></ahelp>"
-msgstr "<ahelp hid=\"cui/ui/pageformatpage/comboPageLayout\"><switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Indiqueu si l'estil actual ha de mostrar les pàgines imparelles, les parelles o bé ambdós tipus.</defaultinline></switchinline></ahelp>"
+msgid "Register-true"
+msgstr ""
 
-#. 4QgRL
+#. xRZFb
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3154946\n"
+"par_id3151112\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Right and left</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Dreta i esquerra</defaultinline></switchinline>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/checkRegisterTrue\">Aligns the text on the selected Page Style to a vertical page grid.</ahelp> The spacing of the grid is defined by the <emph>Reference Style</emph>."
+msgstr ""
 
-#. pPpne
+#. GQ3P2
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3153058\n"
+"par_id0522200809473732\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>The current page style shows both odd and even pages with left and right margins as specified.</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>L'estil de pàgina actual mostra les pàgines imparelles i les parelles amb els marges esquerre i dret com els hàgeu definit.</defaultinline></switchinline>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Select the Paragraph Style that you want to use as a reference for lining up the text on the selected Page style. The height of the font that is specified in the reference style sets the spacing of the vertical page grid. </ahelp>"
+msgstr "<ahelp hid=\".\" visibility=\"hidden\">Seleccioneu l'estil de paràgraf que voleu utilitzar com a referència per alinear el text a l'estil de pàgina seleccionat. L'alçària del tipus de lletra que s'indica a l'estil de referència defineix l'espaiat de la graella de pàgina vertical. </ahelp>"
 
-#. Mqqyj
+#. ja4mB
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3147287\n"
+"hd_id3150686\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Mirrored</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Reflectit</defaultinline></switchinline>"
+msgid "Reference Style"
+msgstr ""
 
-#. KzQZE
+#. hrqZy
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3147317\n"
+"par_id3146146\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>The current page style shows both odd and even pages with inner and outer margins as specified. Use this layout if you want to bind the printed pages like a book. Enter the binding space as the \"Inner\" margin.</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>L'estil de pàgina actual mostra les pàgines imparelles i parelles amb marges interiors i exteriors segons hàgeu indicat. Utilitzeu este format si voleu enquadernar les pàgines com un llibre. Introduïu l'espai d'enquadernació com el marge \"Interior\".</defaultinline></switchinline>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/comboRegisterStyle\">Select the Paragraph Style that you want to use as a reference for lining up the text on the selected Page style. The height of the font that is specified in the reference style sets the spacing of the vertical page grid.</ahelp>"
+msgstr ""
 
-#. FKFGE
+#. niqBy
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3155308\n"
+"hd_id3147480\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Only right</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Només dreta</defaultinline></switchinline>"
+msgid "Table alignment"
+msgstr ""
 
-#. UEoaQ
+#. 2fKA6
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3152885\n"
+"par_id3150417\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>The current page style shows only odd (right) pages. Even pages are shown as blank pages.</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>L'estil de pàgina actual només mostra les pàgines imparelles (dretes). Les pàgines parelles es mostren com a pàgines buides.</defaultinline></switchinline>"
+msgid "Specify the alignment options for the cells on a printed page."
+msgstr ""
 
-#. 4Eg8X
+#. Rz6jD
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3157309\n"
+"par_id0522200809473845\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Only left</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>Només esquerra</defaultinline></switchinline>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Centers the cells horizontally on the printed page.</ahelp>"
+msgstr "<ahelp hid=\".\" visibility=\"hidden\">Centra les cel·les horitzontalment a la pàgina impresa.</ahelp>"
 
-#. MxqiB
+#. CMpSv
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3147326\n"
+"hd_id3147047\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>The current page style shows only even (left) pages. Odd pages are shown as blank pages.</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"DRAW\"></caseinline><caseinline select=\"IMPRESS\"></caseinline><defaultinline>L'estil de pàgina actual només mostra les pàgines parelles (esquerres). Les pàgines imparelles es mostren com a pàgines buides.</defaultinline></switchinline>"
+msgid "Horizontal"
+msgstr ""
 
-#. vnByQ
+#. eARTv
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3155366\n"
+"par_id3153878\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Register-true</caseinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Conforme al registre</caseinline></switchinline>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonHorz\">Centers the cells horizontally on the printed page.</ahelp>"
+msgstr ""
 
-#. jsxVp
+#. TxE3H
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"hd_id3083281\n"
+"par_id0522200809473811\n"
 "help.text"
-msgid "Format"
-msgstr "Format"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Centers the cells vertically on the printed page.</ahelp>"
+msgstr "<ahelp hid=\".\" visibility=\"hidden\">Centra les cel·les verticalment a la pàgina impresa.</ahelp>"
 
-#. GnD6W
+#. WkDEo
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id3153745\n"
+"hd_id3153522\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/pageformatpage/comboLayoutFormat\">Select the page numbering format that you want to use for the current page style.</ahelp>"
-msgstr "<ahelp hid=\"cui/ui/pageformatpage/comboLayoutFormat\">Seleccioneu el format de numeració de pàgina que voleu utilitzar per a l'estil de pàgina actual.</ahelp>"
+msgid "Vertical"
+msgstr ""
 
-#. 5zUHB
+#. o9bGn
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
-"par_id0522200809473965\n"
+"par_id3149413\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Resizes the drawing objects so that they fit on the paper format that you select. The arrangement of the drawing objects is preserved.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Canvia la mida dels objectes de dibuix perquè s'ajusten al format de paper que seleccioneu. Es conserva la disposició dels objectes.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/checkbuttonVert\">Centers the cells vertically on the printed page.</ahelp>"
+msgstr ""
 
-#. eBEs3
+#. uCEW9
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
 "hd_id3151318\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"OFFICE\"></caseinline><caseinline select=\"WRITER\"></caseinline><caseinline select=\"CALC\"></caseinline><caseinline select=\"CHART\"></caseinline><caseinline select=\"MATH\"></caseinline><caseinline select=\"IMAGE\"></caseinline><defaultinline>AutoFit object to page format</defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"OFFICE\"></caseinline><caseinline select=\"WRITER\"></caseinline><caseinline select=\"CALC\"></caseinline><caseinline select=\"CHART\"></caseinline><caseinline select=\"MATH\"></caseinline><caseinline select=\"IMAGE\"></caseinline><defaultinline>Ajusta l'objecte automàticament al format de la pàgina</defaultinline></switchinline>"
+msgid "Fit object to page format"
+msgstr ""
 
-#. 8bAyw
+#. AEasi
 #: 05040200.xhp
 msgctxt ""
 "05040200.xhp\n"
 "par_id3144746\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"OFFICE\"></caseinline><caseinline select=\"WRITER\"></caseinline><caseinline select=\"CALC\"></caseinline><caseinline select=\"CHART\"></caseinline><caseinline select=\"MATH\"></caseinline><caseinline select=\"IMAGE\"></caseinline><defaultinline><ahelp hid=\"cui/ui/pageformatpage/checkAdaptBox\">Resizes the drawing objects so that they fit on the paper format that you select. The arrangement of the drawing objects is preserved.</ahelp></defaultinline></switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"OFFICE\"></caseinline><caseinline select=\"WRITER\"></caseinline><caseinline select=\"CALC\"></caseinline><caseinline select=\"CHART\"></caseinline><caseinline select=\"MATH\"></caseinline><caseinline select=\"IMAGE\"></caseinline><defaultinline><ahelp hid=\"cui/ui/pageformatpage/checkAdaptBox\">Canvia la mida dels objectes de dibuix perquè s'ajusten al format de paper que seleccioneu. Es conserva la disposició dels objectes.</ahelp></defaultinline></switchinline>"
+msgid "<ahelp hid=\"cui/ui/pageformatpage/checkAdaptBox\">Resizes the drawing objects so that they fit on the paper format that you select. The arrangement of the drawing objects is preserved.</ahelp>"
+msgstr ""
 
 #. CFGcg
 #: 05040200.xhp
@@ -47447,13 +47420,13 @@ msgctxt ""
 msgid "JPEG compression"
 msgstr ""
 
-#. z3ei4
+#. kiiWk
 #: ref_pdf_export_general.xhp
 msgctxt ""
 "ref_pdf_export_general.xhp\n"
 "par_idN10734\n"
 "help.text"
-msgid "<ahelp hid=\".\">Selects a JPEG compression of images. With a high quality level, almost all pixels are preserved. With a low quality level, some pixels get lost and artefacts are introduced, but file sizes are reduced.</ahelp>"
+msgid "<ahelp hid=\".\">Select a JPEG compression level. With a high quality level, almost all pixels are preserved. With a low quality level, some pixels are lost and artifacts are introduced, but file sizes are reduced.</ahelp>"
 msgstr ""
 
 #. MZoXB
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po b/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po
index ee98ff0cf78..7f08f0cf5d6 100644
--- a/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2019-08-21 21:37+0200\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-11-12 13:23+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7433,14 +7433,14 @@ msgctxt ""
 msgid "Database Wizard"
 msgstr "Auxiliar de bases de dades"
 
-#. XLALx
+#. 3PAca
 #: dabawiz00.xhp
 msgctxt ""
 "dabawiz00.xhp\n"
 "bm_id2026429\n"
 "help.text"
-msgid "<bookmark_value>wizards;databases (Base)</bookmark_value><bookmark_value>Database Wizard (Base)</bookmark_value><bookmark_value>databases; formats (Base)</bookmark_value><bookmark_value>MySQL databases (Base)</bookmark_value><bookmark_value>dBASE; database settings (Base)</bookmark_value><bookmark_value>spreadsheets;as databases (base)</bookmark_value>"
-msgstr "<bookmark_value>auxiliars;bases de dades (Base)</bookmark_value><bookmark_value>Auxiliar de bases de dades (Base)</bookmark_value><bookmark_value>bases de dades; formats (Base)</bookmark_value><bookmark_value>bases de dades MySQL (Base)</bookmark_value><bookmark_value>dBASE; paràmetres de la base de dades (Base)</bookmark_value><bookmark_value>fulls de càlcul;com a bases de dades (base)</bookmark_value>"
+msgid "<bookmark_value>wizards;databases (Base)</bookmark_value><bookmark_value>Database Wizard (Base)</bookmark_value><bookmark_value>databases; formats (Base)</bookmark_value><bookmark_value>MySQL databases (Base)</bookmark_value><bookmark_value>MariaDB databases (Base)</bookmark_value><bookmark_value>dBASE; database settings (Base)</bookmark_value><bookmark_value>spreadsheets;as databases (base)</bookmark_value>"
+msgstr ""
 
 #. 4QDPm
 #: dabawiz00.xhp
@@ -7559,15 +7559,6 @@ msgctxt ""
 msgid "<link href=\"text/shared/explorer/database/dabawiz02oracle.xhp\">Set up Oracle database connection</link>"
 msgstr "<link href=\"text/shared/explorer/database/dabawiz02oracle.xhp\">Estableix una connexió a una base de dades Oracle</link>"
 
-#. 5MVrE
-#: dabawiz00.xhp
-msgctxt ""
-"dabawiz00.xhp\n"
-"par_idN1065B\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">MySQL settings</link>"
-msgstr "<link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">Paràmetres MySQL</link>"
-
 #. sSrMX
 #: dabawiz00.xhp
 msgctxt ""
@@ -7811,15 +7802,6 @@ msgctxt ""
 msgid "<link href=\"text/shared/explorer/database/dabawiz02oracle.xhp\">Set up Oracle database connection</link>"
 msgstr "<link href=\"text/shared/explorer/database/dabawiz02oracle.xhp\">Estableix una connexió a una base de dades Oracle</link>"
 
-#. amnDm
-#: dabawiz01.xhp
-msgctxt ""
-"dabawiz01.xhp\n"
-"par_idN10685\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">MySQL settings</link>"
-msgstr "<link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">Paràmetres MySQL</link>"
-
 #. JtGv6
 #: dabawiz01.xhp
 msgctxt ""
@@ -8702,23 +8684,131 @@ msgctxt ""
 msgid "MySQL Connection"
 msgstr "Connexió a una base de dades MySQL"
 
-#. rHNho
+#. B5kKY
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"bm_id861587404584956\n"
+"help.text"
+msgid "<bookmark_value>MariaDB settings (base)</bookmark_value><bookmark_value>MySQL settings (base)</bookmark_value>"
+msgstr ""
+
+#. f4CzF
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "par_idN10549\n"
 "help.text"
-msgid "<variable id=\"mysql\"><link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">MySQL Connection</link></variable>"
-msgstr "<variable id=\"mysql\"><link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">Connexió a una base de dades MySQL</link></variable>"
+msgid "<variable id=\"mysql\"><link href=\"text/shared/explorer/database/dabawiz02mysql.xhp\">MariaDB and MySQL Connection</link></variable>"
+msgstr ""
 
-#. gyEi3
+#. 5FPU6
 #: dabawiz02mysql.xhp
 msgctxt ""
 "dabawiz02mysql.xhp\n"
 "par_idN1054D\n"
 "help.text"
-msgid "<ahelp hid=\".\">Specifies the options for MySQL databases.</ahelp>"
-msgstr "<ahelp hid=\".\">Indica les opcions per a les bases de dades MySQL.</ahelp>"
+msgid "<ahelp hid=\".\">Specifies the options for MariaDB and MySQL databases.</ahelp>"
+msgstr ""
+
+#. Bmcwo
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id661587405298284\n"
+"help.text"
+msgid "Direct Connection for MariaDB and MySQL databases"
+msgstr ""
+
+#. vd9VD
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id321587405303769\n"
+"help.text"
+msgid "Database name"
+msgstr ""
+
+#. 6LAsi
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"par_id371587405314376\n"
+"help.text"
+msgid "Enter the name of the MariaDB or MySQL database. Ask your database administrator for the correct name."
+msgstr ""
+
+#. jbdZp
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id561587405334695\n"
+"help.text"
+msgid "Server URL"
+msgstr ""
+
+#. Dw4Qu
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"par_id521587405341138\n"
+"help.text"
+msgid "Enter the URL for the database server. This is the name of the machine that runs the MariaDB or MYSQL database. You can also replace hostname with the IP address of the server."
+msgstr ""
+
+#. MZQiq
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id171587405349438\n"
+"help.text"
+msgid "Port number"
+msgstr ""
+
+#. J2SR3
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"par_id1001587405358390\n"
+"help.text"
+msgid "Enter the port number for the database server. Ask your database administrator for the correct port address. The default port number for MySQL or MariaDB databases is 3306."
+msgstr ""
+
+#. ovKhU
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id121587407845730\n"
+"help.text"
+msgid "Named Pipe"
+msgstr ""
+
+#. Rq89B
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"par_id941587407987180\n"
+"help.text"
+msgid "If the MariaDB or MySQL database is to be accessed by a named pipe, enter its name."
+msgstr ""
+
+#. wF6bj
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"hd_id161587405553671\n"
+"help.text"
+msgid "Socket"
+msgstr ""
+
+#. e8DB2
+#: dabawiz02mysql.xhp
+msgctxt ""
+"dabawiz02mysql.xhp\n"
+"par_id161587405561472\n"
+"help.text"
+msgid "If the MariaDB or MySQL database is to be accessed by a socket, enter the socket ID."
+msgstr ""
 
 #. fpBNu
 #: dabawiz02mysql.xhp
@@ -14722,4 +14812,3 @@ msgctxt ""
 "help.text"
 msgid "<ahelp hid=\".\">Renames the selected report.</ahelp>"
 msgstr "<ahelp hid=\".\">Canvia el nom de l'informe seleccionat.</ahelp>"
-
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/guide.po b/source/ca-valencia/helpcontent2/source/text/shared/guide.po
index 58c081d8165..9a5c4341150 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: 2020-03-13 12:06+0100\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-11-14 11:53+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4535,15 +4535,6 @@ msgctxt ""
 msgid "SYLK"
 msgstr ""
 
-#. hmDBC
-#: convertfilters.xhp
-msgctxt ""
-"convertfilters.xhp\n"
-"par_calc115\n"
-"help.text"
-msgid "text/spreadsheet"
-msgstr ""
-
 #. NGUiE
 #: convertfilters.xhp
 msgctxt ""
@@ -10709,23 +10700,23 @@ msgctxt ""
 msgid "Working in $[officename], you can send the current document as an e-mail attachment."
 msgstr "Quan treballeu amb el $[officename], podeu enviar el document actual com a adjunció de correu electrònic."
 
-#. mkBqj
+#. 8jsBd
 #: email.xhp
 msgctxt ""
 "email.xhp\n"
 "par_id3147335\n"
 "help.text"
-msgid "Choose <emph>File - Send - E-mail Document</emph>."
-msgstr "Trieu <emph>Fitxer ▸ Envia ▸ Document com a correu electrònic</emph>"
+msgid "Choose <emph>File - Send - Email Document</emph>."
+msgstr ""
 
-#. ViJCg
+#. EGqDe
 #: email.xhp
 msgctxt ""
 "email.xhp\n"
 "par_id3153127\n"
 "help.text"
-msgid "$[officename] opens your default e-mail program.<switchinline select=\"sys\"><caseinline select=\"UNIX\"> If you want to send the current document with another e-mail program, you can select the program to use with <emph>Internet - E-mail</emph> in the Options dialog box.</caseinline></switchinline>"
-msgstr "El $[officename] obri el vostre programa de correu electrònic per defecte.<switchinline select=\"sys\"><caseinline select=\"UNIX\"> Si voleu enviar el document actual amb un altre programa de correu, podeu seleccionar el programa que cal utilitzar amb <emph>Internet - Correu electrònic</emph> del quadre de diàleg Opcions.</caseinline></switchinline>"
+msgid "$[officename] opens your default email program.<switchinline select=\"sys\"><caseinline select=\"UNIX\"> If you want to send the current document with another email program, you can select the program to use with <emph>Internet - Email</emph> in the Options dialog box.</caseinline></switchinline>"
+msgstr ""
 
 #. 3vDxY
 #: email.xhp
@@ -20159,13 +20150,13 @@ msgctxt ""
 msgid "URL or Text"
 msgstr ""
 
-#. XRjvN
+#. ikC8E
 #: qrcode.xhp
 msgctxt ""
 "qrcode.xhp\n"
 "par_id251566316519649\n"
 "help.text"
-msgid "The text for which the QR Code is generated."
+msgid "The text from which to generate the QR code."
 msgstr ""
 
 #. 6mj5K
@@ -20240,13 +20231,13 @@ msgctxt ""
 msgid "Border"
 msgstr ""
 
-#. AbnEH
+#. wz9kT
 #: qrcode.xhp
 msgctxt ""
 "qrcode.xhp\n"
 "par_id981566316947064\n"
 "help.text"
-msgid "The border width in dots surrounding the QR Code. Must be a non-negative value."
+msgid "The width in dots of the border surrounding the QR code."
 msgstr ""
 
 #. kZPNW
@@ -20447,22 +20438,22 @@ msgctxt ""
 msgid "The <emph>Redacted Export</emph> button box has two options:"
 msgstr ""
 
-#. H66t9
+#. pBqFG
 #: redaction.xhp
 msgctxt ""
 "redaction.xhp\n"
 "par_id551562796791417\n"
 "help.text"
-msgid "<emph>Redacted Export (Black)</emph>: finalize your document by converting the transparent grey redaction shapes to opaque black and export as a pixellized PDF file."
+msgid "<emph>Redacted Export (Black)</emph>: finalize your document by converting the semitransparent redaction shapes to opaque black and export as a pixellized PDF file."
 msgstr ""
 
-#. o3usW
+#. Z5u4M
 #: redaction.xhp
 msgctxt ""
 "redaction.xhp\n"
 "par_id191562796822685\n"
 "help.text"
-msgid "<emph>Redacted Export (White)</emph>: finalize your document by converting the transparent grey redaction shapes to opaque white shapes, and export as a pixellized PDF file."
+msgid "<emph>Redacted Export (White)</emph>: finalize your document by converting the semitransparent redaction shapes to opaque white shapes, and export as a pixellized PDF file."
 msgstr ""
 
 #. 2w5mE
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/optionen.po b/source/ca-valencia/helpcontent2/source/text/shared/optionen.po
index 1e33e34a8c0..4b83e6cf924 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: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-11-14 11:53+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2438,13 +2438,13 @@ msgctxt ""
 msgid "The Pick a Color Window"
 msgstr ""
 
-#. 5u2bL
+#. Xu7fM
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3148944\n"
 "help.text"
-msgid "The Pick a Color Dialog window consist of four main areas."
+msgid "The Pick a Color dialog consists of four main areas."
 msgstr ""
 
 #. JA9HB
@@ -2537,13 +2537,13 @@ msgctxt ""
 msgid "Red"
 msgstr "Roig"
 
-#. KRqXB
+#. kAiQV
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153727\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Red component modifiable on the vertical color slider, and the Green and Blue components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Red component modifiable on the vertical color slider, and the Green and Blue components in the two-dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
 msgstr ""
 
 #. G5BRr
@@ -2564,13 +2564,13 @@ msgctxt ""
 msgid "Green"
 msgstr "Verd"
 
-#. LNRYj
+#. jBJPJ
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153728\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Green component modifiable on the vertical color slider, and the Red and Blue components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Green component modifiable on the vertical color slider, and the Red and Blue components in the two-dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
 msgstr ""
 
 #. NauiA
@@ -2591,13 +2591,13 @@ msgctxt ""
 msgid "Blue"
 msgstr "Blau"
 
-#. 6NiMC
+#. gBqSU
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153729\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Blue component modifiable on the vertical color slider, and the Green and Red components in the two dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Blue component modifiable on the vertical color slider, and the Green and Red components in the two-dimensional color picker field. Allowed values are 0 to 255.</ahelp>"
 msgstr ""
 
 #. EHQDG
@@ -2645,13 +2645,13 @@ msgctxt ""
 msgid "Hue"
 msgstr ""
 
-#. 7Myy2
+#. 7Zvps
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153730\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Hue component modifiable on the vertical color slider, and the Saturation and Brightness components in the two dimensional color picker field. Values are expressed in degrees from 0 to 359.</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Hue component modifiable on the vertical color slider, and the Saturation and Brightness components in the two-dimensional color picker field. Values are expressed in degrees from 0 to 359.</ahelp>"
 msgstr ""
 
 #. fGAJ5
@@ -2672,13 +2672,13 @@ msgctxt ""
 msgid "Saturation"
 msgstr "Saturació"
 
-#. JwuTb
+#. 7KBnT
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153731\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Saturation component modifiable on the vertical color slider, and the Hue and Brightness components in the two dimensional color picker field. Values are expressed in percent ( 0 to 100).</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Saturation component modifiable on the vertical color slider, and the Hue and Brightness components in the two-dimensional color picker field. Values are expressed in percent (0 to 100).</ahelp>"
 msgstr ""
 
 #. cuCGT
@@ -2699,13 +2699,13 @@ msgctxt ""
 msgid "Brightness"
 msgstr ""
 
-#. 8vuKh
+#. NEpUE
 #: 01010501.xhp
 msgctxt ""
 "01010501.xhp\n"
 "par_id3153732\n"
 "help.text"
-msgid "<ahelp hid=\".\">Sets the Brightness component modifiable on the vertical color slider, and the Hue and Saturation components in the two dimensional color picker field. Values are expressed in percent ( 0 to 100).</ahelp>"
+msgid "<ahelp hid=\".\">Sets the Brightness component modifiable on the vertical color slider, and the Hue and Saturation components in the two-dimensional color picker field. Values are expressed in percent (0 to 100).</ahelp>"
 msgstr ""
 
 #. uDLZu
@@ -2987,13 +2987,13 @@ msgctxt ""
 msgid "%PRODUCTNAME File Associations"
 msgstr ""
 
-#. ZFtaG
+#. sAAWp
 #: 01010600.xhp
 msgctxt ""
 "01010600.xhp\n"
 "hd_id81581845691263\n"
 "help.text"
-msgid "Windows Default apps"
+msgid "Windows Default Apps"
 msgstr ""
 
 #. BnQGA
@@ -4364,13 +4364,13 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/optappearancepage/colorconfig\">Select the colors for the user interface elements.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/optappearancepage/colorconfig\">Seleccioneu els colors per als elements de la interfície d'usuari.</ahelp>"
 
-#. gBGAR
+#. 4JfXR
 #: 01012000.xhp
 msgctxt ""
 "01012000.xhp\n"
 "par_id3150769\n"
 "help.text"
-msgid "To apply a color to a <emph>user interface element</emph>, ensure that the checkbox in front of the name is marked. To hide a user interface element, clear the check box."
+msgid "To apply a color to a <emph>user interface element</emph>, ensure that the box in front of the name is checked. To hide a user interface element, clear the check box."
 msgstr ""
 
 #. LRXwH
diff --git a/source/ca-valencia/helpcontent2/source/text/simpress/guide.po b/source/ca-valencia/helpcontent2/source/text/simpress/guide.po
index 5b142699d9c..aab61a36ce3 100644
--- a/source/ca-valencia/helpcontent2/source/text/simpress/guide.po
+++ b/source/ca-valencia/helpcontent2/source/text/simpress/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-01-07 14:10+0100\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-09-03 12:44+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -44,14 +44,14 @@ msgctxt ""
 msgid "<variable id=\"3d_create\"><link href=\"text/simpress/guide/3d_create.xhp\" name=\"Converting 2D Objects to Curves, Polygons, and 3D Objects\">Converting 2D Objects to Curves, Polygons, and 3D Objects</link></variable>"
 msgstr "<variable id=\"3d_create\"><link href=\"text/simpress/guide/3d_create.xhp\" name=\"Conversió d'objectes 2D en corbes, polígons i objectes 3D\">Conversió d'objectes 2D en corbes, polígons i objectes 3D</link></variable>"
 
-#. 34igE
+#. eDyDq
 #: 3d_create.xhp
 msgctxt ""
 "3d_create.xhp\n"
 "par_id3153914\n"
 "help.text"
-msgid "You can convert two dimensional (2D) objects to create different shapes. $[officename] can convert 2D objects to the following object types:"
-msgstr "Podeu convertir objectes bidimensionals (2D) per crear formes diferents. El $[officename] pot convertir objectes 2D en els tipus d'objectes següents:"
+msgid "You can convert two-dimensional (2D) objects to create different shapes. $[officename] can convert 2D objects to the following object types:"
+msgstr ""
 
 #. dog6J
 #: 3d_create.xhp
@@ -4607,13 +4607,13 @@ msgctxt ""
 msgid "Locate the files you want to insert."
 msgstr ""
 
-#. F8Go2
+#. EPWAM
 #: photo_album.xhp
 msgctxt ""
 "photo_album.xhp\n"
 "par_id221120161524594919\n"
 "help.text"
-msgid "Note: If several images are in the same folder, you can select a group of photos using the Shift or Ctrl keys while clicking on their filenames."
+msgid "If several images are in the same folder, you can select a group of photos using the Shift or Ctrl keys while clicking on their filenames."
 msgstr ""
 
 #. z7nPC
@@ -4625,13 +4625,13 @@ msgctxt ""
 msgid "Click <item type=\"menuitem\">Open</item> to add the files to the Photo Album."
 msgstr ""
 
-#. RER5u
+#. xG2Jt
 #: photo_album.xhp
 msgctxt ""
 "photo_album.xhp\n"
 "par_id221120161524591012\n"
 "help.text"
-msgid "Tip: Click on a file name to display it in the <item type=\"menuitem\">Preview</item> area"
+msgid "Click on a file name to display it in the <item type=\"menuitem\">Preview</item> area"
 msgstr ""
 
 #. tkYeB
@@ -4688,13 +4688,13 @@ msgctxt ""
 msgid "Click <item type=\"menuitem\">Insert Slides</item>."
 msgstr ""
 
-#. RiddC
+#. VJePm
 #: photo_album.xhp
 msgctxt ""
 "photo_album.xhp\n"
 "par_id221120161524501012\n"
 "help.text"
-msgid "Warning: Clicking Undo will not delete a photo album. Right-click the slides on the slide panel and select <item type=\"menuitem\">Delete Slide</item> to delete the slides."
+msgid "Clicking Undo will not delete a photo album. Right-click the slides on the slide panel and select <item type=\"menuitem\">Delete Slide</item> to delete the slides."
 msgstr ""
 
 #. cs5Gr
diff --git a/source/ca-valencia/helpcontent2/source/text/smath/01.po b/source/ca-valencia/helpcontent2/source/text/smath/01.po
index 4806ec938a9..c9ff00ce7cb 100644
--- a/source/ca-valencia/helpcontent2/source/text/smath/01.po
+++ b/source/ca-valencia/helpcontent2/source/text/smath/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-11-12 13:23+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13823,13 +13823,13 @@ msgctxt ""
 msgid "<variable id=\"chemicalh1\"><link href=\"text/smath/01/chemical.xhp\" name=\"Chemical Formulas\">Chemical Formulas Examples</link></variable>"
 msgstr ""
 
-#. 9RNL8
+#. Uo7jh
 #: chemical.xhp
 msgctxt ""
 "chemical.xhp\n"
 "par_id111584200892379\n"
 "help.text"
-msgid "The primary purpose of %PRODUCTNAME Math is to create mathematical formulas, but it can also be used to write chemical formulas. However, in chemical formulas, the chemical symbols are normally written in uppercase using non-italic characters."
+msgid "The primary purpose of %PRODUCTNAME Math is to create mathematical formulas, but it can also be used to write chemical formulas. However, in chemical formulas, the chemical symbols are normally written in uppercase using upright, rather than italic, characters."
 msgstr ""
 
 #. CLnAG
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter.po b/source/ca-valencia/helpcontent2/source/text/swriter.po
index e97a5b5fada..b6d7c332b26 100644
--- a/source/ca-valencia/helpcontent2/source/text/swriter.po
+++ b/source/ca-valencia/helpcontent2/source/text/swriter.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-13 12:06+0100\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-10-21 20:06+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1124,15 +1124,6 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/06050000.xhp\" name=\"Numbering/Bullets\">Bullets and Numbering</link>"
 msgstr "<link href=\"text/shared/01/06050000.xhp\" name=\"Numeració i pics\">Numeració i pics</link>"
 
-#. aLDgG
-#: main0105.xhp
-msgctxt ""
-"main0105.xhp\n"
-"hd_id3145692\n"
-"help.text"
-msgid "<link href=\"text/swriter/01/05040000.xhp\" name=\"Page\">Page</link>"
-msgstr "<link href=\"text/swriter/01/05040000.xhp\" name=\"Pàgina\">Pàgina</link>"
-
 #. Sib7N
 #: main0105.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/00.po b/source/ca-valencia/helpcontent2/source/text/swriter/00.po
index c97e21bb3aa..3fa475179c4 100644
--- a/source/ca-valencia/helpcontent2/source/text/swriter/00.po
+++ b/source/ca-valencia/helpcontent2/source/text/swriter/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-06 11:46+0100\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2019-07-21 12:11+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1538,13 +1538,13 @@ msgctxt ""
 msgid "Choose <menuitem>Styles - Manage Styles</menuitem>"
 msgstr ""
 
-#. GDexs
+#. THBBY
 #: 00000405.xhp
 msgctxt ""
 "00000405.xhp\n"
 "par_id3152947\n"
 "help.text"
-msgid "Choose <menuitem>Format - Page</menuitem>."
+msgid "Choose <menuitem>Format - Page Style</menuitem>."
 msgstr ""
 
 #. 5B3jU
@@ -1592,13 +1592,13 @@ msgctxt ""
 msgid "<variable id=\"spaltenber\">Choose <menuitem>Format - Sections - Options</menuitem> button.</variable>"
 msgstr ""
 
-#. GqyGY
+#. w4TAg
 #: 00000405.xhp
 msgctxt ""
 "00000405.xhp\n"
 "par_id3150836\n"
 "help.text"
-msgid "Choose <emph>Format - Page - Columns</emph> tab."
+msgid "Choose <emph>Format - Page Style - Columns</emph> tab."
 msgstr ""
 
 #. 9F5Bz
@@ -1637,13 +1637,13 @@ msgctxt ""
 msgid "Choose <emph>Insert/Format - Section(s) - Columns</emph> tab."
 msgstr ""
 
-#. 2LmDy
+#. Gdf8J
 #: 00000405.xhp
 msgctxt ""
 "00000405.xhp\n"
 "par_id3149817\n"
 "help.text"
-msgid "Choose <emph>Format - Page - Footnote</emph> tab."
+msgid "Choose <emph>Format - Page Style - Footnote</emph> tab."
 msgstr ""
 
 #. CDmGU
@@ -2546,14 +2546,14 @@ msgctxt ""
 msgid "Frame Properties"
 msgstr "Propietats del marc"
 
-#. bfpT5
+#. NAGGT
 #: 00000405.xhp
 msgctxt ""
 "00000405.xhp\n"
 "par_id3150140\n"
 "help.text"
-msgid "Menu <emph>Format - Page</emph> - tab <emph>Text Grid</emph>, if Asian language support is enabled"
-msgstr "Menú <emph>Format - Pàgina</emph>, pestanya <emph>Graella de text</emph>, si s'ha habilitat la compatibilitat amb llengües asiàtiques"
+msgid "Menu <emph>Format - Page Style </emph> - tab <emph>Text Grid</emph>, if Asian language support is enabled"
+msgstr ""
 
 #. aFWLc
 #: 00000406.xhp
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/01.po b/source/ca-valencia/helpcontent2/source/text/swriter/01.po
index a8967322c48..43f78106c3e 100644
--- a/source/ca-valencia/helpcontent2/source/text/swriter/01.po
+++ b/source/ca-valencia/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-04-08 14:22+0200\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-10-21 20:06+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -15911,23 +15911,23 @@ msgctxt ""
 msgid "Page Style"
 msgstr "Estil de pàgina"
 
-#. Ez2SK
+#. AfM8s
 #: 05040000.xhp
 msgctxt ""
 "05040000.xhp\n"
 "hd_id3150016\n"
 "help.text"
-msgid "Page Style"
-msgstr "Estil de pàgina"
+msgid "<link href=\"text/swriter/01/05040000.xhp\" name=\"Page Style\">Page Style</link>"
+msgstr ""
 
-#. gDHfG
+#. sJBg6
 #: 05040000.xhp
 msgctxt ""
 "05040000.xhp\n"
 "par_id3148774\n"
 "help.text"
-msgid "<variable id=\"seitetext\"><ahelp hid=\".uno:PageDialog\">Specify the formatting styles and the layout for the current page style, including page margins, headers and footers, and the page background.</ahelp></variable>"
-msgstr "<variable id=\"seitetext\"><ahelp hid=\".uno:PageDialog\">Especifiqueu els estils de formatació i el format per a l'estil de pàgina actual, inclosos els marges de la pàgina, les capçaleres i els peus, així com el fons de la pàgina.</ahelp></variable>"
+msgid "<ahelp hid=\".uno:PageDialog\">Specify the formatting styles and the layout for the current page style, including page margins, headers and footers, and the page background.</ahelp>"
+msgstr ""
 
 #. zsFam
 #: 05040500.xhp
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/guide.po b/source/ca-valencia/helpcontent2/source/text/swriter/guide.po
index e9d0ec55e4e..a424f3ad868 100644
--- a/source/ca-valencia/helpcontent2/source/text/swriter/guide.po
+++ b/source/ca-valencia/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-03-13 12:06+0100\n"
+"POT-Creation-Date: 2020-04-27 15:55+0200\n"
 "PO-Revision-Date: 2018-11-12 13:23+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -11654,14 +11654,14 @@ msgctxt ""
 msgid "If your text document consists only of pages with the same page style, you can change the page properties directly:"
 msgstr "Si el document de text només conté pàgines amb el mateix estil de pàgina, podreu canviar les propietats de pàgina directament:"
 
-#. acrHD
+#. GuYFH
 #: pageorientation.xhp
 msgctxt ""
 "pageorientation.xhp\n"
 "par_id5256508\n"
 "help.text"
-msgid "Choose <emph>Format - Page</emph>."
-msgstr "Trieu <emph>Format - Pàgina</emph>."
+msgid "Choose <menuitem>Format - Page Style</menuitem>."
+msgstr ""
 
 #. vVVCj
 #: pageorientation.xhp
@@ -11843,14 +11843,14 @@ msgctxt ""
 msgid "One Page Long Styles"
 msgstr "Estils de pàgina per a una sola pàgina"
 
-#. uX9ZG
+#. UptGH
 #: pageorientation.xhp
 msgctxt ""
 "pageorientation.xhp\n"
 "par_id5169225\n"
 "help.text"
-msgid "A page style can be defined to span one page only. The “First Page” style is an example. You set this property by defining another page style to be the \"next style\", on the <item type=\"menuitem\">Format - Page - Organizer</item> tab page."
-msgstr "Podeu establir que un estil de pàgina s'estengui només a una sola pàgina. Este és el cas, per exemple, de l'estil \"Primera pàgina\". Per establir esta propietat, heu de definir un altre estil de pàgina com a \"estil següent\" a la pestanya <item type=\"menuitem\">Format - Pàgina - Organitzador</item>."
+msgid "A page style can be defined to span one page only. The “First Page” style is an example. You set this property by defining another page style to be the \"next style\", on the <menuitem>Format - Page Style - Organizer</menuitem> tab page."
+msgstr ""
 
 #. BorA4
 #: pageorientation.xhp
@@ -11879,14 +11879,14 @@ msgctxt ""
 msgid "Manually Defined Range of a Page style"
 msgstr "Abast d'un estil de pàgina definit de manera manual"
 
-#. 4PsyS
+#. BCFqC
 #: pageorientation.xhp
 msgctxt ""
 "pageorientation.xhp\n"
 "par_id6386913\n"
 "help.text"
-msgid "The “Default” page style does not set a different \"next style\" on the <item type=\"menuitem\">Format - Page - Organizer</item> tab page. Instead, the \"next style\" is set also to be “Default”. All page styles that are followed by the same page style can span multiple pages. The lower and upper borders of the page style range are defined by \"page breaks with style\". All the pages between any two \"page breaks with style\" use the same page style."
-msgstr "L'estil de pàgina \"Per defecte\" no defineix un \"estil següent\" diferent a la pestanya <item type=\"menuitem\">Format - Pàgina - Organitzador</item>, sinó que este \"estil següent\" també rep el format \"Per defecte\". Tots els estils de pàgina que vagin seguits del mateix estil de pàgina es poden estendre a més d'una pàgina. Noteu que les vores inferior i superior de l'abast de l'estil de pàgina queden definides pels \"salts de pàgina amb estil\". D'esta manera, totes les pàgines que es troben entre dos \"salts de pàgina amb estil\" utilitzaran el mateix estil de pàgina."
+msgid "The “Default” page style does not set a different \"next style\" on the <menuitem>Format - Page Style - Organizer</menuitem> tab page. Instead, the \"next style\" is set also to be “Default”. All page styles that are followed by the same page style can span multiple pages. The lower and upper borders of the page style range are defined by \"page breaks with style\". All the pages between any two \"page breaks with style\" use the same page style."
+msgstr ""
 
 #. pyFgt
 #: pageorientation.xhp
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-04-29 23:23:16 +0200
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2020-04-29 23:28:46 +0200
commit	2a61ce8496f6a5633af3ec710882358c3836abd0 (patch)
tree	e7ce6b15f564f773937ba697696b6f89aea04667 /source/ca-valencia/helpcontent2
parent	6b2e705c5e47924cfa7c0ae90ab9d5d69cf87cb8 (diff)