update translations for master/7.4.0 beta1 libreoffice-7-4-branch-point

and force-fix errors using pocheck

Change-Id: I6b70cdc276c670e1eb166910f095c46e81256a7f

4 files changed, 456 insertions, 90 deletions

diff --git a/source/ca-valencia/cui/messages.po b/source/ca-valencia/cui/messages.po
index fd80e412b29..9984d8e0d42 100644
--- a/source/ca-valencia/cui/messages.po
+++ b/source/ca-valencia/cui/messages.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: 2022-06-09 11:49+0200\n"
+"POT-Creation-Date: 2022-06-10 13:57+0200\n"
 "PO-Revision-Date: 2021-01-12 09:36+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_ui-master/cuimessages/ca_VALENCIA/>\n"
@@ -3782,350 +3782,356 @@ msgctxt "SID_LANGUAGE_OPTIONS_RES"
 msgid "Complex Text Layout"
 msgstr "Disposició complexa de text"
 
+#. ix6bE
+#: cui/inc/treeopt.hrc:59
+msgctxt "SID_LANGUAGE_OPTIONS_RES"
+msgid "LanguageTool Server Settings"
+msgstr ""
+
 #. TGnig
-#: cui/inc/treeopt.hrc:63
+#: cui/inc/treeopt.hrc:64
 msgctxt "SID_INET_DLG_RES"
 msgid "Internet"
 msgstr "Internet"
 
 #. QJNEE
-#: cui/inc/treeopt.hrc:64
+#: cui/inc/treeopt.hrc:65
 msgctxt "SID_INET_DLG_RES"
 msgid "Proxy"
 msgstr "Servidor intermediari"
 
 #. EhHFs
-#: cui/inc/treeopt.hrc:65
+#: cui/inc/treeopt.hrc:66
 msgctxt "SID_INET_DLG_RES"
 msgid "Email"
 msgstr "Adreça electrònica"
 
 #. 4Cajf
-#: cui/inc/treeopt.hrc:70
+#: cui/inc/treeopt.hrc:71
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "%PRODUCTNAME Writer"
 msgstr "%PRODUCTNAME Writer"
 
 #. CtZCN
-#: cui/inc/treeopt.hrc:71
+#: cui/inc/treeopt.hrc:72
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "General"
 msgstr "General"
 
 #. t9DgE
-#: cui/inc/treeopt.hrc:72
+#: cui/inc/treeopt.hrc:73
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "View"
 msgstr "Visualitza"
 
 #. MxbiL
-#: cui/inc/treeopt.hrc:73
+#: cui/inc/treeopt.hrc:74
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Formatting Aids"
 msgstr "Ajudes a la formatació"
 
 #. V3usW
-#: cui/inc/treeopt.hrc:74
+#: cui/inc/treeopt.hrc:75
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Grid"
 msgstr "Graella"
 
 #. Cc2Ka
-#: cui/inc/treeopt.hrc:75
+#: cui/inc/treeopt.hrc:76
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Basic Fonts (Western)"
 msgstr "Tipus de lletra bàsics (occidental)"
 
 #. TDUti
-#: cui/inc/treeopt.hrc:76
+#: cui/inc/treeopt.hrc:77
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Basic Fonts (Asian)"
 msgstr "Tipus de lletra bàsics (asiàtic)"
 
 #. nfHR8
-#: cui/inc/treeopt.hrc:77
+#: cui/inc/treeopt.hrc:78
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Basic Fonts (CTL)"
 msgstr "Tipus de lletra bàsics (CTL)"
 
 #. 38A6E
-#: cui/inc/treeopt.hrc:78
+#: cui/inc/treeopt.hrc:79
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Print"
 msgstr "Imprimeix"
 
 #. UCGLq
-#: cui/inc/treeopt.hrc:79
+#: cui/inc/treeopt.hrc:80
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Table"
 msgstr "Taula"
 
 #. NVRAk
-#: cui/inc/treeopt.hrc:80
+#: cui/inc/treeopt.hrc:81
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Changes"
 msgstr "Canvis"
 
 #. 3DyC7
-#: cui/inc/treeopt.hrc:81
+#: cui/inc/treeopt.hrc:82
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Comparison"
 msgstr "Comparació"
 
 #. AtMGC
