update translations for master

and force-fix errors using pocheck

Change-Id: I7aae0544505f037b2eac91c268744de617dc4386

13 files changed, 969 insertions, 204 deletions

diff --git a/source/lo/helpcontent2/source/text/sbasic/python.po b/source/lo/helpcontent2/source/text/sbasic/python.po
index 39c5dea2511..a0392202ce2 100644
--- a/source/lo/helpcontent2/source/text/sbasic/python.po
+++ b/source/lo/helpcontent2/source/text/sbasic/python.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: 2023-12-04 15:06+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3559,76 +3559,85 @@ msgctxt ""
 msgid "The Python interactive console, also known as Python interpreter or Python shell, provides programmers with a quick way to execute commands and try out and test code without creating a file. UNO objects introspection as well as %PRODUCTNAME Python modules documentation can be obtained from the terminal."
 msgstr ""
 
-#. kFpxo
+#. fk6sx
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"par_id851633601202270\n"
+"hd_id381633446811095\n"
 "help.text"
-msgid "From a full-featured %PRODUCTNAME installed package, use either Basic or Python:"
+msgid "Using the Terminal"
 msgstr ""
 
-#. 5HhXz
+#. CNFdD
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"N0121\n"
+"par_id801633601715910\n"
 "help.text"
-msgid "Using a Basic macro"
+msgid "From a %PRODUCTNAME copy included in a GNU/Linux platform, use the terminal as shown:"
 msgstr ""
 
-#. KhWLk
+#. vWPwe
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"N0127\n"
+"par_id531633444780190\n"
 "help.text"
-msgid "Using a Python macro"
+msgid "<literal>whereis</literal> or <literal>type</literal> terminal commands help locate Python interactive console:"
 msgstr ""
 
-#. 3FCJH
+#. ZXEeE
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"N0141\n"
+"par_id851633601202270\n"
 "help.text"
-msgid "Example output"
+msgid "From a full-featured %PRODUCTNAME installed package, a Basic or Python script locates the embedded copy of Python console."
 msgstr ""
 
-#. MxDtE
+#. 5HhXz
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"N0142\n"
+"N0121\n"
 "help.text"
-msgid "<image src=\"media/helpimg/python/python_interactive_console.png\" id=\"N0143\"><alt id=\"N0143\">Python Interactive Console</alt></image>"
+msgid "Using a Basic macro"
 msgstr ""
 
-#. fk6sx
+#. nHPAA
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"hd_id381633446811095\n"
+"par_id71707747845585\n"
 "help.text"
-msgid "Using the Terminal"
+msgid "This routine resorts to <link href=\"text/sbasic/python/python_platform.xhp\">Platform class module</link> in order to distinguish the actual operating system."
 msgstr ""
 
-#. CNFdD
+#. KhWLk
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"par_id801633601715910\n"
+"N0127\n"
 "help.text"
-msgid "From a %PRODUCTNAME copy included in a GNU/Linux platform, use the terminal as shown:"
+msgid "Using a Python macro"
 msgstr ""
 
-#. vWPwe
+#. 3FCJH
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
-"par_id531633444780190\n"
+"N0141\n"
 "help.text"
-msgid "<literal>whereis</literal> or <literal>type</literal> terminal commands help locate Python interactive console:"
+msgid "Example output"
+msgstr ""
+
+#. MxDtE
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"N0142\n"
+"help.text"
+msgid "<image src=\"media/helpimg/python/python_interactive_console.png\" id=\"N0143\"><alt id=\"N0143\">Python Interactive Console</alt></image>"
 msgstr ""
 
 #. 8Ei5d
diff --git a/source/lo/helpcontent2/source/text/sbasic/shared.po b/source/lo/helpcontent2/source/text/sbasic/shared.po
index 2e81296a039..12f092e892a 100644
--- a/source/lo/helpcontent2/source/text/sbasic/shared.po
+++ b/source/lo/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-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-10-21 20:25+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -24352,13 +24352,13 @@ msgctxt ""
 msgid "<bookmark_value>CDec function</bookmark_value>"
 msgstr ""
 
-#. keJSN
+#. gCHYo
 #: 03100060.xhp
 msgctxt ""
 "03100060.xhp\n"
 "par_idN10548\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100060.xhp\">CDec Function</link>"
+msgid "<variable id=\"CDec_h1\"><link href=\"text/sbasic/shared/03100060.xhp\">CDec Function</link></variable>"
 msgstr ""
 
 #. aEBmF
@@ -24775,13 +24775,13 @@ msgctxt ""
 msgid "<bookmark_value>CDate function</bookmark_value>"
 msgstr ""
 
-#. 7Sonr
+#. oJpyX
 #: 03100300.xhp
 msgctxt ""
 "03100300.xhp\n"
 "hd_id3150772\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100300.xhp\">CDate Function</link>"
+msgid "<variable id=\"CDate_h1\"><link href=\"text/sbasic/shared/03100300.xhp\">CDate Function</link></variable>"
 msgstr ""
 
 #. DYpHk
@@ -24847,13 +24847,13 @@ msgctxt ""
 msgid "<bookmark_value>CDbl function</bookmark_value>"
 msgstr ""
 
-#. srMKR
+#. ccQHz
 #: 03100400.xhp
 msgctxt ""
 "03100400.xhp\n"
 "hd_id3153750\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100400.xhp\">CDbl Function</link>"
+msgid "<variable id=\"CDbl_h1\"><link href=\"text/sbasic/shared/03100400.xhp\">CDbl Function</link></variable>"
 msgstr ""
 
 #. EwDaU
