update translations for master

and force-fix errors using pocheck

Change-Id: I65d403dd9ce3233ba067c1e76faa0b9f782fe816

8 files changed, 903 insertions, 264 deletions

diff --git a/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po b/source/ca-valencia/helpcontent2/source/text/sbasic/shared.po
index e8d1154cc98..54372fca8ae 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: 2024-03-15 13:14+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2024-01-15 09:45+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/ca_VALENCIA/>\n"
@@ -40751,6 +40751,132 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03090411.xhp\">With</link> statement"
 msgstr "<link href=\"text/sbasic/shared/03090411.xhp\">amb declaració</link>"
 
+#. sPkoY
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"tit\n"
+"help.text"
+msgid "ExportAsFixedFormat"
+msgstr ""
+
+#. 8TUuD
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"bm_id371711286795900\n"
+"help.text"
+msgid "<bookmark_value>ExportAsFixedFormat method [VBA]</bookmark_value>"
+msgstr ""
+
+#. D8GuJ
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"hd_id981711281680887\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/sbasic/shared/exportasfixedformat.xhp\">ExportAsFixedFormat Method [VBA]</link></variable>"
+msgstr ""
+
+#. vMsGC
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id561711281680890\n"
+"help.text"
+msgid "Method to export a Calc document to PDF format."
+msgstr ""
+
+#. m86GB
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id961711284173030\n"
+"help.text"
+msgid "expression.ExportAsFixedFormat (Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish)"
+msgstr ""
+
+#. i42Qe
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id731711284383305\n"
+"help.text"
+msgid "<emph>Type</emph>: Integer, required. Can be either 0 or 1. <emph>0</emph> for \"PDF\" - Portable Document Format file (.pdf) and <emph>1</emph> for  \"XPS\" - XPS Document (.xps)"
+msgstr ""
+
+#. N7LcB
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id471711285929795\n"
+"help.text"
+msgid "XPS export format is not supported by %PRODUCTNAME."
+msgstr ""
+
+#. 6rtDv
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id611711284387498\n"
+"help.text"
+msgid "<emph>Filename</emph>: String, optional. The file name of the exported file."
+msgstr ""
+
+#. wCTzD
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id251711284391770\n"
+"help.text"
+msgid "<emph>Quality</emph>: Integer, optional. Can be 0 or 1. <emph>0</emph> is for standard quality, <emph>1</emph> is for minimum quality."
+msgstr ""
+
+#. p5iRF
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id161711284395682\n"
+"help.text"
+msgid "<emph>IncludeDocProperties</emph>: Boolean, optional. Set to <literal>True</literal> to indicate that document properties should be included in the exported file, or set to <literal>False</literal> to suppress the export of document properties."
+msgstr ""
+
+#. qvDx4
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id461711284399442\n"
+"help.text"
+msgid "<emph>IgnorePrintAreas</emph>: Boolean, optional. If set to <literal>True</literal>, ignores any print ranges on export. If set to <literal>False</literal>, honor the print ranges on export."
+msgstr ""
+
+#. R6Bd7
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id341711284404400\n"
+"help.text"
+msgid "<emph>From</emph>:Integer, optional. Page number of the first page to export. If omitted, export starts at the beginning."
+msgstr ""
+
+#. HwkUM
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id21711284409841\n"
+"help.text"
+msgid "<emph>To</emph>: Integer, optional. Page number of the last page to export. If omitted, export ends with the last page."
+msgstr ""
+
+#. hMPN7
+#: exportasfixedformat.xhp
+msgctxt ""
+"exportasfixedformat.xhp\n"
+"par_id461711284415267\n"
+"help.text"
+msgid "<emph>OpenAfterPublish</emph>:Boolean, optional. If set to <literal>True</literal>, displays the file in the proper viewer after export. On <literal>False</literal>, the file is exported but not displayed."
+msgstr ""
+
 #. FFWQn
 #: fragments.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/scalc.po b/source/ca-valencia/helpcontent2/source/text/scalc.po
index 2e797858f3a..28909d78f37 100644
--- a/source/ca-valencia/helpcontent2/source/text/scalc.po
+++ b/source/ca-valencia/helpcontent2/source/text/scalc.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: 2024-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:25+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textscalc/ca_VALENCIA/>\n"
@@ -377,14 +377,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_SC_TOOLBOX_TABLE\">The <emph>Formatting</emph> bar contains basic commands for applying manually formatting.</ahelp>"
 msgstr "<ahelp hid=\"HID_SC_TOOLBOX_TABLE\">La barra de <emph>formatació</emph> conté ordes bàsiques per aplicar una formatació manual.</ahelp>"
 
-#. 7GEuZ
+#. g2ub5
 #: main0202.xhp
 msgctxt ""
 "main0202.xhp\n"
 "hd_id3153160\n"
 "help.text"
-msgid "<link href=\"text/shared/01/05020200.xhp\">Font Color</link>"
-msgstr "<link href=\"text/shared/01/05020200.xhp\">Color del tipus de lletra</link>"
+msgid "<link href=\"text/shared/01/05020200.xhp#FontColor\">Font Color</link>"
+msgstr ""
 
 #. H2aV6
 #: main0202.xhp