-#: cui/inc/treeopt.hrc:82
+#: cui/inc/treeopt.hrc:83
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Compatibility"
 msgstr "Compatibilitat"
 
 #. byMJP
-#: cui/inc/treeopt.hrc:83
+#: cui/inc/treeopt.hrc:84
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "AutoCaption"
 msgstr "Llegenda automàtica"
 
 #. aGnq6
-#: cui/inc/treeopt.hrc:84
+#: cui/inc/treeopt.hrc:85
 msgctxt "SID_SW_EDITOPTIONS_RES"
 msgid "Mail Merge Email"
 msgstr "Adreça electrònica de la combinació de correu"
 
 #. trEVm
-#: cui/inc/treeopt.hrc:89
+#: cui/inc/treeopt.hrc:90
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "%PRODUCTNAME Writer/Web"
 msgstr "%PRODUCTNAME Writer/Web"
 
 #. BZ7BG
-#: cui/inc/treeopt.hrc:90
+#: cui/inc/treeopt.hrc:91
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "View"
 msgstr "Visualitza"
 
 #. 3q8qM
-#: cui/inc/treeopt.hrc:91
+#: cui/inc/treeopt.hrc:92
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "Formatting Aids"
 msgstr "Ajudes a la formatació"
 
 #. 9fj7Y
-#: cui/inc/treeopt.hrc:92
+#: cui/inc/treeopt.hrc:93
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "Grid"
 msgstr "Graella"
 
 #. stfD4
-#: cui/inc/treeopt.hrc:93
+#: cui/inc/treeopt.hrc:94
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "Print"
 msgstr "Imprimeix"
 
 #. KpkDS
-#: cui/inc/treeopt.hrc:94
+#: cui/inc/treeopt.hrc:95
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "Table"
 msgstr "Taula"
 
 #. 9NS67
-#: cui/inc/treeopt.hrc:95
+#: cui/inc/treeopt.hrc:96
 msgctxt "SID_SW_ONLINEOPTIONS_RES"
 msgid "Background"
 msgstr "Fons"
 
 #. 9WCAp
-#: cui/inc/treeopt.hrc:100
+#: cui/inc/treeopt.hrc:101
 msgctxt "SID_SM_EDITOPTIONS_RES"
 msgid "%PRODUCTNAME Math"
 msgstr "%PRODUCTNAME Math"
 
 #. rFHDF
-#: cui/inc/treeopt.hrc:101
+#: cui/inc/treeopt.hrc:102
 msgctxt "SID_SM_EDITOPTIONS_RES"
 msgid "Settings"
 msgstr "Configuració"
 
 #. vk6jX
-#: cui/inc/treeopt.hrc:106
+#: cui/inc/treeopt.hrc:107
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "%PRODUCTNAME Calc"
 msgstr "%PRODUCTNAME Calc"
 
 #. xe2ry
-#: cui/inc/treeopt.hrc:107
+#: cui/inc/treeopt.hrc:108
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "General"
 msgstr "General"
 
 #. xE8RH
-#: cui/inc/treeopt.hrc:108
+#: cui/inc/treeopt.hrc:109
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Defaults"
 msgstr "Valors predeterminats"
 
 #. ufTM2
-#: cui/inc/treeopt.hrc:109
+#: cui/inc/treeopt.hrc:110
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "View"
 msgstr "Visualitza"
 
 #. QMCfy
-#: cui/inc/treeopt.hrc:110
+#: cui/inc/treeopt.hrc:111
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Calculate"
 msgstr "Calcula"
 
 #. oq8xG
-#: cui/inc/treeopt.hrc:111
+#: cui/inc/treeopt.hrc:112
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Formula"
 msgstr "Fórmula"
 
 #. HUUQP
-#: cui/inc/treeopt.hrc:112
+#: cui/inc/treeopt.hrc:113
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Sort Lists"
 msgstr "Llistes d'ordenació"
 
 #. bostB
-#: cui/inc/treeopt.hrc:113
+#: cui/inc/treeopt.hrc:114
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Changes"
 msgstr "Canvis"
 
 #. WVbFZ
-#: cui/inc/treeopt.hrc:114
+#: cui/inc/treeopt.hrc:115
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Compatibility"
 msgstr "Compatibilitat"
 
 #. UZGDj