@@ -24892,13 +24892,13 @@ msgctxt ""
 msgid "<bookmark_value>CInt function</bookmark_value>"
 msgstr ""
 
-#. zGC6k
+#. GKxJJ
 #: 03100500.xhp
 msgctxt ""
 "03100500.xhp\n"
 "hd_id3149346\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100500.xhp\">CInt Function</link>"
+msgid "<variable id=\"CInt_h1\"><link href=\"text/sbasic/shared/03100500.xhp\">CInt Function</link></variable>"
 msgstr ""
 
 #. dESLg
@@ -25009,13 +25009,13 @@ msgctxt ""
 msgid "<bookmark_value>CLng function</bookmark_value>"
 msgstr ""
 
-#. eNxuW
+#. DkYSA
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "hd_id3153311\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100600.xhp\">CLng Function</link>"
+msgid "<variable id=\"CLng_h1\"><link href=\"text/sbasic/shared/03100600.xhp\">CLng Function</link></variable>"
 msgstr ""
 
 #. aLcQC
@@ -25261,13 +25261,13 @@ msgctxt ""
 msgid "<bookmark_value>CSng function</bookmark_value>"
 msgstr ""
 
-#. oYHMQ
+#. RC2Mo
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
 "hd_id3153753\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03100900.xhp\">CSng Function</link>"
+msgid "<variable id=\"CSng_h1\"><link href=\"text/sbasic/shared/03100900.xhp\">CSng Function</link></variable>"
 msgstr ""
 
 #. 8RgCe
@@ -25360,13 +25360,13 @@ msgctxt ""
 msgid "<bookmark_value>CStr function</bookmark_value>"
 msgstr ""
 
-#. DQkiY
+#. CqFCm
 #: 03101000.xhp
 msgctxt ""
 "03101000.xhp\n"
 "hd_id3146958\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03101000.xhp\">CStr Function</link>"
+msgid "<variable id=\"CStr_h1\"><link href=\"text/sbasic/shared/03101000.xhp\">CStr Function</link></variable>"
 msgstr ""
 
 #. 3CEMW
diff --git a/source/lo/helpcontent2/source/text/sbasic/shared/03.po b/source/lo/helpcontent2/source/text/sbasic/shared/03.po
index 53a3c8cb1f1..d02ef989c74 100644
--- a/source/lo/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/lo/helpcontent2/source/text/sbasic/shared/03.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2024-02-14 13:07+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-07-12 14:33+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2662,13 +2662,13 @@ msgctxt ""
 msgid "The code snippet below prints the names of all form documents in the current Base document."
 msgstr ""
 
-#. Rr46X
+#. 2zKqo
 #: sf_base.xhp
 msgctxt ""
 "sf_base.xhp\n"
 "par_id921619036922844\n"
 "help.text"
-msgid "To learn more about form documents, refer to the <link href=\"text/sbasic/shared/03/sf_form.xhp\"><literal>Form</literal> service help page</link>."
+msgid "To learn more about form documents, refer to <link href=\"text/sbasic/shared/03/sf_formdocument.xhp\"><literal>ScriptForge.FormDocument</literal> service</link> help page."
 msgstr ""
 
 #. gCGqW
@@ -6685,13 +6685,13 @@ msgctxt ""
 msgid "Converts a column number ranging between 1 and 1024 into its corresponding letter (column 'A', 'B', ..., 'AMJ'). If the given column number is outside the allowed range, a zero-length string is returned."
 msgstr ""
 
-#. EfsXe
+#. xi3Ex
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id83159163272628\n"
 "help.text"
-msgid "<emph>columnnumber</emph>: The column number as an integer value in the interval 1 ... 1024."
+msgid "<emph>columnnumber</emph>: The column number as an integer value in the interval 1 ... 16384."
 msgstr ""
 
 #. 6yjtp
@@ -6703,13 +6703,13 @@ msgctxt ""
 msgid "Displays a message box with the name of the third column, which by default is \"C\"."
 msgstr ""
 
-#. XNAhU
+#. SyQ5w
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id451611753568778\n"
 "help.text"
-msgid "The maximum number of columns allowed on a Calc sheet is 1024."
+msgid "The maximum number of columns allowed on a Calc sheet is 16384."
 msgstr ""
 
 #. ksYoG
@@ -18025,13 +18025,13 @@ msgctxt ""
 msgid "<emph>family</emph>: One of the style families present in the actual document, as a case-sensitive string. Valid family names can be retrieved using <literal>StyleFamilies</literal> property."
 msgstr ""
 
-#. gXy2j
+#. DFDNB
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id361589211129686\n"
 "help.text"
-msgid "<emph>stylelist</emph>: A single style name as a string or an array of style names. The style names may be localized or not. The <literal>StylesList</literal> is typically the output of the execution of a <literal>Styles()</literal> method."
+msgid "<emph>styleslist</emph>: A single style name as a string or an array of style names. The style names may be localized or not. The <literal>StylesList</literal> is typically the output of the execution of a <literal>Styles()</literal> method."
 msgstr ""
 
 #. AJtnV
@@ -18214,78 +18214,6 @@ msgctxt ""
 msgid "' Sets to True the option to export comments as PDF notes"
 msgstr ""
 