diff --git a/source/ca-valencia/helpcontent2/source/text/scalc/01.po b/source/ca-valencia/helpcontent2/source/text/scalc/01.po
index 0874356b1f1..03edf82fcec 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: 2024-03-04 14:25+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:24+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/ca_VALENCIA/>\n"
@@ -14003,96 +14003,6 @@ msgctxt ""
 msgid "<item type=\"input\">=SINH(0)</item> returns 0, the hyperbolic sine of 0."
 msgstr "<item type=\"input\">=SINH(0)</item> retorna 0, el sinus hiperbòlic de 0."
 
-#. LAWCJ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3151957\n"
-"help.text"
-msgid "<bookmark_value>SUMIF function</bookmark_value>  <bookmark_value>adding;specified numbers</bookmark_value>"
-msgstr "<bookmark_value>funció SUMASI</bookmark_value><bookmark_value>suma;nombres indicats</bookmark_value>"
-
-#. CGGGj
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3151957\n"
-"help.text"
-msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>"
-msgstr "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMASI</link></variable>"
-
-#. p2fHt
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3151986\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value."
-msgstr ""
-
-#. GKQGQ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152028\n"
-"help.text"
-msgid "SUMIF(Range; Criterion [; SumRange])"
-msgstr ""
-
-#. wmLcE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152043\n"
-"help.text"
-msgid "<emph>Range</emph> is the range to which the criterion is to be applied."
-msgstr ""
-
-#. FCxrw
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152083\n"
-"help.text"
-msgid "<emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed."
-msgstr "<emph>IntervalDeSuma</emph> és l'interval a partir del qual se sumen els valors. Si no s'ha indicat el paràmetre, se sumen els valors de l'Interval."
-
-#. iGKyo
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8347422\n"
-"help.text"
-msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given."
-msgstr ""
-
-#. uazzL
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152148\n"
-"help.text"
-msgid "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>"
-msgstr "Per sumar només els nombres negatius: <item type=\"input\">=SUMASI(A1:A10;\"<0\")</item>."
-
-#. GGT9C
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id6670125\n"
-"help.text"
-msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0."
-msgstr ""
-
-#. G5vdm
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id6062196\n"
-"help.text"
-msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()."
-msgstr "Vegeu COMPTASI() per veure altres exemples de sintaxi que podeu utilitzar amb la funció SUMASI()."
-
 #. BHGzQ
 #: 04060106.xhp
 msgctxt ""
@@ -56213,24 +56123,6 @@ msgctxt ""
 msgid "Product Name"
 msgstr "Nom del producte"
 
-#. HZpK7
-#: ex_data_stat_func.xhp
-msgctxt ""
-"ex_data_stat_func.xhp\n"
-"par_id2509201517433075\n"
-"help.text"
-msgid "Sales"
-msgstr "Vendes"
-
-#. NEEL8
-#: ex_data_stat_func.xhp
-msgctxt ""
-"ex_data_stat_func.xhp\n"
-"par_id2509201519383294\n"
-"help.text"
-msgid "Revenue"
-msgstr "Ingressos"
-
 #. ZyGBE
 #: ex_data_stat_func.xhp
 msgctxt ""
@@ -56267,32 +56159,32 @@ msgctxt ""
 msgid "book"
 msgstr "llibre"
 
-#. 48CjE
+#. NTJ7A
 #: ex_data_stat_func.xhp
 msgctxt ""
 "ex_data_stat_func.xhp\n"
-"par_id19479417931163\n"
+"par_id491711556981497\n"
 "help.text"
 msgid "pencil-case"
-msgstr "estoig"
+msgstr ""
 
-#. w8ZSP
+#. jwABa
 #: ex_data_stat_func.xhp
 msgctxt ""
 "ex_data_stat_func.xhp\n"
-"par_id85353130721737\n"
+"par_id981711556984697\n"
 "help.text"
 msgid "not"
-msgstr "no"
+msgstr ""
 
-#. EYktc
+#. cAKeZ
 #: ex_data_stat_func.xhp
 msgctxt ""
 "ex_data_stat_func.xhp\n"
-"par_id15693941827291\n"
+"par_id581711556987385\n"
 "help.text"
 msgid "not"
-msgstr "no"
+msgstr ""
 
 #. jpYmN
 #: ex_data_stat_func.xhp
@@ -68093,22 +67985,211 @@ msgctxt ""
 msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>"
 msgstr ""
 
-#. 4Ky6H
+#. JkEQn
 #: func_sort.xhp
 msgctxt ""
 "func_sort.xhp\n"
 "par_id771708806478128\n"
 "help.text"
-msgid "(...)"
+msgid "Sorts the contents of a range or array."
 msgstr ""
 
-#. NFc8B
+#. JFZRF
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id131711543270539\n"
+"help.text"
+msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>."
+msgstr ""
+
+#. LksfE
 #: func_sort.xhp
 msgctxt ""
 "func_sort.xhp\n"
 "par_id211708281649651\n"
 "help.text"