-#: cui/inc/treeopt.hrc:115
+#: cui/inc/treeopt.hrc:116
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Grid"
 msgstr "Graella"
 
 #. wrdFF
-#: cui/inc/treeopt.hrc:116
+#: cui/inc/treeopt.hrc:117
 msgctxt "SID_SC_EDITOPTIONS_RES"
 msgid "Print"
 msgstr "Imprimeix"
 
 #. EeKzo
-#: cui/inc/treeopt.hrc:121
+#: cui/inc/treeopt.hrc:122
 msgctxt "SID_SD_EDITOPTIONS_RES"
 msgid "%PRODUCTNAME Impress"
 msgstr "%PRODUCTNAME Impress"
 
 #. GxFDj
-#: cui/inc/treeopt.hrc:122
+#: cui/inc/treeopt.hrc:123
 msgctxt "SID_SD_EDITOPTIONS_RES"
 msgid "General"
 msgstr "General"
 
 #. unCEW
-#: cui/inc/treeopt.hrc:123
+#: cui/inc/treeopt.hrc:124
 msgctxt "SID_SD_EDITOPTIONS_RES"
 msgid "View"
 msgstr "Visualitza"
 
 #. UxXLE
-#: cui/inc/treeopt.hrc:124
+#: cui/inc/treeopt.hrc:125
 msgctxt "SID_SD_EDITOPTIONS_RES"
 msgid "Grid"
 msgstr "Graella"
 
 #. DLCS4
-#: cui/inc/treeopt.hrc:125
+#: cui/inc/treeopt.hrc:126
 msgctxt "SID_SD_EDITOPTIONS_RES"
 msgid "Print"
 msgstr "Imprimeix"
 
 #. wZWAL
-#: cui/inc/treeopt.hrc:130
+#: cui/inc/treeopt.hrc:131
 msgctxt "SID_SD_GRAPHIC_OPTIONS_RES"
 msgid "%PRODUCTNAME Draw"
 msgstr "%PRODUCTNAME Draw"
 
 #. B9gGf
-#: cui/inc/treeopt.hrc:131
+#: cui/inc/treeopt.hrc:132
 msgctxt "SID_SD_GRAPHIC_OPTIONS_RES"
 msgid "General"
 msgstr "General"
 
 #. oiiBb
-#: cui/inc/treeopt.hrc:132
+#: cui/inc/treeopt.hrc:133
 msgctxt "SID_SD_GRAPHIC_OPTIONS_RES"
 msgid "View"
 msgstr "Visualitza"
 
 #. et8PK
-#: cui/inc/treeopt.hrc:133
+#: cui/inc/treeopt.hrc:134
 msgctxt "SID_SD_GRAPHIC_OPTIONS_RES"
 msgid "Grid"
 msgstr "Graella"
 
 #. oGTEW
-#: cui/inc/treeopt.hrc:134
+#: cui/inc/treeopt.hrc:135
 msgctxt "SID_SD_GRAPHIC_OPTIONS_RES"
 msgid "Print"
 msgstr "Imprimeix"
 
 #. BECZi
-#: cui/inc/treeopt.hrc:139
+#: cui/inc/treeopt.hrc:140
 msgctxt "SID_SCH_EDITOPTIONS_RES"
 msgid "Charts"
 msgstr "Diagrames"
 
 #. XAhzo
-#: cui/inc/treeopt.hrc:140
+#: cui/inc/treeopt.hrc:141
 msgctxt "SID_SCH_EDITOPTIONS_RES"
 msgid "Default Colors"
 msgstr "Colors predeterminats"
 
 #. oUBac
-#: cui/inc/treeopt.hrc:145
+#: cui/inc/treeopt.hrc:146
 msgctxt "SID_FILTER_DLG_RES"
 msgid "Load/Save"
 msgstr "Carrega o guarda"
 
 #. 3go3N
-#: cui/inc/treeopt.hrc:146
+#: cui/inc/treeopt.hrc:147
 msgctxt "SID_FILTER_DLG_RES"
 msgid "General"
 msgstr "General"
 
 #. 9aX4K
