update translations for 24.8.0 rc1/master

and force-fix errors using pocheck

Change-Id: I696fda5336e4c075c43ebbdddc1974e5f1c6fe65

2 files changed, 35 insertions, 26 deletions

diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index af8f90dc8ce..44d91290ebd 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/01.po
+++ b/source/en-GB/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-06-20 13:14+0200\n"
+"POT-Creation-Date: 2024-07-08 17:35+0200\n"
 "PO-Revision-Date: 2022-08-22 14:04+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: English (United Kingdom) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/en_GB/>\n"
@@ -57166,15 +57166,6 @@ msgctxt ""
 msgid "This function is always recalculated whenever a recalculation occurs."
 msgstr ""
 
-#. GC9sp
-#: ful_func.xhp
-msgctxt ""
-"ful_func.xhp\n"
-"par_id711715953325962\n"
-"help.text"
-msgid "The function is always <emph>case insensitive</emph>, independent from the setting of <emph>Case sensitive</emph> checkbox in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\"><menuitem>%PRODUCTNAME Calc - Calculate</menuitem></link>. You can however, use the mode modifier <emph>(?-i)</emph> in <link href=\"text/shared/01/02100001.xhp\">regular expressions</link> to force search for a case-sensitive match."
-msgstr ""
-
 #. 8DbP2
 #: func_aggregate.xhp
 msgctxt ""
@@ -71836,13 +71827,22 @@ msgctxt ""
 msgid "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item."
 msgstr ""
 
-#. DEt3s
+#. JJ3M2
 #: 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 meanings, or a match using <link href=\"text/shared/01/02100001.xhp\">regular expressions</link>."
+msgid "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings."
+msgstr ""
+
+#. GAYga
+#: func_xlookup.xhp
+msgctxt ""
+"func_xlookup.xhp\n"
+"par_id111718970605394\n"
+"help.text"
+msgid "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match."
 msgstr ""
 
 #. EqTBc
@@ -71890,13 +71890,13 @@ msgctxt ""
 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 ""
 
-#. jo6AY
+#. Ysd77
 #: func_xlookup.xhp
 msgctxt ""
 "func_xlookup.xhp\n"
 "par_id551718627629229\n"
 "help.text"
-msgid "<emph>MatchType</emph> value 2 cannot be combined with binary search (<emph>SearchMode</emph> value <emph>2</emph> or <emph>-2</emph>)."
+msgid "<emph>MatchType</emph> values 2 and 3 cannot be combined with binary search (<emph>SearchMode</emph> value <emph>2</emph> or <emph>-2</emph>)."
 msgstr ""
 
 #. fHQrZ
@@ -72052,13 +72052,22 @@ msgctxt ""
 msgid "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item."
 msgstr ""
 
-#. y5cx9
+#. WUvAp
 #: func_xmatch.xhp
 msgctxt ""
 "func_xmatch.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 meanings, or a match using <link href=\"text/shared/01/02100001.xhp\">regular expressions</link>."
+msgid "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings."
+msgstr ""
+
+#. EQfjm
+#: func_xmatch.xhp
+msgctxt ""
+"func_xmatch.xhp\n"
+"par_id111718970605394\n"
+"help.text"
+msgid "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match."
 msgstr ""
 
 #. WMXaP
diff --git a/source/en-GB/helpcontent2/source/text/shared/01.po b/source/en-GB/helpcontent2/source/text/shared/01.po
index ea2294f661c..55fef5a6bfa 100644
--- a/source/en-GB/helpcontent2/source/text/shared/01.po
+++ b/source/en-GB/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2024-06-25 12:28+0200\n"
+"POT-Creation-Date: 2024-07-08 17:35+0200\n"
 "PO-Revision-Date: 2022-06-15 20:39+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: English (United Kingdom) <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/en_GB/>\n"
@@ -8791,6 +8791,15 @@ msgctxt ""
 msgid "<variable id=\"02100001\"><link href=\"text/shared/01/02100001.xhp\">List of Regular Expressions</link></variable>"
 msgstr "<variable id=\"02100001\"><link href=\"text/shared/01/02100001.xhp\">List of Regular Expressions</link></variable>"
 
+#. Fsw8C
+#: 02100001.xhp
+msgctxt ""
+"02100001.xhp\n"
+"par_id5311440\n"
+"help.text"
+msgid "For a full list of supported metacharacters and syntax, see <link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html#regular-expression-metacharacters\">ICU Regular Expressions documentation</link>"
+msgstr ""
+
 #. cMTUp
 #: 02100001.xhp
 msgctxt ""
@@ -9259,15 +9268,6 @@ msgctxt ""
 msgid "Represents an uppercase character if <emph>Match case</emph> is selected in <emph>Options</emph>."
 msgstr "Represents an upper-case character if <emph>Match case</emph> is selected in <emph>Options.</emph>."
 
-#. Fsw8C
-#: 02100001.xhp
-msgctxt ""
-"02100001.xhp\n"
-"par_id5311440\n"
-"help.text"
-msgid "For a full list of supported metacharacters and syntax, see <link href=\"https://unicode-org.github.io/icu/userguide/strings/regexp.html#regular-expression-metacharacters\">ICU Regular Expressions documentation</link>"
-msgstr ""
-
 #. HvC9Q
 #: 02100001.xhp
 msgctxt ""