update translations for master

and force-fix errors using pocheck

Change-Id: I65d403dd9ce3233ba067c1e76faa0b9f782fe816

8 files changed, 893 insertions, 254 deletions

diff --git a/source/si/helpcontent2/source/text/sbasic/shared.po b/source/si/helpcontent2/source/text/sbasic/shared.po
index f96608baf13..95a2d33725b 100644
--- a/source/si/helpcontent2/source/text/sbasic/shared.po
+++ b/source/si/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: 2018-10-21 20:33+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -40750,6 +40750,132 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03090411.xhp\">With</link> statement"
 msgstr ""
 
+#. 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/si/helpcontent2/source/text/scalc.po b/source/si/helpcontent2/source/text/scalc.po
index 5f0c8c01499..e6647b073bf 100644
--- a/source/si/helpcontent2/source/text/scalc.po
+++ b/source/si/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: 2017-07-04 21:44+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -376,14 +376,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_SC_TOOLBOX_TABLE\">The <emph>Formatting</emph> bar contains basic commands for applying manually formatting.</ahelp>"
 msgstr ""
 
-#. 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\">ෆොන්ට් වර්ණය</link>"
+msgid "<link href=\"text/shared/01/05020200.xhp#FontColor\">Font Color</link>"
+msgstr ""
 
 #. H2aV6
 #: main0202.xhp
diff --git a/source/si/helpcontent2/source/text/scalc/01.po b/source/si/helpcontent2/source/text/scalc/01.po
index a17b0cc0489..049d6868c24 100644
--- a/source/si/helpcontent2/source/text/scalc/01.po
+++ b/source/si/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: 2018-11-12 14:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -14002,96 +14002,6 @@ msgctxt ""
 msgid "<item type=\"input\">=SINH(0)</item> returns 0, the hyperbolic sine of 0."
 msgstr ""
 
-#. 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>SIGN function</bookmark_value><bookmark_value>algebraic signs</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 ""
-
-#. 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 ""
-
-#. 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 ""
-
-#. 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 ""
-
 #. BHGzQ
 #: 04060106.xhp
 msgctxt ""
@@ -56212,24 +56122,6 @@ msgctxt ""
 msgid "Product Name"
 msgstr ""
 
-#. HZpK7
-#: ex_data_stat_func.xhp
-msgctxt ""
-"ex_data_stat_func.xhp\n"
-"par_id2509201517433075\n"
-"help.text"
-msgid "Sales"
-msgstr ""
-
-#. NEEL8
-#: ex_data_stat_func.xhp
-msgctxt ""
-"ex_data_stat_func.xhp\n"
-"par_id2509201519383294\n"
-"help.text"
-msgid "Revenue"
-msgstr ""
-
 #. ZyGBE
 #: ex_data_stat_func.xhp
 msgctxt ""
@@ -56266,29 +56158,29 @@ msgctxt ""
 msgid "book"
 msgstr ""
 
-#. 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 ""
 
-#. 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 ""
 
-#. 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 ""
@@ -68092,22 +67984,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
@@ -68146,22 +68227,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
@@ -68461,6 +68632,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/si/helpcontent2/source/text/shared/00.po b/source/si/helpcontent2/source/text/shared/00.po
index b4489eb6321..6ce1d353433 100644
--- a/source/si/helpcontent2/source/text/shared/00.po
+++ b/source/si/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: 2018-11-14 12:09+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -11644,6 +11644,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 ""
 
+#. 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/si/helpcontent2/source/text/shared/01.po b/source/si/helpcontent2/source/text/shared/01.po
index c4d86a92731..b2ea42d1b4d 100644
--- a/source/si/helpcontent2/source/text/shared/01.po
+++ b/source/si/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-12-29 09:45+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: Sinhala <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/si/>\n"
@@ -16234,58 +16234,49 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/effectspage/EffectsPage\">Specify the font effects that you want to use.</ahelp>"
 msgstr ""
 
-#. AYN9L
+#. cmpKA
 #: 05020200.xhp
 msgctxt ""
 "05020200.xhp\n"
-"hd_id3149482\n"
+"par_id531711633095294\n"
 "help.text"
-msgid "Font Color"
+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 ""
 
-#. yZAbJ
+#. LXs3D
 #: 05020200.xhp
 msgctxt ""
 "05020200.xhp\n"
-"par_id3146924\n"
+"par_id891711633731822\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/effectspage/fontcolorlb\">Sets the color for the selected text. If you select <emph>Automatic</emph>, the text color is set to black for light backgrounds and to white for dark backgrounds.</ahelp>"
+msgid "Choose <menuitem>Character - Character</menuitem>"
 msgstr ""
 