-msgid "SORT(...)"
+msgid "SORT(Range [, SortIndex[, SortOrder[, ByCol]]])"
+msgstr ""
+
+#. 4iAJz
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id551711457515235\n"
+"help.text"
+msgid "<emph>Range:</emph> Required. The range or array to sort."
+msgstr ""
+
+#. Epf9D
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id151711457520290\n"
+"help.text"
+msgid "<emph>SortIndex:</emph> Optional. The number indicating the row or column to sort by."
+msgstr ""
+
+#. 2cgDj
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id131711457525811\n"
+"help.text"
+msgid "<emph>SortOrder:</emph> Optional. A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order."
+msgstr ""
+
+#. JwCYE
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id351711457531579\n"
+"help.text"
+msgid "<emph>ByCol:</emph> Optional. A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column."
+msgstr ""
+
+#. hDBib
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"hd_id751711480783220\n"
+"help.text"
+msgid "Example with ascending order"
+msgstr ""
+
+#. RmqyT
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id131711466000482\n"
+"help.text"
+msgid "<input>{=SORT(A2:C6,2,1)}</input>"
+msgstr ""
+
+#. MBgRu
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id471711472262161\n"
+"help.text"
+msgid "Sort the range A2:C6 based on the second column in ascending order (Sales)."
+msgstr ""
+
+#. EQiyc
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id31711465709083\n"
+"help.text"
+msgid "book"
+msgstr ""
+
+#. AA3th
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id861711465758906\n"
+"help.text"
+msgid "pencil"
+msgstr ""
+
+#. zjCpK
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id331711465788257\n"
+"help.text"
+msgid "notebook"
+msgstr ""
+
+#. GDXFf
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id821711465827777\n"
+"help.text"
+msgid "pen"
+msgstr ""
+
+#. ofndu
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id11711465871342\n"
+"help.text"
+msgid "pencil-case"
+msgstr ""
+
+#. pvfNi
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"hd_id51711480751179\n"
+"help.text"
+msgid "Example with descending order"
+msgstr ""
+
+#. x5oDE
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id731711466320553\n"
+"help.text"
+msgid "<input>{=SORT(A2:C6,3,-1)}</input>"
+msgstr ""
+
+#. FSrYH
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id401711479167509\n"
+"help.text"
+msgid "Sort the range A2:C6 based on the third column in descending order (Revenue)."
+msgstr ""
+
+#. 5KSd6
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id821711478931934\n"
+"help.text"
+msgid "pencil-case"
+msgstr ""
+
+#. hHqSc
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id721711478941598\n"
+"help.text"
+msgid "notebook"
+msgstr ""
+
+#. Eh74E
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id281711478950341\n"
+"help.text"
+msgid "book"
+msgstr ""
+
+#. KGKEY
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id101711478960309\n"
+"help.text"
+msgid "pen"
+msgstr ""
+
+#. fjhFK
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id911711478969701\n"
+"help.text"
+msgid "pencil"
 msgstr ""
 
 #. JDbrP
@@ -68147,22 +68228,112 @@ msgctxt ""
 msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>"
 msgstr ""
 
-#. EFPmE
+#. jCSNU
 #: func_sortby.xhp
 msgctxt ""
 "func_sortby.xhp\n"
 "par_id771708806478128\n"
 "help.text"
-msgid "(...)"
+msgid "Sorts the contents of a range or array based on the values in a corresponding range or array."
 msgstr ""
 
-#. 6QrpC
+#. EUgaa
 #: func_sortby.xhp
 msgctxt ""
 "func_sortby.xhp\n"
 "par_id211708281649651\n"
 "help.text"
-msgid "SORTBY(...)"
+msgid "SORTBY(Range, SortByRange1, SortOrder1[, SortByRange2, SortOrder2,[...]])"
+msgstr ""
+
+#. gifyS
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id451711544450734\n"
+"help.text"
+msgid "<emph>Range</emph>: The array or range to sort."
+msgstr ""
+
+#. k3ADs
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id291711544460323\n"
+"help.text"
+msgid "<emph>SortByRange1, SortByRange2,... </emph>: Range 1, range 2,... are the arrays or ranges to sort on."
+msgstr ""
+
+#. FTuBa
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id501711544465886\n"
+"help.text"
+msgid "<emph>SortOrder1, SortOrder2,...</emph> : Order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending."
+msgstr ""
+
+#. EoHgm
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"hd_id2609201512474295\n"
+"help.text"
+msgid "Consider the following table"
+msgstr ""
+
+#. XrQNH
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id2509201519371339\n"
+"help.text"
+msgid "5"
+msgstr ""
+
+#. 2v5YQ
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id981711556984697\n"
+"help.text"
+msgid "not"
+msgstr ""
+
+#. LBEMB
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id581711556987385\n"
+"help.text"
+msgid "not"
+msgstr ""
+
+#. sbyoX
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"hd_id751711480783220\n"
+"help.text"
+msgid "Example with ascending order and descending order (for English locale)"
+msgstr ""
+
+#. FA2hL
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id131711466000482\n"
+"help.text"
+msgid "<input>{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}</input>"
+msgstr ""
+
+#. q9cpQ
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id471711472262161\n"
+"help.text"
+msgid "Sort the range A2:C7 based on the first column in ascending order and third column in descending order."
 msgstr ""
 
 #. fKeqF
@@ -68462,6 +68633,240 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>."
 msgstr ""
 