-#. TiH9w
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id266589200121149\n"
-"help.text"
-msgid "This method loads all the styles belonging to one or more style families from a closed file into the actual document. The actual document must be a <literal>Calc</literal> or a <literal>Writer</literal> document."
-msgstr ""
-
-#. gCqGQ
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id11701265953648\n"
-"help.text"
-msgid "Are always imported together:"
-msgstr ""
-
-#. tjyq4
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id221701265998649\n"
-"help.text"
-msgid "<literal>ParagraphStyles</literal> and <literal>CharacterStyles</literal>"
-msgstr ""
-
-#. xPubF
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id441701265999801\n"
-"help.text"
-msgid "<literal>NumberingStyles</literal> and <literal>ListStyles</literal>"
-msgstr ""
-
-#. D9og7
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id091611169416945\n"
-"help.text"
-msgid "Returns <literal>True</literal> if styles were successfully imported."
-msgstr ""
-
-#. 2LSWM
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id321635436910004\n"
-"help.text"
-msgid "<emph>filename</emph>: The file from which to load the styles in the <literal>FileSystem</literal> notation. The file is presumed to be of the same document type as the actual document."
-msgstr ""
-
-#. cQ2o3
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id251635436912157\n"
-"help.text"
-msgid "<emph>families</emph>: One of the style families present in the actual document, as a case-sensitive string or an array of such strings. Leave this argument blank to import all families."
-msgstr ""
-
-#. 2TZYE
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id362635436912268\n"
-"help.text"
-msgid "<emph>overwrite</emph>: When <literal>True</literal>, the actual styles may be overwritten. Default is <literal>False</literal>."
-msgstr ""
-
 #. HNC9m
 #: sf_document.xhp
 msgctxt ""
@@ -37627,6 +37555,78 @@ msgctxt ""
 msgid "In the following examples, the first line gets the names of all forms in the document and the second line retrieves the <literal>Form</literal> object of the form named \"Form_A\"."
 msgstr ""
 
+#. DAPvU
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id266589200121149\n"
+"help.text"
+msgid "This method loads all the styles belonging to one or more style families from a closed file into the actual document. The actual document must be a <literal>Calc</literal> or a <literal>Writer</literal> document."
+msgstr ""
+
+#. rUCrN
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id11701265953648\n"
+"help.text"
+msgid "Are always imported together:"
+msgstr ""
+
+#. bBHQP
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id221701265998649\n"
+"help.text"
+msgid "<literal>ParagraphStyles</literal> and <literal>CharacterStyles</literal>"
+msgstr ""
+
+#. 3tCVF
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id441701265999801\n"
+"help.text"
+msgid "<literal>NumberingStyles</literal> and <literal>ListStyles</literal>"
+msgstr ""
+
+#. csQsA
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id091611169416945\n"
+"help.text"
+msgid "Returns <literal>True</literal> if styles were successfully imported."
+msgstr ""
+
+#. 9MPqf
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id321635436910004\n"
+"help.text"
+msgid "<emph>filename</emph>: The file from which to load the styles in the <literal>FileSystem</literal> notation. The file is presumed to be of the same document type as the actual document."
+msgstr ""
+
+#. FfUzE
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id251635436912157\n"
+"help.text"
+msgid "<emph>families</emph>: One of the style families present in the actual document, as a case-sensitive string or an array of such strings. Leave this argument blank to import all families."
+msgstr ""
+
+#. yZYQv
+#: sf_writer.xhp
+msgctxt ""
+"sf_writer.xhp\n"
+"par_id362635436912268\n"
+"help.text"
+msgid "<emph>overwrite</emph>: When <literal>True</literal>, the actual styles may be overwritten. Default is <literal>False</literal>."
+msgstr ""
+
 #. 7FEdd
 #: sf_writer.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/scalc/00.po b/source/lo/helpcontent2/source/text/scalc/00.po
index f4f259d269f..448e0bb93f5 100644
--- a/source/lo/helpcontent2/source/text/scalc/00.po
+++ b/source/lo/helpcontent2/source/text/scalc/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2024-02-14 13:07+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5767,6 +5767,33 @@ msgctxt ""
 msgid "This function is available since %PRODUCTNAME 7.5."
 msgstr ""
 
+#. BBvtw
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id581708280759954\n"
+"help.text"
+msgid "This function is available since %PRODUCTNAME 7.6."
+msgstr ""
+
+#. t5VoF
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id81708280763167\n"
+"help.text"
+msgid "This function is available since %PRODUCTNAME 24.2."
+msgstr ""
+
+#. Lh98N
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id491708280768121\n"
+"help.text"
+msgid "This function is available since %PRODUCTNAME 24.8."
+msgstr ""
+
 #. LSPBz
 #: sheet_menu.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/scalc/01.po b/source/lo/helpcontent2/source/text/scalc/01.po
index 7523bf585a5..f9cc9921367 100644
--- a/source/lo/helpcontent2/source/text/scalc/01.po
+++ b/source/lo/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-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-12 13:51+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -529,42 +529,6 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/navigatorpanel/documents\">Displays the names of all open documents.</ahelp> To switch to another open document in the Navigator, click the document name. The status (active, inactive) of the document is shown in brackets after the name. You can switch the active document in the <emph>Window</emph> menu."
 msgstr ""
 
