update translations for master / 24.8.0 beta1

and force-fix errors using pocheck

Change-Id: Icb1e64bed6621dec76e972ecaf58197d4c0f1d6e

1 files changed, 71 insertions, 15 deletions

diff --git a/source/st/sc/messages.po b/source/st/sc/messages.po
index 1a3d56dcf53..3dc680c1a35 100644
--- a/source/st/sc/messages.po
+++ b/source/st/sc/messages.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-03 12:06+0200\n"
+"POT-Creation-Date: 2024-06-06 13:17+0200\n"
 "PO-Revision-Date: 2018-11-12 12:16+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -14815,23 +14815,30 @@ msgctxt "SC_OPCODE_X_LOOKUP"
 msgid "Match Mode"
 msgstr ""
 
-#. d2Wkh
+#. afJBG
 #: sc/inc/scfuncs.hrc:3393
 msgctxt "SC_OPCODE_X_LOOKUP"
-msgid "0, -1, 1 or 2 "
+msgid ""
+"0 - Exact match. Will return #N/A if no match. (default).\n"
+"-1 - Exact match or the next smaller item.\n"
+"1 - Exact match or the next larger item.\n"
+"2 - Wildcard or regular expression match."
 msgstr ""
 
 #. EvSiP
-#. TODO : add explanation of values
 #: sc/inc/scfuncs.hrc:3394
 msgctxt "SC_OPCODE_X_LOOKUP"
 msgid "Search Mode"
 msgstr ""
 
-#. idJvP
+#. aUEgE
 #: sc/inc/scfuncs.hrc:3395
 msgctxt "SC_OPCODE_X_LOOKUP"
-msgid "1, -1, 2 or -2 "
+msgid ""
+"1 - Search from the first value (default).\n"
+"-1 - Search from the last value (reverse).\n"
+"2 - Binary search values sorted in ascending order.\n"
+"-2 - Binary search values sorted in descending order."
 msgstr ""
 
 #. KZapz
@@ -15045,23 +15052,30 @@ msgctxt "SC_OPCODE_X_MATCH"
 msgid "Match Mode"
 msgstr ""
 
-#. t6qx7
+#. 2oEFA
 #: sc/inc/scfuncs.hrc:3455
 msgctxt "SC_OPCODE_X_MATCH"
-msgid "0, -1, 1 or 2 "
+msgid ""
+"0 - Exact match. Will return #N/A if no match. (default).\n"
+"-1 - Exact match or the next smaller item.\n"
+"1 - Exact match or the next larger item.\n"
+"2 - Wildcard or regular expression match."
 msgstr ""
 
 #. UtoXD
-#. TODO : add explanation of values
 #: sc/inc/scfuncs.hrc:3456
 msgctxt "SC_OPCODE_X_MATCH"
 msgid "Search Mode"
 msgstr ""
 
-#. uZCBe
+#. J9uEM
 #: sc/inc/scfuncs.hrc:3457
 msgctxt "SC_OPCODE_X_MATCH"
-msgid "1, -1, 2 or -2 "
+msgid ""
+"1 - Search from the first value (default).\n"
+"-1 - Search from the last value (reverse).\n"
+"2 - Binary search values sorted in ascending order.\n"
+"-2 - Binary search values sorted in descending order."
 msgstr ""
 
 #. XJ4FS
@@ -17694,10 +17708,10 @@ msgctxt "SC_OPCODE_RANDARRAY"
 msgid "Integers"
 msgstr ""
 
-#. UiLts
+#. rMwVv
 #: sc/inc/scfuncs.hrc:4251
 msgctxt "SC_OPCODE_RANDARRAY"
-msgid "Return whole numbers (TRUE) or decimal values (FALSE)."
+msgid "Return integer (TRUE) or decimal (FALSE) values."
 msgstr ""
 
 #. NJR3E
@@ -17742,6 +17756,48 @@ msgctxt "SC_OPCODE_UNIQUE"
 msgid "Logical value that defines what values are considered unique: TRUE - returns values that occur only once. FALSE or omitted (default) - returns all distinct (different) values in the range or array."
 msgstr ""
 
+#. axamT
+#: sc/inc/scfuncs.hrc:4269
+msgctxt "SC_OPCODE_LET"
+msgid "The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function."
+msgstr ""
+
+#. 6DDAi
+#: sc/inc/scfuncs.hrc:4270
+msgctxt "SC_OPCODE_LET"
+msgid "Name 1"
+msgstr ""
+
+#. a7LQR
+#: sc/inc/scfuncs.hrc:4271
+msgctxt "SC_OPCODE_LET"
+msgid "The first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax."
+msgstr ""
+
+#. KsyBM
+#: sc/inc/scfuncs.hrc:4272
+msgctxt "SC_OPCODE_LET"
+msgid "Name value "
+msgstr ""
+
+#. Dn2DE
+#: sc/inc/scfuncs.hrc:4273
+msgctxt "SC_OPCODE_LET"
+msgid "Name value 1, Name value 2,... The value or calculation to assign to Name."
+msgstr ""
+
+#. CHAMD
+#: sc/inc/scfuncs.hrc:4274
+msgctxt "SC_OPCODE_LET"
+msgid "Calculation or Name "
+msgstr ""
+
+#. tFMkP
+#: sc/inc/scfuncs.hrc:4275
+msgctxt "SC_OPCODE_LET"
+msgid "A calculation that uses all names within the LET function. This must be the last argument in the LET function. Or a second Name to assign to a second Name value. If a second Name is specified, Name value 2 and Calculation or Name 3 become required."
+msgstr ""
+
 #. pDDme
 #: sc/inc/scstyles.hrc:29
 #, fuzzy
@@ -35150,10 +35206,10 @@ msgctxt "validationcriteriapage|liststore1"
 msgid "All values"
 msgstr ""
 
-#. B9wqg
+#. HbA4D
 #: sc/uiconfig/scalc/ui/validationcriteriapage.ui:48
 msgctxt "validationcriteriapage|liststore1"
-msgid "Whole Numbers"
+msgid "Integer"
 msgstr ""
 
 #. hCaRD