+#. yiPhX
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"tit\n"
+"help.text"
+msgid "SUMIF Function"
+msgstr ""
+
+#. c4KFv
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"bm_id3151957\n"
+"help.text"
+msgid "<bookmark_value>SUMIF function</bookmark_value>      <bookmark_value>adding;specified numbers</bookmark_value>"
+msgstr ""
+
+#. aJCj8
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"hd_id3151957\n"
+"help.text"
+msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/func_sumif.xhp\">SUMIF</link></variable>"
+msgstr ""
+
+#. AWAK5
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id3151986\n"
+"help.text"
+msgid "<ahelp hid=\".\">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp>"
+msgstr ""
+
+#. DFaC8
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id411711032873068\n"
+"help.text"
+msgid "SUMIF can only apply a single criterion to a range. Use <link href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\">SUMIFS</link> if you need to apply multiple criteria."
+msgstr ""
+
+#. F7YsR
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id3152028\n"
+"help.text"
+msgid "<input>SUMIF(Range; Criterion [;SumRange])</input>"
+msgstr ""
+
+#. D2NiD
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id3152043\n"
+"help.text"
+msgid "<emph>Range: </emph> The range of cells to which the criterion is applied."
+msgstr ""
+
+#. ToLFA
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id521711134077228\n"
+"help.text"
+msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given."
+msgstr ""
+
+#. BMGEn
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id3152083\n"
+"help.text"
+msgid "<emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed."
+msgstr ""
+
+#. oviCS
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"hd_id451710857799382\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#. FsERF
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id171711049202378\n"
+"help.text"
+msgid "<input>=SUMIF(C2:C6,\">=100\")</input>"
+msgstr ""
+
+#. 6mqDE
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id381711049216331\n"
+"help.text"
+msgid "Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given."
+msgstr ""
+
+#. AEAwA
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id6670125\n"
+"help.text"
+msgid "<input>=SUMIF(B2:B5,\">=20\",C2:C6)</input>"
+msgstr ""
+
+#. nUdXV
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id341710857230552\n"
+"help.text"
+msgid "Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion."
+msgstr ""
+
+#. Zjs4B
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"hd_id291710867590698\n"
+"help.text"
+msgid "Using regular expressions"
+msgstr ""
+
+#. 2XByE
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id911710859836541\n"
+"help.text"
+msgid "<input>=SUMIF(A2:A6,\"pen\",C2:C5)</input>"
+msgstr ""
+
+#. 3ggQs
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id31710859838046\n"
+"help.text"
+msgid "Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters \"pen\". Returns 85 because rows A2 and A4:A6 do not meet the criterion."
+msgstr ""
+
+#. L9Ftz
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id781710871590769\n"
+"help.text"
+msgid "<input>=SUMIF(A2:A6,\"pen*\",C2:C6)</input>"
+msgstr ""
+
+#. netyd
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id431710871624405\n"
+"help.text"
+msgid "Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters \"pen\". Returns the value 150 because rows A4:A5 do not meet the criterion."
+msgstr ""
+
+#. PdFbx
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id311711128230771\n"
+"help.text"
+msgid "<input>=SUMIF(ProductName,\"pen*\",Revenue)</input>"
+msgstr ""
+
+#. ZeyUD
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id741711128545751\n"
+"help.text"
+msgid "A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named \"ProductName\", \"Sales\", and \"Revenue\", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href=\"text/scalc/01/04070100.xhp#definenames)\">Define Names</link> dialog."
+msgstr ""
+
+#. amnCv
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"hd_id531711029933195\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#. sGzYo
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id561711031254255\n"
+"help.text"
+msgid "If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example:"
+msgstr ""
+
+#. pAzfZ
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id331711030450765\n"
+"help.text"
+msgid "<input>=SUMIF(A2:A6,E2,C2:C6)</input>"
+msgstr ""
+
+#. sFiDn
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id11711031541218\n"
+"help.text"
+msgid "If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents."
+msgstr ""
+
+#. gyimf
+#: func_sumif.xhp
+msgctxt ""
+"func_sumif.xhp\n"
+"par_id771677014538669\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF\">SUMIF wiki page</link>."
+msgstr ""
+
 #. DfceH
 #: func_sumifs.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/00.po b/source/ca-valencia/helpcontent2/source/text/shared/00.po
index 5d348e77551..f5541390151 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: 2024-02-28 17:20+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:25+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textshared00/ca_VALENCIA/>\n"
@@ -11645,6 +11645,42 @@ msgctxt ""
 msgid "<variable id=\"layout\">Open a text document, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web - View</emph>.</variable>"
 msgstr "<variable id=\"layout\">Obriu un document de text i trieu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web ▸ Visualitza</emph>.</variable>"
 
+#. AaUZD
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id711711389000125\n"
+"help.text"
+msgid "On the top right menu (☰), choose <menuitem>Options</menuitem>"
+msgstr ""
+
+#. 8FwXn
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id321711391310148\n"
+"help.text"
+msgid "- then in the <menuitem>Options</menuitem> dialog, choose <menuitem>%PRODUCTNAME Writer - View</menuitem> or <menuitem>%PRODUCTNAME Writer/Web - View</menuitem>."
+msgstr ""
+
+#. q7vpo
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id531696596793952\n"
+"help.text"
+msgid "<keycode>Alt + F12</keycode>"
+msgstr ""
+
+#. bRTtE
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id641711391402403\n"
+"help.text"
+msgid "- then in the <menuitem>Options</menuitem> dialog, choose <menuitem>%PRODUCTNAME Writer - View</menuitem> or <menuitem>%PRODUCTNAME Writer/Web - View</menuitem>."
+msgstr ""
+
 #. JFs3v
 #: 00000406.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/01.po b/source/ca-valencia/helpcontent2/source/text/shared/01.po