-#. 9DPjf
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Headers & Footers"
-msgstr ""
-
-#. Vm7Du
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"hd_id3145251\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/02120000.xhp\">Headers & Footers</link>"
-msgstr ""
-
-#. b7G8C
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"par_id3151073\n"
-"help.text"
-msgid "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".\">Allows you to define and format headers and footers.</ahelp> </variable>"
-msgstr ""
-
-#. yaZ62
-#: 02120000.xhp
-msgctxt ""
-"02120000.xhp\n"
-"par_id3153415\n"
-"help.text"
-msgid "The <emph>Headers/Footers</emph> dialog contains the tabs for defining headers and footers. There will be separate tabs for the left and right page headers and footers if the <emph>Same content left/right</emph> option was not marked in the <link href=\"text/scalc/01/05070000.xhp\"><emph>Page Style</emph></link> dialog."
-msgstr ""
-
 #. CTq6U
 #: 02120100.xhp
 msgctxt ""
@@ -53332,13 +53296,13 @@ msgctxt ""
 msgid "Insert the document title in the cell. The document title is set in the document properties in <menuitem>File - Properties - Description</menuitem> tab."
 msgstr ""
 
-#. JfG9p
+#. rMdGX
 #: FormatSparklineMenu.xhp
 msgctxt ""
 "FormatSparklineMenu.xhp\n"
 "tit\n"
 "help.text"
-msgid "FormatSparklineMenu"
+msgid "Format Sparkline Menu"
 msgstr ""
 
 #. CGFJG
@@ -62476,6 +62440,60 @@ msgctxt ""
 msgid "<link href=\"text/scalc/05/02140000.xhp\">Error codes</link>"
 msgstr ""
 
+#. qdiU7
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"tit\n"
+"help.text"
+msgid "FILTER function"
+msgstr ""
+
+#. uj4VA
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>FILTER function</bookmark_value>"
+msgstr ""
+
+#. ymoUm
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_filter.xhp\">FILTER</link></variable>"
+msgstr ""
+
+#. XqJ48
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. PNSyJ
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "FILTER(...)"
+msgstr ""
+
+#. q34Yg
+#: func_filter.xhp
+msgctxt ""
+"func_filter.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTER\">FILTER wiki page</link>."
+msgstr ""
+
 #. sUgSM
 #: func_findb.xhp
 msgctxt ""
@@ -66868,6 +66886,60 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>"
 msgstr ""
 
+#. CNANB
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"tit\n"
+"help.text"
+msgid "RANDARRAY function"
+msgstr ""
+
+#. 2CEfW
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>RANDARRAY function</bookmark_value>"
+msgstr ""
+
+#. 42Cqg
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_randarray.xhp\">RANDARRAY</link></variable>"
+msgstr ""
+
+#. 3voMF
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. n2JxT
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "RANDARRAY(...)"
+msgstr ""
+
+#. iGDsD
+#: func_randarray.xhp
+msgctxt ""
+"func_randarray.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/RANDARRAY\">RANDARRAY wiki page</link>."
+msgstr ""
+
 #. zr5G3
 #: func_rawsubtract.xhp
 msgctxt ""
@@ -67804,6 +67876,60 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND\">SECOND wiki page</link>."
 msgstr ""
 
+#. rXRmt
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"tit\n"
+"help.text"
+msgid "SEQUENCE function"
+msgstr ""
+
+#. Wvq6Q
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SEQUENCE function</bookmark_value>"
+msgstr ""
+
+#. PpKCo
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sequence.xhp\">SEQUENCE</link></variable>"
+msgstr ""
+
+#. BoGGv
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 2wcAc
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SEQUENCE(...)"
+msgstr ""
+
+#. sNE2S
+#: func_sequence.xhp
+msgctxt ""
+"func_sequence.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEQUENCE\">SEQUENCE wiki page</link>."
+msgstr ""
+
 #. JBtM4
 #: func_skewp.xhp
 msgctxt ""
@@ -67894,6 +68020,114 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060185.xhp#skew\">SKEW</link>"
 msgstr ""
 
+#. ZzbFz
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"tit\n"
+"help.text"
+msgid "SORT function"
+msgstr ""
+
+#. Zo6YN
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SORT function</bookmark_value>"
+msgstr ""
+
+#. Ra8Tv
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>"
+msgstr ""
+
+#. 4Ky6H
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. NFc8B
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SORT(...)"
+msgstr ""
+
+#. JDbrP
+#: func_sort.xhp
+msgctxt ""
+"func_sort.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORT\">SORT wiki page</link>."
+msgstr ""
+
+#. wvW3s
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"tit\n"
+"help.text"
+msgid "SORTBY function"
+msgstr ""
+
+#. u8gwR
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>SORTBY function</bookmark_value>"
+msgstr ""
+
+#. AcwQa
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>"
+msgstr ""
+
+#. EFPmE
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 6QrpC
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "SORTBY(...)"
+msgstr ""
+
+#. fKeqF
+#: func_sortby.xhp
+msgctxt ""
+"func_sortby.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORTBY\">SORTBY wiki page</link>."
+msgstr ""
+
 #. CPDEq
 #: func_style.xhp
 msgctxt ""
@@ -69046,6 +69280,60 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\">TRUNC wiki page</link>."
 msgstr ""
 
+#. 8hfFB
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"tit\n"
+"help.text"
+msgid "UNIQUE function"
+msgstr ""
+
+#. CeV2j
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>UNIQUE function</bookmark_value>"
+msgstr ""
+
+#. RcWgN
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"hd_id901708806478126\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_unique.xhp\">UNIQUE</link></variable>"
+msgstr ""
+
+#. aSANQ
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id771708806478128\n"
+"help.text"
+msgid "(...)"
+msgstr ""
+
+#. 24EqX
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "UNIQUE(...)"
+msgstr ""
+
+#. oV47W
+#: func_unique.xhp
+msgctxt ""
+"func_unique.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/UNIQUE\">UNIQUE wiki page</link>."
+msgstr ""
+
 #. w86Dm
 #: func_value.xhp
 msgctxt ""
