update translations for master

and force-fix errors using pocheck

Change-Id: I65d403dd9ce3233ba067c1e76faa0b9f782fe816

8 files changed, 897 insertions, 258 deletions

diff --git a/source/fi/helpcontent2/source/text/sbasic/shared.po b/source/fi/helpcontent2/source/text/sbasic/shared.po
index 43f2fdb2bf0..253f420a1b1 100644
--- a/source/fi/helpcontent2/source/text/sbasic/shared.po
+++ b/source/fi/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2022-10-22 12:15+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/fi/>\n"
@@ -40756,6 +40756,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/fi/helpcontent2/source/text/scalc.po b/source/fi/helpcontent2/source/text/scalc.po
index 2b00cbddc13..6928658f852 100644
--- a/source/fi/helpcontent2/source/text/scalc.po
+++ b/source/fi/helpcontent2/source/text/scalc.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2019-07-16 16:13+0000\n"
 "Last-Translator: Jiri Grönroos <jiri.gronroos@iki.fi>\n"
 "Language-Team: Finnish <discuss@fi.libreoffice.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 "<ahelp hid=\"HID_SC_TOOLBOX_TABLE\"><emph>Muotoilu</emph>-palkissa on perustoiminnot, joita käytetään solujen yksityiskohtaisessa muotoilussa.</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\">Fontin väri</link>"
+msgid "<link href=\"text/shared/01/05020200.xhp#FontColor\">Font Color</link>"
+msgstr ""
 
 #. H2aV6
 #: main0202.xhp
diff --git a/source/fi/helpcontent2/source/text/scalc/01.po b/source/fi/helpcontent2/source/text/scalc/01.po
index f561ca54d01..996f85257ee 100644
--- a/source/fi/helpcontent2/source/text/scalc/01.po
+++ b/source/fi/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: 2024-02-05 09:45+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/fi/>\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 ""
-
-#. 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/fi/helpcontent2/source/text/shared/00.po b/source/fi/helpcontent2/source/text/shared/00.po
index a16f88b581b..0dff3810eb1 100644
--- a/source/fi/helpcontent2/source/text/shared/00.po
+++ b/source/fi/helpcontent2/source/text/shared/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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-06-29 21:35+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textshared00/fi/>\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/fi/helpcontent2/source/text/shared/01.po b/source/fi/helpcontent2/source/text/shared/01.po
index 21774822526..043ade8e550 100644
--- a/source/fi/helpcontent2/source/text/shared/01.po
+++ b/source/fi/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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-06 09:45+0000\n"
 "Last-Translator: AAAA <20001722@protonmail.com>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/fi/>\n"
@@ -16237,6 +16237,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\">Määritetään käytettävä fonttitehoste.</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 ""
@@ -16264,33 +16282,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 "Tekstivalinnan värin muuttamiseksi napsautetaan <emph>Fontin väri</emph> -kuvaketta. Eri värin käyttämiseksi napsautetaan <emph>Fontin väri</emph> -kuvakkeen jälkeistä nuolivalitsinta ja valitaan käytettävä väri."
 
-#. 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 "Jos <emph>Fontin väri</emph> -kuvaketta napsautetaan ennen tekstin valintaa, näkyviin saadaan maalikannuosoitin. Tekstin värin vaihtamiseksi teksti valitaan maalikannuosoittimella. Yksittäisen sanan värin vaihtamiseksi kaksoisnapsautetaan sanaa. Toisen värin käyttämiseksi napsautetaan <emph>Fontin väri</emph> -kuvakkeen jälkeistä nuolivalitsinta ja valitaan käytettävä väri."
-
-#. vjg7G
-#: 05020200.xhp
-msgctxt ""
-"05020200.xhp\n"
-"par_idN10CD6\n"
-"help.text"
-msgid "To undo the last change, right-click."
-msgstr "Viimeiseksi tehtyjen muutosten kumoamiseksi napsautetaan kakkospainikkeella."
-
-#. 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 ""
-
 #. XqzQT
 #: 05020200.xhp
 msgctxt ""