index abf6815d3cf..11815ab0328 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: 2024-03-15 13:14+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:25+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/ca_VALENCIA/>\n"
@@ -16235,6 +16235,24 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/effectspage/EffectsPage\">Specify the font effects that you want to use.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/effectspage/EffectsPage\">Indiqueu els efectes dels tipus de lletra que voleu utilitzar.</ahelp>"
 
+#. cmpKA
+#: 05020200.xhp
+msgctxt ""
+"05020200.xhp\n"
+"par_id531711633095294\n"
+"help.text"
+msgid "Choose <menuitem>Home</menuitem> then click the <menuitem>Home</menuitem> dropdown on the right-hand side of the tab and choose <menuitem>Character</menuitem>."
+msgstr ""
+
+#. LXs3D
+#: 05020200.xhp
+msgctxt ""
+"05020200.xhp\n"
+"par_id891711633731822\n"
+"help.text"
+msgid "Choose <menuitem>Character - Character</menuitem>"
+msgstr ""
+
 #. AYN9L
 #: 05020200.xhp
 msgctxt ""
@@ -16262,33 +16280,6 @@ msgctxt ""
 msgid "To change the color of a text selection, select the text that you want to change, and click the <emph>Font Color</emph> icon. To apply a different color, click the arrow next to the <emph>Font Color</emph> icon, and then select the color that you want to use."
 msgstr "Per canviar el color d'una selecció de text, seleccioneu-la i feu clic a la icona <emph>Color de la lletra</emph>. Per aplicar-hi un altre color, feu clic a la fletxa situada al costat de la icona <emph>Color de la lletra</emph> i seleccioneu el color que vulgueu utilitzar."
 
-#. vT2uF
-#: 05020200.xhp
-msgctxt ""
-"05020200.xhp\n"
-"par_idN10CC9\n"
-"help.text"
-msgid "If you click the <emph>Font Color</emph> icon before you select text, the paint can cursor appears. To change the color of text, select the text with the paint can cursor. To change the color of a single word, double-click in a word. To apply a different color, click the arrow next to the <emph>Font Color</emph> icon, and then select the color that you want to use."
-msgstr "Si feu clic a la icona <emph>Color de la lletra</emph> abans de seleccionar el text, es mostra el cursor d'emplenament. Per canviar el color del text, seleccioneu el text amb el cursor d'emplenament. Per canviar el color d'una paraula, feu-hi doble clic. Per aplicar-hi un color diferent, feu clic a la fletxa situada al costat de la icona <emph>Color de la lletra</emph> i, tot seguit, seleccioneu el color que vulgueu utilitzar."
-
-#. vjg7G
-#: 05020200.xhp
-msgctxt ""
-"05020200.xhp\n"
-"par_idN10CD6\n"
-"help.text"
-msgid "To undo the last change, right-click."
-msgstr "Per revertir l'últim canvi, feu un clic amb el botó dret del ratolí."
-
-#. Dj8AA
-#: 05020200.xhp
-msgctxt ""
-"05020200.xhp\n"
-"par_idN10CDA\n"
-"help.text"
-msgid "To exit the paint can mode, click once, or press the <emph>Esc</emph> key."
-msgstr "Per a eixir del mode d'emplenament, feu un clic o premeu la tecla <emph>Esc</emph>."
-
 #. XqzQT
 #: 05020200.xhp
 msgctxt ""
@@ -21437,6 +21428,42 @@ msgctxt ""
 msgid "Kerning is only available for certain font types and requires that your printer support this option."
 msgstr "L'interlletratge només està disponible per a alguns tipus de lletra; a més, cal que la impressora admeti esta opció."
 
+#. KPLkS
+#: 05020500.xhp
+msgctxt ""
+"05020500.xhp\n"
+"hd_id3149822\n"
+"help.text"
+msgid "Hyphenation"
+msgstr ""
+
+#. zwx53
+#: 05020500.xhp
+msgctxt ""
+"05020500.xhp\n"
+"par_id3150013\n"
+"help.text"
+msgid "Skip <link href=\"text/swriter/guide/using_hyphen.xhp\">hyphenation</link> for selected words."
+msgstr ""
+
+#. DdWCv
+#: 05020500.xhp
+msgctxt ""
+"05020500.xhp\n"
+"hd_id3149823\n"
+"help.text"
+msgid "Exclude from hyphenation"
+msgstr ""
+
+#. 7TvpJ
+#: 05020500.xhp
+msgctxt ""
+"05020500.xhp\n"
+"par_id3150025\n"
+"help.text"
+msgid "<ahelp hid=\"cui/ui/positionpage/nohyphenation\">It prevents hyphenation of the selected word or words in a paragraph hyphenated automatically.</ahelp>"
+msgstr ""
+
 #. aqPsX
 #: 05020600.xhp
 msgctxt ""