-#: cui/inc/treeopt.hrc:147
+#: cui/inc/treeopt.hrc:148
 msgctxt "SID_FILTER_DLG_RES"
 msgid "VBA Properties"
 msgstr "Propietats de VBA"
 
 #. oAGDd
-#: cui/inc/treeopt.hrc:148
+#: cui/inc/treeopt.hrc:149
 msgctxt "SID_FILTER_DLG_RES"
 msgid "Microsoft Office"
 msgstr "Microsoft Office"
 
 #. UtTyJ
-#: cui/inc/treeopt.hrc:149
+#: cui/inc/treeopt.hrc:150
 msgctxt "SID_FILTER_DLG_RES"
 msgid "HTML Compatibility"
 msgstr "Compatibilitat HTML"
 
 #. Qysp7
-#: cui/inc/treeopt.hrc:154
+#: cui/inc/treeopt.hrc:155
 msgctxt "SID_SB_STARBASEOPTIONS_RES"
 msgid "%PRODUCTNAME Base"
 msgstr "%PRODUCTNAME Base"
 
 #. 78XBF
-#: cui/inc/treeopt.hrc:155
+#: cui/inc/treeopt.hrc:156
 msgctxt "SID_SB_STARBASEOPTIONS_RES"
 msgid "Connections"
 msgstr "Connexions"
 
 #. 54yat
-#: cui/inc/treeopt.hrc:156
+#: cui/inc/treeopt.hrc:157
 msgctxt "SID_SB_STARBASEOPTIONS_RES"
 msgid "Databases"
 msgstr "Bases de dades"
@@ -11894,6 +11900,72 @@ msgctxt "extended_tip|removebtn"
 msgid "Deletes the selected JRE start parameter."
 msgstr "Suprimeix el paràmetre d'inici del JRE seleccionat."
 
+#. ucDEJ
+#: cui/uiconfig/ui/langtoolconfigpage.ui:29
+msgctxt "langtoolconfigpage|disclaimer"
+msgid "If you enable this, the data will be sent to an external server."
+msgstr ""
+
+#. kF4mt
+#: cui/uiconfig/ui/langtoolconfigpage.ui:39
+msgctxt "langtoolconfigpage|policy"
+msgid "Please read the privacy policy"
+msgstr ""
+
+#. ZRJcn
+#: cui/uiconfig/ui/langtoolconfigpage.ui:55
+msgctxt "langtoolconfigpage|activate"
+msgid "Enable LanguageTool"
+msgstr ""
+
+#. tUmXv
+#: cui/uiconfig/ui/langtoolconfigpage.ui:86
+msgctxt "langtoolconfigpage|base"
+msgid "Base URL:"
+msgstr ""
+
+#. 9to2D
+#: cui/uiconfig/ui/langtoolconfigpage.ui:111
+msgctxt "langtoolconfigpage|usernamelbl"
+msgid "User name:"
+msgstr ""
+
+#. B8kMr
+#: cui/uiconfig/ui/langtoolconfigpage.ui:125
+msgctxt "langtoolconfigpage|apikeylbl"
+msgid "API key:"
+msgstr ""
+
+#. AoT7Z
+#: cui/uiconfig/ui/langtoolconfigpage.ui:159
+msgctxt "langtoolconfigpage|urldesc"
+msgid "Please use the base URL e.g. without \"/check\" at the end."
+msgstr ""
+
+#. EDETM
+#: cui/uiconfig/ui/langtoolconfigpage.ui:171
+msgctxt "langtoolconfigpage|usernamedesc"
+msgid "Your LanguageTool account's username for premium usage."
+msgstr ""
+
+#. aDGJf
+#: cui/uiconfig/ui/langtoolconfigpage.ui:183
+msgctxt "langtoolconfigpage|apikeydesc"
+msgid "Your LanguageTool account's api key for premium usage."
+msgstr ""
+
+#. Dn8bb
+#: cui/uiconfig/ui/langtoolconfigpage.ui:206
+msgctxt "langtoolconfigpage|apisettingsheader"
+msgid "API Settings"
+msgstr ""
+
+#. Ntss5
+#: cui/uiconfig/ui/langtoolconfigpage.ui:225
+msgctxt "langtoolconfigpage|langtoolsettings"
+msgid "LanguageTool API Options"
+msgstr ""
+
 #. RdoKs
 #: cui/uiconfig/ui/linedialog.ui:8
 msgctxt "linedialog|LineDialog"