@@ -70495,6 +70783,357 @@ msgctxt ""
 msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\">WORKDAY wiki page</link>."
 msgstr ""
 
+#. SHsJ2
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"tit\n"
+"help.text"
+msgid "XLOOKUP Function"
+msgstr ""
+
+#. EFZfF
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>XLOOKUP function</bookmark_value>"
+msgstr ""
+
+#. DDESR
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"hd_id821708279355736\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xlookup.xhp\">XLOOKUP</link></variable>"
+msgstr ""
+
+#. yC7FC
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id581708279355738\n"
+"help.text"
+msgid "Searches for a value in an array and returns a reference to a cell or range of cells."
+msgstr ""
+
+#. xMTVW
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id631708282151776\n"
+"help.text"
+msgid "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>.  XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets."
+msgstr ""
+
+#. VESoP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "XLOOKUP(Lookup; Array; Return [; NotFound; MatchType; SearchMode ] )"
+msgstr ""
+
+#. 3zUXb
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id861708281340704\n"
+"help.text"
+msgid "<emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>."
+msgstr ""
+
+#. qUjAU
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id831708281625340\n"
+"help.text"
+msgid "<emph>Array</emph>: is the reference of the array or range to search."
+msgstr ""
+
+#. nWhEP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id241708281629922\n"
+"help.text"
+msgid "<emph>Return</emph>: is the reference of the array or range to return."
+msgstr ""
+
+#. 2LnvD
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id821708357634624\n"
+"help.text"
+msgid "If <emph>Return</emph> is an array of values, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>."
+msgstr ""
+
+#. 3fY6K
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id271708281637035\n"
+"help.text"
+msgid "<emph>NotFound</emph>: a text to return if the <emph>Lookup</emph> value is not found. If a valid match is not found, and <emph>NotFound</emph> is omitted, returns #N/A."
+msgstr ""
+
+#. hBDsh
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id121708281643207\n"
+"help.text"
+msgid "<emph>MatchType</emph>: Specify the match type:"
+msgstr ""
+
+#. aCZbP
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id111708281542144\n"
+"help.text"
+msgid "<emph>0</emph> - Exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return #N/A."
+msgstr ""
+
+#. w5rBH
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id851708281548335\n"
+"help.text"
+msgid "<emph>-1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item."
+msgstr ""
+
+#. zQiND
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id801708281553430\n"
+"help.text"
+msgid "<emph>1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next larger item."
+msgstr ""
+
+#. 4Jxvx
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id881708281558005\n"
+"help.text"
+msgid "<emph>2</emph> - A <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meaning."
+msgstr ""
+
+#. CxCof
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id871708281607313\n"
+"help.text"
+msgid "<emph>SearchMode</emph>: Specify the search mode to use:"
+msgstr ""
+
+#. Lc3bp
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id281708281579757\n"
+"help.text"
+msgid "<emph>1</emph>: - Search starting at the first item (default)."
+msgstr ""
+
+#. HVoEm
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id251708281584285\n"
+"help.text"
+msgid "<emph>-1</emph> - Reverse search starting at the last item."
+msgstr ""
+
+#. CFAD4
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id191708281589997\n"
+"help.text"
+msgid "<emph>2</emph> - Binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned."
+msgstr ""
+
+#. mAGCX
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id561708281595885\n"
+"help.text"
+msgid "<emph>-2</emph> - Binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned."
+msgstr ""
+
+#. vD6hn
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id961708354814163\n"
+"help.text"
+msgid "The table below contains a glossary for translators:"
+msgstr ""
+
+#. MSv55
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id781708353695722\n"
+"help.text"
+msgid "<emph>English</emph>"
+msgstr ""
+
+#. 5G7WA
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id641708353695723\n"
+"help.text"
+msgid "<emph>French</emph>"
+msgstr ""
+
+#. GRDeG
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id671708353695724\n"
+"help.text"
+msgid "<emph>Italian</emph>"
+msgstr ""
+
+#. JfbWn
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id331708353781503\n"
+"help.text"
+msgid "<emph>Japanese</emph>"
+msgstr ""
+
+#. CmUw2
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id31708356677157\n"
+"help.text"
+msgid "<input>={XLOOKUP(\"New\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Nouveau\",\"Nuovo\",\"新しい\"}."
+msgstr ""
+
+#. Z9pX4
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id671708356683379\n"
+"help.text"
+msgid "<input>={XLOOKUP(\"Reload\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Missing\",\"Missing\",\"Missing\"}."
+msgstr ""
+
+#. SzUpN
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XLOOKUP\">XLOOKUP wiki page</link>."
+msgstr ""
+
+#. z6i4f
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"tit\n"
+"help.text"
+msgid "XMATCH Function"
+msgstr ""
+
+#. Q8WY3
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"bm_id361708283183878\n"
+"help.text"
+msgid "<bookmark_value>XMATCH function</bookmark_value>"
+msgstr ""
+
+#. Y5Xci
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"hd_id821708279355736\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xmatch.xhp\">XMATCH</link></variable>"
+msgstr ""
+
+#. B9dyV
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id581708279355738\n"
+"help.text"
+msgid "Searches for a value in an array or range of cells and returns the relative position of the item."
+msgstr ""
+
+#. MFVXB
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id211708281649651\n"
+"help.text"
+msgid "XMATCH(Lookup; Array [; MatchType; SearchMode ] )"
+msgstr ""
+
+#. NA2BM
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id861708281340704\n"
+"help.text"
+msgid "<emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>."
+msgstr ""
+
+#. BuCGn
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id831708281625340\n"
+"help.text"
+msgid "<emph>Array</emph>: is the reference of the array or range to search."
+msgstr ""
+
+#. EorAV
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id391708364611193\n"
+"help.text"
+msgid "XMATCH outperforms function MATCH as it allows searches according to the search mode."
+msgstr ""
+
+#. yRpQy
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id31708356677157\n"
+"help.text"
+msgid "<input>=XMATCH(\"Save\", A2:A4, 0, 1)</input> returns 2, the second line of the A2:A4 range."
+msgstr ""
+
+#. 2AAX5
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id701677016751508\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XMATCH\">XMATCH wiki page</link>."
+msgstr ""
+
 #. dABAX
 #: func_year.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/scalc/04.po b/source/lo/helpcontent2/source/text/scalc/04.po