@@ -47951,13 +47978,13 @@ msgctxt ""
 msgid "<ahelp hid=\".\">The manually formatted attributes of the text at the cursor position in the document will be added to the style that is selected in the Styles window.</ahelp>"
 msgstr ""
 
-#. c5KSR
+#. 9W88N
 #: StyleUpdateByExample.xhp
 msgctxt ""
 "StyleUpdateByExample.xhp\n"
 "par_id921693534308719\n"
 "help.text"
-msgid "<link href=\"text/swriter/main0115.xhp\">Styles menu</link>"
+msgid "<link href=\"text/shared/menu/style_menu.xhp\">Styles menu</link>"
 msgstr ""
 
 #. EGCCM
@@ -49859,23 +49886,23 @@ msgctxt ""
 msgid "Gallery"
 msgstr "Galeria"
 
-#. NBQoG
+#. mWDE9
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3149783\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_ICONVIEW\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as icons.</ahelp>"
-msgstr "<ahelp hid=\"SVX_HID_GALLERY_ICONVIEW\" visibility=\"hidden\">Mostra els continguts de la <emph>Galeria</emph> com a icones.</ahelp>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as icons.</ahelp>"
+msgstr ""
 
-#. qHpNn
+#. V28KG
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3148983\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_LISTVIEW\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as small icons, with title and path information.</ahelp>"
-msgstr "<ahelp hid=\"SVX_HID_GALLERY_LISTVIEW\" visibility=\"hidden\">Mostra els continguts de la <emph>Galeria</emph> com a icones petites, juntament amb el títol i la informació sobre el camí corresponents.</ahelp>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as small icons, with title and path information.</ahelp>"
+msgstr ""
 
 #. NjGBG
 #: gallery.xhp
@@ -49949,23 +49976,23 @@ msgctxt ""
 msgid "Gallery"
 msgstr ""
 
-#. R7joR
+#. Qg6Au
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3145346\n"
 "help.text"
-msgid "Themes are listed on the left side of the <emph>Gallery</emph>.<ahelp hid=\"SVX_HID_GALLERY_THEMELIST\">Click a theme to view the objects associated with the theme.</ahelp>"
+msgid "Themes are listed on the left side of the <emph>Gallery</emph>.<ahelp hid=\".\">Click a theme to view the objects associated with the theme.</ahelp>"
 msgstr ""
 
-#. 4F3zQ
+#. hQyCV
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3155355\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_WINDOW\">To insert a <emph>Gallery </emph>object, select the object, and then drag it into the document.</ahelp>"
-msgstr "<ahelp hid=\"SVX_HID_GALLERY_WINDOW\">Per a inserir un objecte de la <emph>Galeria</emph>, seleccioneu-lo i arrossegueu-lo al document.</ahelp>"
+msgid "<ahelp hid=\".\">To insert a <emph>Gallery </emph>object, select the object, and then drag it into the document.</ahelp>"
+msgstr ""
 
 #. RRsij
 #: gallery.xhp
@@ -49994,13 +50021,13 @@ msgctxt ""
 msgid "New theme"
 msgstr "Tema nou"
 
-#. oeKGW
+#. ATMux
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3150275\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_NEWTHEME\">Adds a new theme to the <emph>Gallery</emph> and lets you choose the files to include in the theme.</ahelp>"
+msgid "<ahelp hid=\".\">Adds a new theme to the <emph>Gallery</emph> and lets you choose the files to include in the theme.</ahelp>"
 msgstr ""
 
 #. T6Ztu
@@ -50183,14 +50210,14 @@ msgctxt ""
 msgid "Preview box"
 msgstr "Quadre Previsualització"
 
-#. yEjxA
+#. WKSeB
 #: gallery_files.xhp
 msgctxt ""
 "gallery_files.xhp\n"
 "par_id3153662\n"
 "help.text"
-msgid "<ahelp hid=\"HID_GALLERY_PREVIEW\">Displays a preview of the selected file.</ahelp>"
-msgstr "<ahelp hid=\"HID_GALLERY_PREVIEW\">Mostra una previsualització del fitxer seleccionat.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/galleryfilespage/image\">Displays a preview of the selected file.</ahelp>"
+msgstr ""
 
 #. VZmGe
 #: graphic_size_check.xhp
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/optionen.po b/source/ca-valencia/helpcontent2/source/text/shared/optionen.po
index 4b451f4cd19..46f0c741a7f 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: 2024-03-15 13:14+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:25+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textsharedoptionen/ca_VALENCIA/>\n"
@@ -5903,6 +5903,24 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/viewoptionspage/comments\">Displays comments. Click a comment to edit the text. Use the context menu in Navigator to locate or delete a comment. Use the comments's context menu to delete this comment or all comments or all comments of this author.</ahelp>"
 msgstr "<ahelp hid=\"modules/swriter/ui/viewoptionspage/comments\">Mostra els comentaris. Feu clic en un comentari per editar-ne el text. Utilitzeu el menú contextual del Navegador per trobar o suprimir un comentari. Utilitzeu el menú contextual del comentari per suprimir este comentari, tots els comentaris o bé tots els comentaris d'este autor.</ahelp>"
 
+#. U2H3W
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"hd_id921711370112453\n"
+"help.text"
+msgid "Resolved comments"
+msgstr ""
+
+#. nE3Aa
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"par_id281711393211024\n"
+"help.text"
+msgid "Display comments that have been marked as <link href=\"text/shared/01/04050000.xhp#resolvecomments\">resolved</link>."
+msgstr ""
+
 #. hDFez
 #: 01040200.xhp
 msgctxt ""