diff --git a/source/ca-valencia/helpcontent2/source/text/sbasic/shared/03.po b/source/ca-valencia/helpcontent2/source/text/sbasic/shared/03.po
index c6c0e70fc16..4cc7d9e33d3 100644
--- a/source/ca-valencia/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/ca-valencia/helpcontent2/source/text/sbasic/shared/03.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: 2022-05-25 12:36+0200\n"
+"POT-Creation-Date: 2022-06-10 13:58+0200\n"
 "PO-Revision-Date: 2021-01-12 10:36+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/ca_VALENCIA/>\n"
@@ -5776,6 +5776,294 @@ msgctxt ""
 msgid "Refer to the help page about ScriptForge's <link href=\"text/sbasic/shared/03/sf_chart.xhp\" name=\"Chart service\">Chart service</link> to learn more how to further manipulate chart objects. It is possible to change properties as the chart type, chart and axes titles and chart position."
 msgstr ""
 
+#. DFCVe
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id1615929033065\n"
+"help.text"
+msgid "Creates a new pivot table with the properties defined by the arguments  passed to the method."
+msgstr ""
+
+#. gouER
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id1001652794922144\n"
+"help.text"
+msgid "A name must be provided for the pivot table. If a pivot table with the same name already exists in the targeted sheet, it will be replaced without warning."
+msgstr ""
+
+#. SnCCg
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id751652795324382\n"
+"help.text"
+msgid "This method returns a string containing the range where the new pivot table was placed."
+msgstr ""
+
+#. AKjmT
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id841592903128525\n"
+"help.text"
+msgid "<emph>pivottablename:</emph> The user-defined name of the new pivot table."
+msgstr ""
+
+#. vvGTx
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515929031203640\n"
+"help.text"
+msgid "<emph>sourcerange:</emph> The range containing the raw data, as a string. It is assumed that the first row contains the field names that are used by the pivot table."
+msgstr ""
+
+#. twWbD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515929031210400\n"
+"help.text"
+msgid "<emph>targetcell:</emph> The top-left cell where the new pivot table will be placed. If a range is specified, only its top-left cell is considered."
+msgstr ""
+
+#. YXG64
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515929031951290\n"
+"help.text"
+msgid "<emph>datafields:</emph> It can be either a single string or an array containing strings that define field names and functions to be applied. When an array is specified, it must follow the syntax <input>Array(\"FieldName[;Function]\", ...)</input>."
+msgstr ""
+
+#. cKZ3U
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id361652795942348\n"
+"help.text"
+msgid "The allowed functions are: <literal>Sum</literal>, <literal>Count</literal>, <literal>Average</literal>, <literal>Max</literal>, <literal>Min</literal>, <literal>Product</literal>, <literal>CountNums</literal>, <literal>StDev</literal>, <literal>StDevP</literal>, <literal>Var</literal>, <literal>VarP</literal> and <literal>Median</literal>. Function names must be provided in English. When all values are numerical, <literal>Sum</literal> is the default function, otherwise the default function is <literal>Count</literal>."
+msgstr ""
+
+#. JKCoA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515929031211003\n"
+"help.text"
+msgid "<emph>rowfields:</emph> A single string or an array with the field names that will be used as the pivot table rows."
+msgstr ""
+
+#. 8GW5G
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515929031211114\n"
+"help.text"
+msgid "<emph>columnfields:</emph> A single string or an array with the field names that will be used as the pivot table columns."
+msgstr ""
+
+#. iTL7C
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id361652796141240\n"
+"help.text"
+msgid "<emph>filterbutton:</emph> Determines whether a filter button will be displayed above the pivot table (Default = <literal>True</literal>)."
+msgstr ""
+
+#. FXyRo
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id661652796200051\n"
+"help.text"
+msgid "<emph>rowtotals:</emph> Specifies if a separate column for row totals will be added to the pivot table (Default = <literal>True</literal>)."
+msgstr ""
+
+#. xf8Nt
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id671652796274304\n"
+"help.text"
+msgid "<emph>columntotals</emph> Specifies if a separate row for column totals will be added to the pivot table (Default = <literal>True</literal>)"
+msgstr ""
+
+#. EWpPF
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id201652797038370\n"
+"help.text"
+msgid "vData = Array(Array(\"Item\", \"State\", \"Team\", \"2002\", \"2003\", \"2004\"), _"
+msgstr ""
+
+#. mKCAv
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id171652797038762\n"
+"help.text"
+msgid "Array(\"Books\", \"Michigan\", \"Jean\", 14788, 30222, 23490), _"
+msgstr ""
+
+#. hCGGn
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id331652797039146\n"
+"help.text"
+msgid "Array(\"Candy\", \"Michigan\", \"Jean\", 26388, 15641, 32849), _"
+msgstr ""
+
+#. 9ByFz
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id911652797039570\n"
+"help.text"
+msgid "Array(\"Pens\", \"Michigan\", \"Jean\", 16569, 32675, 25396), _"
+msgstr ""
+
+#. eSDMP
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id471652797039963\n"
+"help.text"
+msgid "Array(\"Books\", \"Michigan\", \"Volker\", 21961, 21242, 29009), _"
+msgstr ""
+
+#. sJ46a
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id681652797040338\n"
+"help.text"
+msgid "Array(\"Candy\", \"Michigan\", \"Volker\", 26142, 22407, 32841))"
+msgstr ""
+
+#. J482H
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id851652797041450\n"
+"help.text"
+msgid "Array(\"2002\", \"2003;count\", \"2004;average\"), _ ' Three data fields"
+msgstr ""
+
+#. aVZWM
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id791652797306993\n"
+"help.text"
+msgid "\"Item\", _ ' A single row field"
+msgstr ""
+
+#. C77HK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id731652797041866\n"
+"help.text"
+msgid "Array(\"State\", \"Team\"), False) ' Two column fields"
+msgstr ""
+
+#. 4c6uZ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id971652797474132\n"
+"help.text"
+msgid "vData = [[\"Item\", \"State\", \"Team\", \"2002\", \"2003\", \"2004\"],"
+msgstr ""
+
+#. 7ZNex
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id921652797555153\n"
+"help.text"
+msgid "[\"Books\", \"Michigan\", \"Jean\", 14788, 30222, 23490],"
+msgstr ""
+
+#. Ab4Va
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id891652797555537\n"
+"help.text"
+msgid "[\"Candy\", \"Michigan\", \"Jean\", 26388, 15641, 32849],"
+msgstr ""
+
+#. jCYsL
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id321652797555864\n"
+"help.text"
+msgid "[\"Pens\", \"Michigan\", \"Jean\", 16569, 32675, 25396)],"
+msgstr ""
+
+#. LFzAq
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id121652797556264\n"
+"help.text"
+msgid "[\"Books\", \"Michigan\", \"Volker\", 21961, 21242, 29009],"
+msgstr ""
+
+#. GRrTW
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id881652797556680\n"
+"help.text"
+msgid "[\"Candy\", \"Michigan\", \"Volker\", 26142, 22407, 32841]]"
+msgstr ""
+
+#. sbEVQ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id941652797992017\n"
+"help.text"
+msgid "[\"2002\", \"2003;count\", \"2004;average\"],"
+msgstr ""
+
+#. 3JAyy
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id471652797992561\n"
+"help.text"
+msgid "\"Item\","
+msgstr ""
+
+#. oL69n
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id561652797992185\n"
+"help.text"
+msgid "[\"State\", \"Team\"], False)"
+msgstr ""
+
+#. XsF9b
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id231635441342284\n"
+"help.text"
+msgid "To learn more about Pivot Tables in %PRODUCTNAME Calc, read the <link href=\"text/scalc/guide/datapilot.xhp\" name=\"Pivot table\">Pivot Table</link> help page."
+msgstr ""
+
 #. so8uw
 #: sf_calc.xhp
 msgctxt ""