@@ -21439,6 +21430,42 @@ msgctxt ""
 msgid "Kerning is only available for certain font types and requires that your printer support this option."
 msgstr "Parivälistys on käytettävissä vain tietyillä fonttityypeillä ja se edellyttää, että tulostin tukee tätä asetusta."
 
+#. 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 ""
@@ -47956,13 +47983,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
@@ -49864,22 +49891,22 @@ msgctxt ""
 msgid "Gallery"
 msgstr "Galleria"
 
-#. 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
@@ -49954,22 +49981,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
@@ -49999,13 +50026,13 @@ msgctxt ""
 msgid "New theme"
 msgstr "Uusi teema"
 
-#. 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
@@ -50188,14 +50215,14 @@ msgctxt ""
 msgid "Preview box"
 msgstr "Esikatselukenttä"
 
-#. 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\">Esikatsellaan valittu tiedosto.</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/fi/helpcontent2/source/text/shared/optionen.po b/source/fi/helpcontent2/source/text/shared/optionen.po
index 707ad3dd2ec..0a6f9fde735 100644
--- a/source/fi/helpcontent2/source/text/shared/optionen.po
+++ b/source/fi/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2022-12-07 12:18+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textsharedoptionen/fi/>\n"
@@ -5904,6 +5904,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\">Näytetään huomautukset. Tekstiä muokataan napsauttamalla huomautusta. Rakenneselaimen kohdevalikkoa käyttäen paikallistetaan tai poistetaan huomautus. Huomautuksen kohdevalikkoa käytetään kohdistetun huomautuksen, kaikkien huomautusten tai käyttäjän kaikkien huomautusten poistamiseen.</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 ""
@@ -5949,6 +5967,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 ""
@@ -16826,6 +16889,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 "Valitaan <link href=\"text/shared/optionen/macrosecurity.xhp\">makrojen turvallisuuden</link> taso neljästä vaihtoehdosta. Vaihtoehdot eroavat turvallisuustasoltaan. Makrot, joiden suorittaminen on sallittu korkeammalla turvallisuustasolla, on sallittu myös kaikilla alemmilla tasoilla."
 
+#. 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/fi/helpcontent2/source/text/swriter/01.po b/source/fi/helpcontent2/source/text/swriter/01.po
index 8aeeaa40f7c..5a783718460 100644
--- a/source/fi/helpcontent2/source/text/swriter/01.po
+++ b/source/fi/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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: 2024-01-12 21:43+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textswriter01/fi/>\n"
@@ -16277,42 +16277,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\">Tavuviivoja tulee kappaleen tarpeen mukaisesti.</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 ""
-
-#. 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 ""
@@ -16349,6 +16313,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\">Annetaan lisättävän tavumerkin jälkeen sanaan rivin alkuun jäävien merkkien vähimmäismäärä.</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 ""
@@ -16403,6 +16385,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 ""
@@ -27699,13 +27717,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/fi/helpcontent2/source/text/swriter/02.po b/source/fi/helpcontent2/source/text/swriter/02.po
index 54c23e996c3..213bd2e8215 100644
--- a/source/fi/helpcontent2/source/text/swriter/02.po
+++ b/source/fi/helpcontent2/source/text/swriter/02.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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 14:36+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Finnish <discuss@fi.libreoffice.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\">Lisää kirjanmerkki</link>"
 
-#. J6RpX
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Insert Fields"
-msgstr "Lisää kentät"
-
-#. 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\">Lisää kentät</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 "Napsautetaan <link href=\"text/swriter/01/04090000.xhp\">Kentät</link>-valintaikkuna auki tai napsautetaan kuvakkeen jälkeistä nuolivalitsinta ja valitaan tarvittava kenttä alavalikosta."
-
-#. 48CyU
-#: 19040000.xhp
-msgctxt ""
-"19040000.xhp\n"
-"par_id3154104\n"
-"help.text"
-msgid "You can select the following functions:"
-msgstr "Seuraavat toiminnot ovat valittavissa:"
-
-#. 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\">Muu</link>"
-
 #. FM5sf
 #: 19050000.xhp
 msgctxt ""