index f32637b27e5..015d0d99150 100644
--- a/source/lo/helpcontent2/source/text/scalc/04.po
+++ b/source/lo/helpcontent2/source/text/scalc/04.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: 2023-03-02 11:50+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2017-10-04 11:27+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -718,13 +718,13 @@ msgctxt ""
 msgid "Displays or hides the formulas instead of the values in all cells."
 msgstr ""
 
-#. WBh3X
+#. NsDbn
 #: 01020000.xhp
 msgctxt ""
 "01020000.xhp\n"
 "par_id8070314\n"
 "help.text"
-msgid "The ` key is located next to the \"1\" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the \"View\" category and the \"Toggle Formula\" function."
+msgid "The ` key is located next to the \"1\" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose <emph>Tools - Customize</emph>, click the <emph>Keyboard</emph> tab. Select the \"View\" category and the \"Show Formula\" function."
 msgstr ""
 
 #. De3Yx
diff --git a/source/lo/helpcontent2/source/text/scalc/guide.po b/source/lo/helpcontent2/source/text/scalc/guide.po
index fa50bfff6b8..1fe33851266 100644
--- a/source/lo/helpcontent2/source/text/scalc/guide.po
+++ b/source/lo/helpcontent2/source/text/scalc/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2023-12-15 12:24+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13921,22 +13921,22 @@ msgctxt ""
 msgid "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS."
 msgstr ""
 
-#. oUwuB
+#. ckhx6
 #: wildcards.xhp
 msgctxt ""
 "wildcards.xhp\n"
 "par_id941629158811325\n"
 "help.text"
-msgid "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP."
+msgid "<emph>Lookup functions:</emph> XLOOKUP, HLOOKUP, LOOKUP and VLOOKUP."
 msgstr ""
 
-#. Ka6SK
+#. yFZYE
 #: wildcards.xhp
 msgctxt ""
 "wildcards.xhp\n"
 "par_id41629158919808\n"
 "help.text"
-msgid "<emph>Other functions:</emph> MATCH and SEARCH."
+msgid "<emph>Other functions:</emph> XMATCH, MATCH and SEARCH."
 msgstr ""
 
 #. 2ZGuQ
diff --git a/source/lo/helpcontent2/source/text/sdraw/01.po b/source/lo/helpcontent2/source/text/sdraw/01.po
index aae59ef7037..cbcc6045115 100644
--- a/source/lo/helpcontent2/source/text/sdraw/01.po
+++ b/source/lo/helpcontent2/source/text/sdraw/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: 2023-12-21 13:21+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2017-05-10 03:58+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -466,6 +466,51 @@ msgctxt ""
 msgid "Color"
 msgstr ""
 
+#. udmbF
+#: TextAutoFitToSize.xhp
+msgctxt ""
+"TextAutoFitToSize.xhp\n"
+"tit\n"
+"help.text"
+msgid "Shrink Text on Overflow"
+msgstr ""
+
+#. 3mHnB
+#: TextAutoFitToSize.xhp
+msgctxt ""
+"TextAutoFitToSize.xhp\n"
+"bm_id911708794145655\n"
+"help.text"
+msgid "<bookmark_value>shrink font;in text box</bookmark_value><bookmark_value>reduce font;to fit box box</bookmark_value>"
+msgstr ""
+
+#. AgP8a
+#: TextAutoFitToSize.xhp
+msgctxt ""
+"TextAutoFitToSize.xhp\n"
+"hd_id141708794017212\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/sdraw/01/TextAutoFitToSize.xhp\">Shrink Text on Overflow</link></variable>"
+msgstr ""
+
+#. JA2kz
+#: TextAutoFitToSize.xhp
+msgctxt ""
+"TextAutoFitToSize.xhp\n"
+"par_id761708794017214\n"
+"help.text"
+msgid "Specifies whether content is reduced in size to fit within a text box. Shrinking means that the font size of the content is decreased to fit the content into a text box. The attribute has no effect on boxes where the box content already fits into the box."
+msgstr ""
+
+#. J3aWQ
+#: TextAutoFitToSize.xhp
+msgctxt ""
+"TextAutoFitToSize.xhp\n"
+"par_id971708794433499\n"
+"help.text"
+msgid "Select a text box and choose <menuitem>Shrink text on overflow</menuitem>."
+msgstr ""
+
 #. eGs9G
 #: consolidatetext.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/shared.po b/source/lo/helpcontent2/source/text/shared.po