@@ -9241,13 +9529,13 @@ msgctxt ""
 msgid "Event properties"
 msgstr ""
 
-#. EbGWN
+#. tn52Y
 #: sf_dialog.xhp
 msgctxt ""
 "sf_dialog.xhp\n"
 "par_id41612629140856\n"
 "help.text"
-msgid "Returns a URI string with the reference to the script triggered by the event. Read its specification in the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">scripting framework URI specification</link>."
+msgid "Returns a URI string with the reference to the script triggered by the event. Read its specification in the <link href=\"https://wiki.documentfoundation.org/Documentation/DevGuide/Scripting_Framework#Scripting_Framework_URI_Specification\" name=\"URI specification\">scripting framework URI specification</link>."
 msgstr ""
 
 #. XCC7C
@@ -10942,13 +11230,13 @@ msgctxt ""
 msgid "Event properties"
 msgstr ""
 
-#. c7srp
+#. Vo6Ch
 #: sf_dialogcontrol.xhp
 msgctxt ""
 "sf_dialogcontrol.xhp\n"
 "par_id41612629140856\n"
 "help.text"
-msgid "Returns a URI string with the reference to the script triggered by the event. Read its specification in the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">scripting framework URI specification</link>."
+msgid "Returns a URI string with the reference to the script triggered by the event. Read its specification in the <link href=\"https://wiki.documentfoundation.org/Documentation/DevGuide/Scripting_Framework#Scripting_Framework_URI_Specification\" name=\"URI specification\">scripting framework URI specification</link>."
 msgstr ""
 
 #. fkFAt