@@ -5948,6 +5966,51 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/swriter/ui/optformataidspage/hiddenparafield\">Display paragraphs that contain a <emph>Hidden Paragraph</emph> field.</ahelp> This option has the same function as the menu command <switchinline select=\"appl\"><caseinline select=\"WRITER\"><link href=\"text/swriter/01/03140000.xhp\"><menuitem>View - Field Hidden Paragraphs</menuitem></link></caseinline><defaultinline>View - Hidden Paragraphs</defaultinline></switchinline>."
 msgstr "<ahelp hid=\"modules/swriter/ui/optformataidspage/hiddenparafield\">Mostra els paràgrafs que contenen un camp de <emph>paràgraf amagat </emph>.</ahelp> Aquesta opció té la mateixa funció que l'ordre de menú <switchinline select=\"appl\"><caseinline select=\"WRITER\"><link href=\"text/swriter/01/03140000.xhp\"><menuitem>Visualitza ▸ Paràgrafs amagats</menuitem></link></caseinline><defaultinline>Visualitza ▸ Paràgrafs amagats</defaultinline></switchinline>."
 
+#. PXfZj
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"hd_id541711370751566\n"
+"help.text"
+msgid "Display tracked changes"
+msgstr ""
+
+#. TGWoS
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"hd_id641711371294636\n"
+"help.text"
+msgid "Tracked deletions in margin"
+msgstr ""
+
+#. miaqX
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"par_id571711373506102\n"
+"help.text"
+msgid "Displays text deleted from the document in the left margin, instead of inline."
+msgstr ""
+
+#. qZVCc
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"hd_id711711371135989\n"
+"help.text"
+msgid "Tooltips on tracked changes"
+msgstr ""
+
+#. mAKFc
+#: 01040200.xhp
+msgctxt ""
+"01040200.xhp\n"
+"par_id231711370755518\n"
+"help.text"
+msgid "Displays a tooltip when you mouseover a change in the document. The tooltip indicates the change's author, timestamp, and whether it is an insertion or deletion."
+msgstr ""
+
 #. 5TDVz
 #: 01040200.xhp
 msgctxt ""
@@ -16820,6 +16883,15 @@ msgctxt ""
 msgid "Select the <link href=\"text/shared/optionen/macrosecurity.xhp\">macro security</link> level from one of four options. The options differ according to the security level. Macros that are allowed to run on a higher security level are also allowed to run in all lower levels."
 msgstr "Seleccioneu el nivell de <link href=\"text/shared/optionen/macrosecurity.xhp\">seguretat de macros</link> entre una de les quatre opcions. Les opcions varien segons el nivell de seguretat. Les macros permeses en un nivell de seguretat més alt també es permetran en nivells inferiors."
 
+#. JrJD3
+#: macrosecurity_sl.xhp
+msgctxt ""
+"macrosecurity_sl.xhp\n"
+"par_id711710921223843\n"
+"help.text"
+msgid "A change in macro security level will only be taken into account in files opened after the change. For files currently opened, you will have to reload them."
+msgstr ""
+
 #. ocGx6
 #: macrosecurity_sl.xhp
 msgctxt ""
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/01.po b/source/ca-valencia/helpcontent2/source/text/swriter/01.po
index 938ba34855d..404fd74fb64 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: 2024-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-18 17:38+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textswriter01/ca_VALENCIA/>\n"
@@ -16271,42 +16271,6 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/textflowpage/checkAuto\">Automatically inserts hyphens where they are needed in a paragraph.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/textflowpage/checkAuto\">Insereix automàticament els guionets allà on són necessaris en un paràgraf.</ahelp>"
 
-#. gUGLi
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3153921\n"
-"help.text"
-msgid "Don't hyphenate words in CAPS"
-msgstr ""
-
-#. G7wCi
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3154648\n"
-"help.text"
-msgid "<ahelp hid=\"cui/ui/textflowpage/checkNoCaps\">Avoids hyphenating words written entirely in capital letters, such as initialisms.</ahelp>"
-msgstr ""
-
-#. UsYWm
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3153926\n"
-"help.text"
-msgid "Don't hyphenate the last word"
-msgstr "No partisques l'últim mot"
-
-#. KPba4
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3154655\n"
-"help.text"
-msgid "<ahelp hid=\"cui/ui/textflowpage/checkNoLastWord\">Avoids hyphenating the last word of paragraphs. This feature can help prevent these words from being split up across pages, affecting readability.</ahelp>"
-msgstr ""
-
 #. dtYTa
 #: 05030200.xhp
 msgctxt ""
@@ -16343,6 +16307,24 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/textflowpage/spinLineBegin\">Enter the minimum number of characters that must appear at the beginning of the line after the hyphen.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/textflowpage/spinLineBegin\">Introduïu el nombre mínim de caràcters que han d'aparèixer al començament de la línia després del guionet.</ahelp>"
 