index 8848edc869d..c38ad1291c0 100644
--- a/source/lo/helpcontent2/source/text/shared.po
+++ b/source/lo/helpcontent2/source/text/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-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -34,13 +34,13 @@ msgctxt ""
 msgid "<bookmark_value>Find toolbar</bookmark_value>"
 msgstr ""
 
-#. JS8DE
+#. DmZRA
 #: find_toolbar.xhp
 msgctxt ""
 "find_toolbar.xhp\n"
 "hd_id701641581066778\n"
 "help.text"
-msgid "<link href=\"/text/shared/find_toolbar.xhp\">Find Bar</link>"
+msgid "<link href=\"text/shared/find_toolbar.xhp\">Find Bar</link>"
 msgstr ""
 
 #. X55wK
@@ -52,13 +52,22 @@ msgctxt ""
 msgid "The <menuitem>Find</menuitem> toolbar can be used to quickly search the contents of %PRODUCTNAME documents."
 msgstr ""
 
-#. wMCEY
+#. AotDk
 #: find_toolbar.xhp
 msgctxt ""
 "find_toolbar.xhp\n"
-"par_id211641581251728\n"
+"par_id531708714506570\n"
 "help.text"
-msgid "Use the shortcut <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + F</keycode> to quickly open the <menuitem>Find</menuitem> toolbar."
+msgid "Choose <menuitem>View - Toolbars - Find</menuitem>."
+msgstr ""
+
+#. 7pJae
+#: find_toolbar.xhp
+msgctxt ""
+"find_toolbar.xhp\n"
+"par_id711708714839012\n"
+"help.text"
+msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode> + F</keycode>"
 msgstr ""
 
 #. DCYmX
@@ -106,13 +115,13 @@ msgctxt ""
 msgid "<image src=\"cmd/lc_upsearch.svg\" id=\"img_id171642423451259\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id261642423451259\">Find Previous Icon</alt></image>"
 msgstr ""
 
-#. Tu26F
+#. 5mDvY
 #: find_toolbar.xhp
 msgctxt ""
 "find_toolbar.xhp\n"
 "par_id351642423451259\n"
 "help.text"
-msgid "Find Previous Icon"
+msgid "Find previous match"
 msgstr ""
 
 #. CCfcg
@@ -142,13 +151,13 @@ msgctxt ""
 msgid "<image src=\"cmd/lc_downsearch.svg\" id=\"img_id111642423456841\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id111642423456841\">Find Next Icon</alt></image>"
 msgstr ""
 
-#. kuiD9
+#. ByGqu
 #: find_toolbar.xhp
 msgctxt ""
 "find_toolbar.xhp\n"
 "par_id111642423456842\n"
 "help.text"
-msgid "Find Next Icon"
+msgid "Find next match"
 msgstr ""
 
 #. 5nZqX
@@ -232,13 +241,13 @@ msgctxt ""
 msgid "<image src=\"cmd/lc_searchdialog.svg\" id=\"img_id171641582176913\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id171641582176913\">Find and Replace Icon</alt></image>"
 msgstr ""
 
-#. BUQcH
+#. G9X29
 #: find_toolbar.xhp
 msgctxt ""
 "find_toolbar.xhp\n"
 "par_id171641582176943\n"
 "help.text"
-msgid "Find and Replace Icon"
+msgid "Find and Replace"
 msgstr ""
 
 #. DBz3U
diff --git a/source/lo/helpcontent2/source/text/shared/00.po b/source/lo/helpcontent2/source/text/shared/00.po
index b30250d996f..27a562ce72e 100644
--- a/source/lo/helpcontent2/source/text/shared/00.po
+++ b/source/lo/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-14 13:07+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -10699,13 +10699,49 @@ msgctxt ""
 msgid "<variable id=\"chineseedit\">Choose <emph>Tools - Language - Chinese Conversion</emph> - <emph>Edit terms</emph> button. Asian language support must be enabled.</variable>"
 msgstr ""
 
-#. VYGst
+#. e5sDL
 #: 00000406.xhp
 msgctxt ""
 "00000406.xhp\n"
 "par_id3150771\n"
 "help.text"
-msgid "<variable id=\"zoptionen\">Choose <emph>Tools - Spelling</emph>, then click <emph>Options</emph>.</variable>"
+msgid "Choose <emph>Tools - Spelling</emph>, then click <emph>Options</emph>."
+msgstr ""
+
+#. DETef
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id391708526628229\n"
+"help.text"
+msgid "Choose <menuitem>Spelling</menuitem> and click <menuitem>Options</menuitem>."
+msgstr ""
+
+#. WiCTm
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id771708526275302\n"
+"help.text"
+msgid "Choose <menuitem>Review - Spelling</menuitem> and click <menuitem>Options</menuitem>."
+msgstr ""
+
+#. mEqET
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id691708526281045\n"
+"help.text"
+msgid "On the <menuitem>Review</menuitem> menu of the <menuitem>Review</menuitem> tab, choose <menuitem>Spelling</menuitem> and click <menuitem>Options</menuitem>."
+msgstr ""
+
+#. VGTLt
+#: 00000406.xhp
+msgctxt ""
+"00000406.xhp\n"
+"par_id461708526619428\n"
+"help.text"
+msgid "<keycode>F7</keycode> and click <menuitem>Options</menuitem>."
 msgstr ""
 
 #. CDDQ2
diff --git a/source/lo/helpcontent2/source/text/shared/optionen.po b/source/lo/helpcontent2/source/text/shared/optionen.po
index 168bf0ec741..2bfa832455b 100644
--- a/source/lo/helpcontent2/source/text/shared/optionen.po
+++ b/source/lo/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-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -8755,13 +8755,13 @@ msgctxt ""
 msgid "Add spacing between paragraphs and tables"
 msgstr ""
 