@@ -16747,13 +17035,13 @@ msgctxt ""
 msgid "Before unloading"
 msgstr ""
 
-#. cTdFS
+#. EoCKE
 #: sf_form.xhp
 msgctxt ""
 "sf_form.xhp\n"
 "par_id961618181634322\n"
 "help.text"
-msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
+msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/DevGuide/Scripting_Framework#Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
 msgstr ""
 
 #. bkBH8
@@ -18484,13 +18772,13 @@ msgctxt ""
 msgid "After updating"
 msgstr ""
 
-#. tcpN5
+#. CrwBN
 #: sf_formcontrol.xhp
 msgctxt ""
 "sf_formcontrol.xhp\n"
 "par_id961618181634181\n"
 "help.text"
-msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
+msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/DevGuide/Scripting_Framework#Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
 msgstr ""
 
 #. RpNkd
@@ -20428,13 +20716,13 @@ msgctxt ""
 msgid "The arguments <literal>command</literal> and <literal>script</literal> are mutually exclusive, hence only one of them can be set for each menu item."
 msgstr ""
 
-#. 7fb2n
+#. 57vEy
 #: sf_menu.xhp
 msgctxt ""
 "sf_menu.xhp\n"
 "par_id31643148484084\n"
 "help.text"
-msgid "Read <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI_Notation\">Scripting Framework URI Specification</link> to learn more about the URI syntax used in the <literal>script</literal> argument."
+msgid "Read <link href=\"https://wiki.documentfoundation.org/Documentation/DevGuide/Scripting_Framework#Scripting_Framework_URI_Specification\" name=\"URI_Notation\">Scripting Framework URI Specification</link> to learn more about the URI syntax used in the <literal>script</literal> argument."
 msgstr ""
 
 #. Aj8cF
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/guide.po b/source/ca-valencia/helpcontent2/source/text/shared/guide.po
index 958ef70c1dc..217c09a0e61 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: 2022-06-09 11:50+0200\n"
+"POT-Creation-Date: 2022-06-10 13:58+0200\n"
 "PO-Revision-Date: 2021-01-12 10:36+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textsharedguide/ca_VALENCIA/>\n"
@@ -17252,14 +17252,14 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/05030500.xhp\" name=\"Format - Paragraph - Borders\">Format - Paragraph - Borders</link>"
 msgstr "<link href=\"text/shared/01/05030500.xhp\" name=\"Format - Paràgraf - Vores\">Format - Paràgraf - Vores</link>"
 
-#. ZfDET
+#. 7ntRp
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "tit\n"
 "help.text"
-msgid "Defining Line Ends"
-msgstr "Definició de finals de línia"
+msgid "Defining Arrow Styles"
+msgstr ""
 
 #. VSqSX
 #: lineend_define.xhp
@@ -17270,50 +17270,50 @@ msgctxt ""
 msgid "<bookmark_value>defining; arrowheads and other line ends</bookmark_value><bookmark_value>arrows; defining arrow heads</bookmark_value><bookmark_value>lines;defining ends</bookmark_value>"
 msgstr "<bookmark_value>definició; extrems de fletxa i altres finals de línia</bookmark_value><bookmark_value>fletxes; definició d'extrems de fletxa</bookmark_value><bookmark_value>línies;definició de finals</bookmark_value>"
 