-#. ScU6M
-#: 05020200.xhp
-msgctxt ""
-"05020200.xhp\n"
-"par_idN10CC2\n"
-"help.text"
-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 ""
-
-#. vT2uF
+#. AYN9L
 #: 05020200.xhp
 msgctxt ""
 "05020200.xhp\n"
-"par_idN10CC9\n"
+"hd_id3149482\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."
+msgid "Font Color"
 msgstr ""
 
-#. vjg7G
+#. yZAbJ
 #: 05020200.xhp
 msgctxt ""
 "05020200.xhp\n"
-"par_idN10CD6\n"
+"par_id3146924\n"
 "help.text"
-msgid "To undo the last change, right-click."
+msgid "<ahelp hid=\"cui/ui/effectspage/fontcolorlb\">Sets the color for the selected text. If you select <emph>Automatic</emph>, the text color is set to black for light backgrounds and to white for dark backgrounds.</ahelp>"
 msgstr ""
 
-#. Dj8AA
+#. ScU6M
 #: 05020200.xhp
 msgctxt ""
 "05020200.xhp\n"
-"par_idN10CDA\n"
+"par_idN10CC2\n"
 "help.text"
-msgid "To exit the paint can mode, click once, or press the <emph>Esc</emph> key."
+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 ""
 
 #. XqzQT
@@ -21436,6 +21427,42 @@ msgctxt ""
 msgid "Kerning is only available for certain font types and requires that your printer support this option."
 msgstr ""
 
+#. 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 ""
@@ -47950,13 +47977,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
@@ -49858,22 +49885,22 @@ msgctxt ""
 msgid "Gallery"
 msgstr "කලාගාරය"
 
-#. 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>"
+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>"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as small icons, with title and path information.</ahelp>"
 msgstr ""
 
 #. NjGBG
@@ -49948,22 +49975,22 @@ 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>"
+msgid "<ahelp hid=\".\">To insert a <emph>Gallery </emph>object, select the object, and then drag it into the document.</ahelp>"
 msgstr ""
 
 #. RRsij
@@ -49993,13 +50020,13 @@ msgctxt ""
 msgid "New theme"
 msgstr ""
 
-#. 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
@@ -50182,13 +50209,13 @@ msgctxt ""
 msgid "Preview box"
 msgstr ""
 
-#. 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>"
+msgid "<ahelp hid=\"cui/ui/galleryfilespage/image\">Displays a preview of the selected file.</ahelp>"
 msgstr ""
 
 #. VZmGe
diff --git a/source/si/helpcontent2/source/text/shared/optionen.po b/source/si/helpcontent2/source/text/shared/optionen.po
index 431396ff4c2..37b12697fe0 100644
--- a/source/si/helpcontent2/source/text/shared/optionen.po
+++ b/source/si/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: 2018-11-14 12:09+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5902,6 +5902,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 ""
 
+#. 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 ""
@@ -5947,6 +5965,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 ""
 
+#. 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 ""
@@ -16819,6 +16882,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 ""
 
+#. 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/si/helpcontent2/source/text/swriter/01.po b/source/si/helpcontent2/source/text/swriter/01.po
index e0dc54fc4c2..ad84a287953 100644
--- a/source/si/helpcontent2/source/text/swriter/01.po
+++ b/source/si/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: 2018-10-21 20:34+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -16270,42 +16270,6 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/textflowpage/checkAuto\">Automatically inserts hyphens where they are needed in a paragraph.</ahelp>"
 msgstr ""
 
-#. 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 ""
-
-#. 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 ""
@@ -16342,6 +16306,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 ""
 
+#. 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 ""
@@ -16396,6 +16378,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 ""
 
+#. 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 ""
@@ -27691,13 +27709,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/si/helpcontent2/source/text/swriter/02.po b/source/si/helpcontent2/source/text/swriter/02.po
index 05a87610fe5..ad8d14aee02 100644
--- a/source/si/helpcontent2/source/text/swriter/02.po
+++ b/source/si/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: 2017-11-22 15:20+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4255,51 +4255,6 @@ msgctxt ""
 msgid "<link href=\"text/swriter/01/04040000.xhp\">Insert Bookmark</link>"
 msgstr "<link href=\"text/swriter/01/04040000.xhp\">පිටු සළකුණ ඇතුළු කරන්න</link>"
 
-#. J6RpX
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Insert Fields"
-msgstr "ක්ෂේත්‍ර ඇතුළු කරන්න"
-
-#. 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\">ක්ෂේත්‍රයන් ඇතුළු කරන්න</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 ""
-
-#. 48CyU
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"par_id3154104\n"
-"help.text"
-msgid "You can select the following functions:"
-msgstr "මතු සඳහන් වන ශ්‍රිතයන් තෝරා ගැනීමට ඔබට පුළුවනි:"
-
-#. 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\">වෙනත්</link>"
-
 #. FM5sf
 #: 19050000.xhp
 msgctxt ""