+#. 4k7B5
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3145415\n"
+"help.text"
+msgid "Compound constituent characters at line end"
+msgstr ""
+
+#. NfpHX
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3147518\n"
+"help.text"
+msgid "<ahelp hid=\"cui/ui/textflowpage/spinCompoundLineEnd\">Set 3 (or more) characters to improve the hyphenation in Danish, Dutch, German, Hungarian, Norwegian and Swedish by preferring the hyphenation between constituents of a compound word instead of breaking the second (third etc.) constituent right after its first 2 characters.</ahelp>"
+msgstr ""
+
 #. haMfk
 #: 05030200.xhp
 msgctxt ""
@@ -16397,6 +16379,42 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/textflowpage/spinHyphenZone\">To reduce hyphenation, enter the length of the hyphenation zone. Instead of the possible hyphenation, the line will break between words, if the remaining horizontal space does not exceed the hyphenation zone. Hyphenation zone results in enlarged spaces between words in justified text, and greater distance from paragraph margins in non-justified text.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/textflowpage/spinHyphenZone\">Per a reduir la partició de mots, introduïu la grandària de la zona de partició. En lloc d'aplicar la partició possible, la línia es partirà entre les paraules, si l'espai horitzontal restant no sobrepassa la zona de partició. La zona de partició produeix majors espais entre paraules en textos justificats o majors distàncies des dels marges del paràgraf en textos no justificats.</ahelp>"
 
+#. GRBmw
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3153921\n"
+"help.text"
+msgid "Hyphenate words in CAPS"
+msgstr ""
+
+#. 7A5V4
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3154648\n"
+"help.text"
+msgid "<ahelp hid=\"cui/ui/textflowpage/checkNoCaps\">Hyphenate words written entirely in capital letters, such as initialisms.</ahelp>"
+msgstr ""
+
+#. 5FoUE
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3153926\n"
+"help.text"
+msgid "Hyphenate last word"
+msgstr ""
+
+#. 9shSg
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3154655\n"
+"help.text"
+msgid "<ahelp hid=\"cui/ui/textflowpage/checkNoLastWord\">Hyphenate the last word of paragraphs. Disabling this feature prevents the creation of almost empty lines containing only half a word.</ahelp>"
+msgstr ""
+
 #. RQLep
 #: 05030200.xhp
 msgctxt ""
@@ -27692,13 +27710,13 @@ msgctxt ""
 msgid "Select the <menuitem>Style</menuitem> panel (<keycode>F11</keycode>), choose Paragraph Styles, open context menu of the selected style, choose <menuitem>Edit Style</menuitem>."
 msgstr ""
 
-#. wEyNc
+#. wHfxU
 #: EditStyle.xhp
 msgctxt ""
 "EditStyle.xhp\n"
 "par_id921693534308719\n"
 "help.text"
-msgid "<link href=\"text/swriter/main0115.xhp\">Styles menu</link>"
+msgid "<link href=\"text/shared/menu/style_menu.xhp\">Styles menu</link>"
 msgstr ""
 
 #. PDPrT
diff --git a/source/ca-valencia/helpcontent2/source/text/swriter/02.po b/source/ca-valencia/helpcontent2/source/text/swriter/02.po
index 0536a66a827..e9689011fa0 100644
--- a/source/ca-valencia/helpcontent2/source/text/swriter/02.po
+++ b/source/ca-valencia/helpcontent2/source/text/swriter/02.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: 2024-03-11 16:41+0100\n"
+"POT-Creation-Date: 2024-04-02 12:12+0200\n"
 "PO-Revision-Date: 2023-08-10 21:24+0000\n"
 "Last-Translator: Joan Montané <joan@montane.cat>\n"
 "Language-Team: Catalan <https://translations.documentfoundation.org/projects/libo_help-master/textswriter02/ca_VALENCIA/>\n"
@@ -4256,51 +4256,6 @@ msgctxt ""
 msgid "<link href=\"text/swriter/01/04040000.xhp\">Insert Bookmark</link>"
 msgstr "<link href=\"text/swriter/01/04040000.xhp\">Insereix una adreça d'interés</link>"
 
-#. J6RpX
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Insert Fields"
-msgstr "Insereix els camps"
-
-#. 95S32
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"hd_id3149286\n"
-"help.text"
-msgid "<link href=\"text/swriter/02/19040000.xhp\">Insert Fields</link>"
-msgstr "<link href=\"text/swriter/02/19040000.xhp\">Insereix els camps</link>"
-
-#. 8sGAW
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"par_id3151173\n"
-"help.text"
-msgid "Click to open the <link href=\"text/swriter/01/04090000.xhp\">Fields</link> dialog. Click the arrow next to the icon and select the required field from the submenu."
-msgstr "Feu clic per obrir el diàleg <link href=\"text/swriter/01/04090000.xhp\">Camps</link>. Feu clic a la fletxa que apareix al costat de la icona i seleccioneu el camp necessari del submenú."
-
-#. 48CyU
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"par_id3154104\n"
-"help.text"
-msgid "You can select the following functions:"
-msgstr "Podeu seleccionar les funcions següents:"
-
-#. RcJ5e
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"hd_id3145248\n"
-"help.text"
-msgid "<link href=\"text/swriter/01/04090000.xhp\">Other</link>"
-msgstr "<link href=\"text/swriter/01/04090000.xhp\">Altres</link>"
-
 #. FM5sf
 #: 19050000.xhp
 msgctxt ""