-#. QCVYS
+#. 6SzNd
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "hd_id3146117\n"
 "help.text"
-msgid "<variable id=\"lineend_define\"><link href=\"text/shared/guide/lineend_define.xhp\" name=\"Defining Line Ends\">Defining Line Ends</link></variable>"
-msgstr "<variable id=\"lineend_define\"><link href=\"text/shared/guide/lineend_define.xhp\" name=\"Definició de finals de línia\">Definició de finals de línia</link></variable>"
+msgid "<variable id=\"lineend_define\"><link href=\"text/shared/guide/lineend_define.xhp\" name=\"Defining Line Ends\">Defining Arrow Styles</link></variable>"
+msgstr ""
 
-#. KfC2G
+#. 7DhAE
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "par_id3153750\n"
 "help.text"
-msgid "You can define any object to be included in the list of available line ends."
-msgstr "Podeu definir objectes per incloure'ls a la llista de finals de línia disponibles."
+msgid "You can define any shape to be included in the list of available arrow styles. Only the form of the shape is added as a black filled arrowhead."
+msgstr ""
 
-#. G8SUJ
+#. iWrXg
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "par_id3147653\n"
 "help.text"
-msgid "Use the draw functions to create an object to be used as a line end."
-msgstr "Utilitzeu les funcions de dibuix per crear un objecte i utilitzar-lo com a final de línia."
+msgid "Use the draw functions to create the shape to be used as an arrow style."
+msgstr ""
 
-#. ajS33
+#. NtyRL
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "par_id3149795\n"
 "help.text"
-msgid "Select the object and choose <emph>Format - </emph><switchinline select=\"appl\"><caseinline select=\"WRITER\"><emph>Drawing Object - </emph></caseinline><caseinline select=\"CALC\"><emph>Graphic - </emph></caseinline></switchinline><emph>Line</emph>."
-msgstr "Seleccioneu l'objecte i trieu <emph>Format - </emph><switchinline select=\"appl\"><caseinline select=\"WRITER\"><emph>Objecte de dibuix - </emph></caseinline><caseinline select=\"CALC\"><emph>Gràfic - </emph></caseinline></switchinline><emph>Línia</emph>."
+msgid "Select the shape and choose <menuitem>Format - </menuitem><switchinline select=\"appl\"><caseinline select=\"DRAW\"/>  <defaultinline><menuitem>Text Box and Shape - </menuitem></defaultinline></switchinline><menuitem>Line</menuitem>."
+msgstr ""
 
-#. LwGkW
+#. unyMH
 #: lineend_define.xhp
 msgctxt ""
 "lineend_define.xhp\n"
 "par_id3154306\n"
 "help.text"
-msgid "In the dialog, click the <emph>Arrow Styles</emph>."
-msgstr "Al diàleg, feu clic a <emph>Estils de fletxa</emph>."
+msgid "In the dialog, click the <menuitem>Arrow Styles</menuitem> tab."
+msgstr ""
 
 #. abFgC
 #: lineend_define.xhp
diff --git a/source/ca-valencia/svtools/messages.po b/source/ca-valencia/svtools/messages.po
index e441e1d8126..951e370cfa1 100644
--- a/source/ca-valencia/svtools/messages.po
+++ b/source/ca-valencia/svtools/messages.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: 2022-06-09 11:50+0200\n"
+"POT-Creation-Date: 2022-06-10 13:58+0200\n"
 "PO-Revision-Date: 2021-01-12 09:36+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_ui-master/svtoolsmessages/ca_VALENCIA/>\n"
@@ -1741,6 +1741,12 @@ msgctxt "STR_DESCRIPTION_IGNOREALLLIST"
 msgid "List of Ignored Words"
 msgstr "Llista de paraules ignorades"
 
+#. eAiiA
+#: include/svtools/strings.hrc:345
+msgctxt "STR_DESCRIPTION_LANGUAGETOOL"
+msgid "LanguageTool Remote Grammar Checker"
+msgstr ""
+
 #. wH3TZ
 msgctxt "stock"
 msgid "_Add"