update translations for master / 24.8.0 beta1

and force-fix errors using pocheck

Change-Id: Icb1e64bed6621dec76e972ecaf58197d4c0f1d6e

1 files changed, 81 insertions, 25 deletions

diff --git a/source/pt-BR/sc/messages.po b/source/pt-BR/sc/messages.po
index 41ae5379c3c..f260863312a 100644
--- a/source/pt-BR/sc/messages.po
+++ b/source/pt-BR/sc/messages.po
@@ -3,8 +3,8 @@ 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"
-"PO-Revision-Date: 2024-05-25 01:45+0000\n"
+"POT-Creation-Date: 2024-06-06 13:17+0200\n"
+"PO-Revision-Date: 2024-06-03 15:26+0000\n"
 "Last-Translator: Olivier Hallot <olivier.hallot@libreoffice.org>\n"
 "Language-Team: Portuguese (Brazil) <https://translations.documentfoundation.org/projects/libo_ui-master/scmessages/pt_BR/>\n"
 "Language: pt-BR\n"
@@ -14284,24 +14284,31 @@ msgctxt "SC_OPCODE_X_LOOKUP"
 msgid "Match Mode"
 msgstr "Modo de conferência"
 
-#. d2Wkh
+#. afJBG
 #: sc/inc/scfuncs.hrc:3393
 msgctxt "SC_OPCODE_X_LOOKUP"
-msgid "0, -1, 1 or 2 "
-msgstr "0, -1, 1 ou 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 "Modo de pesquisa"
 
-#. idJvP
+#. aUEgE
 #: sc/inc/scfuncs.hrc:3395
 msgctxt "SC_OPCODE_X_LOOKUP"
-msgid "1, -1, 2 or -2 "
-msgstr "1, -1, 2 ou -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
 #: sc/inc/scfuncs.hrc:3401
@@ -14507,24 +14514,31 @@ msgctxt "SC_OPCODE_X_MATCH"
 msgid "Match Mode"
 msgstr "Tipo de correspondência"
 
-#. t6qx7
+#. 2oEFA
 #: sc/inc/scfuncs.hrc:3455
 msgctxt "SC_OPCODE_X_MATCH"
-msgid "0, -1, 1 or 2 "
-msgstr "0, -1, 1 ou 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 "Modo de pesquisa"
 
-#. uZCBe
+#. J9uEM
 #: sc/inc/scfuncs.hrc:3457
 msgctxt "SC_OPCODE_X_MATCH"
-msgid "1, -1, 2 or -2 "
-msgstr "1, -1, 2 ou -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
 #: sc/inc/scfuncs.hrc:3463
@@ -17053,11 +17067,11 @@ msgctxt "SC_OPCODE_RANDARRAY"
 msgid "Integers"
 msgstr "Inteiros"
 
-#. UiLts
+#. rMwVv
 #: sc/inc/scfuncs.hrc:4251
 msgctxt "SC_OPCODE_RANDARRAY"
-msgid "Return whole numbers (TRUE) or decimal values (FALSE)."
-msgstr "Retorna números inteiros (VERDADEIRO) ou números decimais (FALSO),"
+msgid "Return integer (TRUE) or decimal (FALSE) values."
+msgstr ""
 
 #. NJR3E
 #: sc/inc/scfuncs.hrc:4257
@@ -17101,6 +17115,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 "Valor lógico que define a unicidade: VERDADEIRO – retorna os valores que ocorrem pelo menos uma vez. FALSO ou omitido (padrão) – retorna todos os valores distintos (não duplicados) do intervalo ou matriz."
 
+#. 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
 msgctxt "RID_CELLSTYLEFAMILY"
@@ -23178,7 +23234,7 @@ msgstr "_Padrão"
 #: sc/uiconfig/scalc/ui/drawtemplatedialog.ui:126
 msgctxt "drawtemplatedialog|organizer"
 msgid "General"
-msgstr ""
+msgstr "Geral"
 
 #. qSfk8
 #: sc/uiconfig/scalc/ui/drawtemplatedialog.ui:149
@@ -28125,7 +28181,7 @@ msgstr "Estilo de página"
 #: sc/uiconfig/scalc/ui/pagetemplatedialog.ui:127
 msgctxt "pagetemplatedialog|organizer"
 msgid "General"
-msgstr ""
+msgstr "Geral"
 
 #. CbW7A
 #: sc/uiconfig/scalc/ui/pagetemplatedialog.ui:150
@@ -28203,7 +28259,7 @@ msgstr "Estilo de célula"
 #: sc/uiconfig/scalc/ui/paratemplatedialog.ui:126
 msgctxt "paratemplatedialog|organizer"
 msgid "General"
-msgstr ""
+msgstr "Geral"
 
 #. asnEd
 #: sc/uiconfig/scalc/ui/paratemplatedialog.ui:149
@@ -33989,11 +34045,11 @@ msgctxt "validationcriteriapage|liststore1"
 msgid "All values"
 msgstr "Todos os valores"
 
-#. B9wqg
+#. HbA4D
 #: sc/uiconfig/scalc/ui/validationcriteriapage.ui:48
 msgctxt "validationcriteriapage|liststore1"
-msgid "Whole Numbers"
-msgstr "Números inteiros"
+msgid "Integer"
+msgstr ""
 
 #. hCaRD
 #: sc/uiconfig/scalc/ui/validationcriteriapage.ui:49