-#. FgZcx
+#. QDDmg
 #: 01041000.xhp
 msgctxt ""
 "01041000.xhp\n"
 "par_idN10981\n"
 "help.text"
-msgid "Add paragraph and table spacing at tops of pages"
+msgid "Add paragraph and table spacing at top of first page and page breaks"
 msgstr ""
 
 #. JocxW
@@ -14020,13 +14020,13 @@ msgctxt ""
 msgid "A change in <emph>Default currency</emph> field will be transmitted to all open documents and will lead to corresponding changes in the dialogs and icons that control the currency format in these documents."
 msgstr ""
 
-#. 6QxdB
+#. HVffA
 #: 01140000.xhp
 msgctxt ""
 "01140000.xhp\n"
 "par_idN106DE\n"
 "help.text"
-msgid "Decimal separator key - Same as locale setting"
+msgid "Decimal key on the numpad - Same as locale setting"
 msgstr ""
 
 #. zYFjQ
@@ -17710,13 +17710,13 @@ msgctxt ""
 msgid "Remove personal information on saving"
 msgstr ""
 
-#. tMGtt
+#. 2QaQj
 #: securityoptionsdialog.xhp
 msgctxt ""
 "securityoptionsdialog.xhp\n"
 "par_idN10667\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/securityoptionsdialog/removepersonal\">Select to always remove user data from file properties, comments and tracked changes. The names of authors in comments and changes will be replaced by generic values as \"Author1\", \"Author2\" and so forth. Time values will also be reset to a single standard value. If this option is not selected, you can still remove the personal information for the current document with the <emph>Reset Properties</emph> button on <emph>File - Properties - General</emph>.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/securityoptionsdialog/removepersonal\">Select to remove user data from file properties, comments and tracked changes when saving. The names of authors in comments and changes will be replaced by generic values as \"Author1\", \"Author2\" and so forth. Time values will also be reset to a single standard value. No personal metadata will be exported.</ahelp>"
 msgstr ""
 
 #. HJEQF
diff --git a/source/lo/helpcontent2/source/text/simpress/01.po b/source/lo/helpcontent2/source/text/simpress/01.po
index d7f2bfcf9f8..aa6b7f18c58 100644
--- a/source/lo/helpcontent2/source/text/simpress/01.po
+++ b/source/lo/helpcontent2/source/text/simpress/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-02-28 17:20+0100\n"
 "PO-Revision-Date: 2018-09-03 13:11+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3382,13 +3382,13 @@ msgctxt ""
 msgid "Graphic Styles"
 msgstr ""
 
-#. mDJCH
+#. fCC3A
 #: 05100000.xhp
 msgctxt ""
 "05100000.xhp\n"
 "par_id3148488\n"
 "help.text"
-msgid "<ahelp hid=\".uno:ParaStyle\">Show styles for formatting graphical elements, including text objects.</ahelp>"
+msgid "Show styles for formatting graphical elements, including text objects."
 msgstr ""
 
 #. KGFbD
diff --git a/source/lo/helpcontent2/source/text/simpress/02.po b/source/lo/helpcontent2/source/text/simpress/02.po
index 3a25dad024e..39593c3a321 100644
--- a/source/lo/helpcontent2/source/text/simpress/02.po
+++ b/source/lo/helpcontent2/source/text/simpress/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-02-02 00:04+0100\n"
+"POT-Creation-Date: 2024-02-28 17:20+0100\n"
 "PO-Revision-Date: 2017-10-04 11:27+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3031,40 +3031,40 @@ msgctxt ""
 msgid "To rotate a 3D object around any of its three axes, click to select the object, and then click again to display its rotation handles. Drag a handle in the direction you want to rotate the object."
 msgstr ""
 
-#. 3e3HF
+#. D7D6B
 #: 10090000.xhp
 msgctxt ""
 "10090000.xhp\n"
 "hd_id3153936\n"
 "help.text"
-msgid "Cube"
+msgid "Cuboid"
 msgstr ""
 
-#. ouf9p
+#. AxaDK
 #: 10090000.xhp
 msgctxt ""
 "10090000.xhp\n"
 "par_id3145593\n"
 "help.text"
-msgid "<ahelp hid=\".uno:Cube\">Draws a filled cube where you drag in the slide. To draw a 3D rectangle, hold down <keycode>Shift</keycode> while you drag.</ahelp>"
+msgid "<ahelp hid=\".uno:Cube\">Draws a filled cuboid where you drag in the slide. To draw a 3D rectangle, hold down <keycode>Shift</keycode> while you drag.</ahelp>"
 msgstr ""
 
-#. DG2Aa
+#. qSAsy
 #: 10090000.xhp
 msgctxt ""
 "10090000.xhp\n"
 "par_id3149877\n"
 "help.text"
-msgid "<image id=\"img_id3149884\" src=\"cmd/lc_cube.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149884\">Icon Cube</alt></image>"
+msgid "<image id=\"img_id3149884\" src=\"cmd/lc_cube.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149884\">Icon Cuboid</alt></image>"
 msgstr ""
 
-#. AzrbG
+#. uyQrY
 #: 10090000.xhp
 msgctxt ""
 "10090000.xhp\n"
 "par_id3155440\n"
 "help.text"
-msgid "Cube"
+msgid "Cuboid"
 msgstr ""
 
 #. RUv4B