summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--koffice-i18n-bg/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-ca/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-cs/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-cy/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-da/messages/koffice/kspread.po70
-rw-r--r--koffice-i18n-de/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-el/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-en_GB/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-es/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-et/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-eu/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-fa/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-fi/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-fr/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-ga/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-gl/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-hu/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-it/messages/koffice/kspread.po71
-rw-r--r--koffice-i18n-ja/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-lv/messages/koffice/kspread.po66
-rw-r--r--koffice-i18n-ms/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-nb/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-ne/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-nl/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-pl/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-pt/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-pt_BR/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-ru/messages/koffice/kspread.po72
-rw-r--r--koffice-i18n-sk/messages/koffice/kspread.po68
-rw-r--r--koffice-i18n-sl/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-sr/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-sr@Latn/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-sv/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-tr/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-uk/messages/koffice/kspread.po63
-rw-r--r--koffice-i18n-zh_CN/messages/koffice/kspread.po64
-rw-r--r--koffice-i18n-zh_TW/messages/koffice/kspread.po64
37 files changed, 2267 insertions, 127 deletions
diff --git a/koffice-i18n-bg/messages/koffice/kspread.po b/koffice-i18n-bg/messages/koffice/kspread.po
index 1bf770f8..6a457e53 100644
--- a/koffice-i18n-bg/messages/koffice/kspread.po
+++ b/koffice-i18n-bg/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-05-02 08:18+0000\n"
"Last-Translator: Zlatko Popov <zlatkopopov@fsa-bg.org>\n"
"Language-Team: Bulgarian <dict@linux.zonebg.com>\n"
@@ -545,6 +545,7 @@ msgid "Select columns:"
msgstr "Избор на колони:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Колона"
@@ -12923,7 +12924,7 @@ msgstr "COLUMNS(A1:C3) връща 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) връща 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Ред"
@@ -13029,7 +13030,8 @@ msgstr "ROWS(A1:C3) връща 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) връща 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Търсена стойност"
@@ -13074,6 +13076,62 @@ msgstr "LOOKUP(стойност; вектор за търсене; резулт
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) за A1 = 1, A2 = 2 връща стойността на B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "База данни"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Метод (опционално)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-ca/messages/koffice/kspread.po b/koffice-i18n-ca/messages/koffice/kspread.po
index 4c28834a..d1a979c8 100644
--- a/koffice-i18n-ca/messages/koffice/kspread.po
+++ b/koffice-i18n-ca/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-10-26 20:08+0200\n"
"Last-Translator: Antoni Bella Pérez <bella5@teleline.es>\n"
"Language-Team: Catalan <kde-i18n-ca@kde.org>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
msgstr "Seleccioneu les columnes:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Columna"
@@ -12972,7 +12973,7 @@ msgstr "COLUMNS(A1:C3) retorna 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) retorna 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Fila"
@@ -13079,7 +13080,8 @@ msgstr "ROWS(A1:C3) retorna 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) retorna 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valor superior"
@@ -13124,6 +13126,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) per a A1 = 1, A2 = 2 retorna el valor de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Base de dades"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Mètode (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-cs/messages/koffice/kspread.po b/koffice-i18n-cs/messages/koffice/kspread.po
index 6936eced..d864e259 100644
--- a/koffice-i18n-cs/messages/koffice/kspread.po
+++ b/koffice-i18n-cs/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2018-10-22 01:57+0000\n"
"Last-Translator: Slávek Banko <slavek.banko@axis.cz>\n"
"Language-Team: Czech <https://mirror.git.trinitydesktop.org/weblate/projects/"
@@ -559,6 +559,7 @@ msgid "Select columns:"
msgstr "Vybrat sloupce:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Sloupec"
@@ -12708,7 +12709,7 @@ msgstr "COLUMNS(A1:C3) vrací 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) vrací 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "Řádek"
@@ -12808,7 +12809,8 @@ msgstr "ROWS(A1:C3) vrací 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) vrací 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Vrchní hodnota"
@@ -12845,6 +12847,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Databáze"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metoda (volitelná)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-cy/messages/koffice/kspread.po b/koffice-i18n-cy/messages/koffice/kspread.po
index c0b94bac..84e692a8 100644
--- a/koffice-i18n-cy/messages/koffice/kspread.po
+++ b/koffice-i18n-cy/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2004-09-09 12:35+0100\n"
"Last-Translator: Kyfieithu <kyfieithu@dotmon.com>\n"
"Language-Team: Cymraeg <cy@li.org>\n"
@@ -555,6 +555,7 @@ msgid "Select columns:"
msgstr "Dewis colofnau:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Colofn"
@@ -12977,7 +12978,7 @@ msgstr "Mae COLUMNS(A1:C3) yn dychwelyd 3"
msgid "COLUMNS(D2) returns 1"
msgstr "Mae COLUMNS(D2) yn dychwelyd 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rhes"
@@ -13079,7 +13080,8 @@ msgstr "Mae ROWS(A1:C3) yn dychwelyd 3"
msgid "ROWS(D2) returns 1"
msgstr "Mae ROWS(D2) yn dychwelyd 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Gwerth Pen"
@@ -13116,6 +13118,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Cronfa Ddata"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Dull (dewisol)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-da/messages/koffice/kspread.po b/koffice-i18n-da/messages/koffice/kspread.po
index 1bcf600a..00b27c5a 100644
--- a/koffice-i18n-da/messages/koffice/kspread.po
+++ b/koffice-i18n-da/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-08-25 06:22-0400\n"
"Last-Translator: Erik Kjær Pedersen <erik@binghamton.edu>\n"
"Language-Team: Danish <dansk@klid.dk>\n"
@@ -545,6 +545,7 @@ msgid "Select columns:"
msgstr "Vælg søjler:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Søjle"
@@ -12931,7 +12932,7 @@ msgstr "COLUMNS(A1:C3) giver 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) giver 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Række"
@@ -13038,7 +13039,8 @@ msgstr "ROWS(A1:C3) giver 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) giver 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Opslagsværdi"
@@ -13083,6 +13085,62 @@ msgstr "LOOKUP(værdi; opslagsvektor; resultatvektor)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1,232; A1:A6; B1:B6) for A1 = 1, A2 = 2 giver værdien af B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metode (valgfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
@@ -16567,9 +16625,9 @@ msgid ""
"Right to Left, then the first column will be on the right and the others "
"added from right to left."
msgstr ""
-"Som standard er bladets første søjle er til venstre. Hvis du vælger "
-"Right to Left, er den første søjle til højre og de øvrige "
-"tilføjes fra højre mod venstre."
+"Som standard er bladets første søjle er til venstre. Hvis du vælger Right to "
+"Left, er den første søjle til højre og de øvrige tilføjes fra højre mod "
+"venstre."
#: dialogs/sheet_properties_base.ui:141
#, no-c-format
diff --git a/koffice-i18n-de/messages/koffice/kspread.po b/koffice-i18n-de/messages/koffice/kspread.po
index 0ea8b21a..ae90f095 100644
--- a/koffice-i18n-de/messages/koffice/kspread.po
+++ b/koffice-i18n-de/messages/koffice/kspread.po
@@ -14,7 +14,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2020-03-25 00:27+0000\n"
"Last-Translator: Chris <xchrisx@uber.space>\n"
"Language-Team: German <https://mirror.git.trinitydesktop.org/weblate/"
@@ -559,6 +559,7 @@ msgid "Select columns:"
msgstr "Spalten auswählen:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Spalte"
@@ -13138,7 +13139,7 @@ msgstr "COLUMNS(A1:C3) ergibt 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) ergibt 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Zeile"
@@ -13246,7 +13247,8 @@ msgstr "ROWS(A1:C3) ergibt 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) ergibt 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Suchwert"
@@ -13290,6 +13292,62 @@ msgstr "LOOKUP(Wert; Suchvektor; Ergebnisvektor)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) für A1 = 1, A2 = 2 ergibt den Wert von B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Datenbank"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Berechnungsmethode (optional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-el/messages/koffice/kspread.po b/koffice-i18n-el/messages/koffice/kspread.po
index 83a7ad83..75ed3f32 100644
--- a/koffice-i18n-el/messages/koffice/kspread.po
+++ b/koffice-i18n-el/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-03-14 15:32+0200\n"
"Last-Translator: Spiros Georgaras <sng@hellug.gr>\n"
"Language-Team: Greek <i18ngr@lists.hellug.gr>\n"
@@ -552,6 +552,7 @@ msgid "Select columns:"
msgstr "Επιλογή στηλών:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Στήλη"
@@ -13117,7 +13118,7 @@ msgstr "COLUMNS(A1:C3) επιστρέφει 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) επιστρέφει 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Γραμμή"
@@ -13224,7 +13225,8 @@ msgstr "ROWS(A1:C3) επιστρέφει 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) επιστρέφει 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Τιμή αναζήτησης"
@@ -13271,6 +13273,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) με A1 = 1, A2 = 2 επιστρέφει την τιμή του B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Βάση δεδομένων"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Μέθοδος (προαιρετικό)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-en_GB/messages/koffice/kspread.po b/koffice-i18n-en_GB/messages/koffice/kspread.po
index 1c18caba..e533d1a4 100644
--- a/koffice-i18n-en_GB/messages/koffice/kspread.po
+++ b/koffice-i18n-en_GB/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-01-22 11:33+0000\n"
"Last-Translator: Malcolm Hunter <malcolm.hunter@gmx.co.uk>\n"
"Language-Team: British English <kde-en-gb@kde.me.uk>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
msgstr "Select columns:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Column"
@@ -13092,7 +13093,7 @@ msgstr "COLUMNS(A1:C3) returns 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) returns 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Row"
@@ -13198,7 +13199,8 @@ msgstr "ROWS(A1:C3) returns 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) returns 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Lookup value"
@@ -13243,6 +13245,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Method (optional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-es/messages/koffice/kspread.po b/koffice-i18n-es/messages/koffice/kspread.po
index afe1d341..2d551641 100644
--- a/koffice-i18n-es/messages/koffice/kspread.po
+++ b/koffice-i18n-es/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-05-03 11:33+0200\n"
"Last-Translator: Enrique Matias Sanchez (aka Quique) <cronopios@gmail.com>\n"
"Language-Team: Spanish <es@li.org>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
msgstr "Seleccionar columnas:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Columna"
@@ -13035,7 +13036,7 @@ msgstr "COLUMNS(A1:C3) devuelve 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) devuelve 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Fila"
@@ -13142,7 +13143,8 @@ msgstr "ROWS(A1:C3) devuelve 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) devuelve 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Buscar valor"
@@ -13188,6 +13190,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devuelve el valor de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Base de datos"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-et/messages/koffice/kspread.po b/koffice-i18n-et/messages/koffice/kspread.po
index 0aa7b8cb..80b8745a 100644
--- a/koffice-i18n-et/messages/koffice/kspread.po
+++ b/koffice-i18n-et/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-08-31 12:52+0200\n"
"Last-Translator: Marek Laane <bald@starman.ee>\n"
"Language-Team: Estonian <kde-et@linux.ee>\n"
@@ -546,6 +546,7 @@ msgid "Select columns:"
msgstr "Valitud veerud:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Veerg"
@@ -12901,7 +12902,7 @@ msgstr "COLUMNS(A1:C3) tagastab 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) tagastab 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rida"
@@ -13008,7 +13009,8 @@ msgstr "ROWS(A1:C3) tagastab 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) tagastab 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Otsimisväärtus"
@@ -13052,6 +13054,62 @@ msgstr "LOOKUP(väärtus; otsimisvektor; tulemusvektor)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1,232; A1:A6; B1:B6) tagastab, kui A1 = 1, A2 = 2, B1 väärtuse."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Andmebaas"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Meetod (mittekohustuslik)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-eu/messages/koffice/kspread.po b/koffice-i18n-eu/messages/koffice/kspread.po
index 2c4e7845..3b431a36 100644
--- a/koffice-i18n-eu/messages/koffice/kspread.po
+++ b/koffice-i18n-eu/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2005-08-08 23:53-0600\n"
"Last-Translator: Ion Gaztañaga <igaztanaga@gmail.com>\n"
"Language-Team: Basque <kdeuskaraz@euskalgnu.org>\n"
@@ -549,6 +549,7 @@ msgid "Select columns:"
msgstr "Hautatu zutabeak:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Zutabea"
@@ -13065,7 +13066,7 @@ msgstr "COLUMNS(A1:C3) funtzioak 3 itzultzen du"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) funtzioak 1 itzultzen du"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "&Lerroa"
@@ -13167,7 +13168,8 @@ msgstr "ROWS(A1:C3) funtzioak 3 itzultzen du"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) funtzioak 1 itzultzen du"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Goiko balioa"
@@ -13204,6 +13206,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Datu-basea"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metodoa (aukerazkoa)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-fa/messages/koffice/kspread.po b/koffice-i18n-fa/messages/koffice/kspread.po
index 7f242627..6757b01a 100644
--- a/koffice-i18n-fa/messages/koffice/kspread.po
+++ b/koffice-i18n-fa/messages/koffice/kspread.po
@@ -9,7 +9,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-02-08 09:45+0330\n"
"Last-Translator: MaryamSadat Razavi <razavi@itland.ir>\n"
"Language-Team: Persian <kde-i18n-fa@kde.org>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
msgstr "برگزیدن ستونها:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "ستون"
@@ -12891,7 +12892,7 @@ msgstr "COLUMNS(A1:C3)، ۳ را برمی‌گرداند"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2)، ۱ را برمی‌گرداند"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "سطر"
@@ -12995,7 +12996,8 @@ msgstr "ROWS(A1:C3)، ۳ را برمی‌گرداند"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2)، ۱ را برمی‌گرداند"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "مقدار مراجعه"
@@ -13040,6 +13042,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) برای A1 = ۱، A2 = ۲ مقدار B1 را برمی‌گرداند."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "دادگان"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "روش )اختیاری("
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-fi/messages/koffice/kspread.po b/koffice-i18n-fi/messages/koffice/kspread.po
index d23b393c..1baa6a45 100644
--- a/koffice-i18n-fi/messages/koffice/kspread.po
+++ b/koffice-i18n-fi/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2005-06-13 15:33+0300\n"
"Last-Translator: Ilpo Kantonen <ilpo@iki.fi>\n"
"Language-Team: finnish <Finnish <kde-i18n-fi-discussion@lists.sourceforge."
@@ -553,6 +553,7 @@ msgid "Select columns:"
msgstr "Valitse sarakkeet:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Sarake"
@@ -12788,7 +12789,7 @@ msgstr "COLUMNS(A1:C3) palauttaa arvon 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) palauttaa arvon 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "&Rivi"
@@ -12886,7 +12887,8 @@ msgstr "ROWS(A1:C3) palauttaa arvon 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) palauttaa arvon 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Ylin arvo"
@@ -12923,6 +12925,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Tietokanta"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metodi (valinnainen)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-fr/messages/koffice/kspread.po b/koffice-i18n-fr/messages/koffice/kspread.po
index 96c9de74..101ed726 100644
--- a/koffice-i18n-fr/messages/koffice/kspread.po
+++ b/koffice-i18n-fr/messages/koffice/kspread.po
@@ -13,7 +13,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-09-22 00:06+0200\n"
"Last-Translator: Matthieu Robin <kde@macolu.org>\n"
"Language-Team: French <kde-francophone@kde.org>\n"
@@ -555,6 +555,7 @@ msgid "Select columns:"
msgstr "Sélectionner les colonnes :"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Colonne"
@@ -13060,7 +13061,7 @@ msgstr "COLUMNS(A1:C3) renvoie 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) renvoie 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Ligne"
@@ -13167,7 +13168,8 @@ msgstr "ROWS(A1:C3) renvoie 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) renvoie 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valeur de recherche"
@@ -13212,6 +13214,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1.232; A1:A6; B1:B6) avec A1 = 1, A2 = 2 retourne la valeur de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Base de données"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Méthode (optionnel)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-ga/messages/koffice/kspread.po b/koffice-i18n-ga/messages/koffice/kspread.po
index 3c2c28a9..f57356bc 100644
--- a/koffice-i18n-ga/messages/koffice/kspread.po
+++ b/koffice-i18n-ga/messages/koffice/kspread.po
@@ -1,7 +1,7 @@
msgid ""
msgstr ""
"Project-Id-Version: koffice/kspread.po\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2004-12-03 14:52-0500\n"
"Last-Translator: Kevin Patrick Scannell <scannell@SLU.EDU>\n"
"Language-Team: ga <LL@li.org>\n"
@@ -532,6 +532,7 @@ msgid "Select columns:"
msgstr "Roghnaigh colúin:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Colún"
@@ -12523,7 +12524,7 @@ msgstr "Filleann COLUMNS(A1:C3) é seo: 3"
msgid "COLUMNS(D2) returns 1"
msgstr "Filleann COLUMNS(D2) é seo: 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Ró"
@@ -12621,7 +12622,8 @@ msgstr "Filleann ROWS(A1:C3) é seo: 3"
msgid "ROWS(D2) returns 1"
msgstr "Filleann ROWS(D2) é seo: 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Luach cuardaigh"
@@ -12658,6 +12660,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Bunachar Sonraí"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Type (optional)"
+msgid "Sorted (optional)"
+msgstr "Cineál (roghnach)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-gl/messages/koffice/kspread.po b/koffice-i18n-gl/messages/koffice/kspread.po
index edb019a6..5402cbdb 100644
--- a/koffice-i18n-gl/messages/koffice/kspread.po
+++ b/koffice-i18n-gl/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-01-14 18:43+0100\n"
"Last-Translator: Xabi G. Feal <xabigf@gmx.net>\n"
"Language-Team: Galician <trasno@ceu.fi.udc.es>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
msgstr "Seleccione as colunas:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Coluna"
@@ -12962,7 +12963,7 @@ msgstr "COLUMNS(A1:C3) devolve 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) devolve 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Fila"
@@ -13069,7 +13070,8 @@ msgstr "ROWS(A1:C3) devolve 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) devolve 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valor a procurar"
@@ -13114,6 +13116,62 @@ msgstr "LOOKUP(valor, vector_de_procura, vector_de_resultado)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devolve o valor de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Base de Datos"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-hu/messages/koffice/kspread.po b/koffice-i18n-hu/messages/koffice/kspread.po
index 5ba33d08..5cb59ec4 100644
--- a/koffice-i18n-hu/messages/koffice/kspread.po
+++ b/koffice-i18n-hu/messages/koffice/kspread.po
@@ -3,7 +3,7 @@
msgid ""
msgstr ""
"Project-Id-Version: KOffice 1.6\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-03-26 22:22+0100\n"
"Last-Translator: Tamas Szanto <tszanto@interware.hu>\n"
"Language-Team: Hungarian <kde-lista@sophia.jpte.hu>\n"
@@ -540,6 +540,7 @@ msgid "Select columns:"
msgstr "Oszlop(ok) kiválasztása:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "oszlop"
@@ -12910,7 +12911,7 @@ msgstr "COLUMNS(A1:C3) értéke 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) értéke 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Sor"
@@ -13012,7 +13013,8 @@ msgstr "ROWS(A1:C3) értéke 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) értéke 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "A keresett érték"
@@ -13049,6 +13051,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Adatbázis"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Mód (opcionális)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-it/messages/koffice/kspread.po b/koffice-i18n-it/messages/koffice/kspread.po
index 974c3d61..498f14c3 100644
--- a/koffice-i18n-it/messages/koffice/kspread.po
+++ b/koffice-i18n-it/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2022-04-01 15:20+0000\n"
"Last-Translator: Michele Calgaro <michele.calgaro@yahoo.it>\n"
"Language-Team: Italian <https://mirror.git.trinitydesktop.org/weblate/"
@@ -553,6 +553,7 @@ msgid "Select columns:"
msgstr "Seleziona colonne:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Colonna"
@@ -8574,8 +8575,8 @@ msgid ""
"acre, ha (hectare)."
msgstr ""
"Unità di superficie supportate: m2 (metro quadro), mi2 (miglio quadro), Nmi2 "
-"(miglio nautico quadro), in2 (pollice quadro), ft2 (piede quadro), yd2 ("
-"iarda quadra), acre (acro), ha (ettaro)."
+"(miglio nautico quadro), in2 (pollice quadro), ft2 (piede quadro), yd2 "
+"(iarda quadra), acre (acro), ha (ettaro)."
#: extensions/engineering.xml:141
#, no-c-format
@@ -13043,7 +13044,7 @@ msgstr "COLUMNS(A1:C3) restituisce 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) restituisce 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Riga"
@@ -13150,7 +13151,8 @@ msgstr "ROWS(A1:C3) restituisce 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) restituisce 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valore da cercare"
@@ -13197,6 +13199,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1,232; A1:A6; B1:B6) se A1 = 1 e A2 = 2 restituisce il valore di B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metodo (facoltativo)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
@@ -15563,7 +15621,8 @@ msgstr "TOGGLE(\"CiAo\") restituisce \"cIaO\""
#, no-c-format
msgid ""
"The CLEAN() function removes every non-printable character from the string"
-msgstr "La funzione CLEAN() rimuove ogni carattere non stampabile dalla stringa"
+msgstr ""
+"La funzione CLEAN() rimuove ogni carattere non stampabile dalla stringa"
#: extensions/text.xml:442
#, no-c-format
diff --git a/koffice-i18n-ja/messages/koffice/kspread.po b/koffice-i18n-ja/messages/koffice/kspread.po
index e06959c1..c7d2d7cf 100644
--- a/koffice-i18n-ja/messages/koffice/kspread.po
+++ b/koffice-i18n-ja/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-11-11 18:00+0900\n"
"Last-Translator: Yukiko Bando <ybando@k6.dion.ne.jp>\n"
"Language-Team: Japanese <Kdeveloper@kde.gr.jp>\n"
@@ -543,6 +543,7 @@ msgid "Select columns:"
msgstr "列を選択:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "列"
@@ -12694,7 +12695,7 @@ msgstr "COLUMNS(A1:C3)は3を返します"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2)は1を返します"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "行"
@@ -12796,7 +12797,8 @@ msgstr "ROWS(A1:C3)は3を返します"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2)は1を返します"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr ""
@@ -12833,6 +12835,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232;A1:A6;B1:B6)はA1=1、A2=2であればB1の値を返します。"
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "データベース"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "方式(オプション)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-lv/messages/koffice/kspread.po b/koffice-i18n-lv/messages/koffice/kspread.po
index 525a1a96..44709ef5 100644
--- a/koffice-i18n-lv/messages/koffice/kspread.po
+++ b/koffice-i18n-lv/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2002-03-03 13:22GMT+2\n"
"Last-Translator: Gints Polis <gintam@inbox.lv>\n"
"Language-Team: Latviešu <C@li.org>\n"
@@ -589,6 +589,7 @@ msgid "Select columns:"
msgstr "Dzēst Kolonu(as)"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolona"
@@ -13042,7 +13043,7 @@ msgstr "COMBIN(5;5) atgriež 1"
msgid "COLUMNS(D2) returns 1"
msgstr "COMBIN(5;5) atgriež 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rinda"
@@ -13142,7 +13143,8 @@ msgstr "ODD(1.2) atgriež 3"
msgid "ROWS(D2) returns 1"
msgstr "ODD(2) atgriež 3"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Augšējā vērtība"
@@ -13179,6 +13181,60 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+msgid "Data source"
+msgstr "Datums"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Teksta opcija"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, fuzzy, no-c-format
msgid "Statistical"
@@ -17411,10 +17467,6 @@ msgstr "Krāsa/Rāmis"
#~ msgstr "KSpread Jautājums"
#, fuzzy
-#~ msgid "A1 Style (optional)"
-#~ msgstr "Teksta opcija"
-
-#, fuzzy
#~ msgid "&Changes"
#~ msgstr "Mainīt tekstu"
diff --git a/koffice-i18n-ms/messages/koffice/kspread.po b/koffice-i18n-ms/messages/koffice/kspread.po
index 38176bc4..01b17a0d 100644
--- a/koffice-i18n-ms/messages/koffice/kspread.po
+++ b/koffice-i18n-ms/messages/koffice/kspread.po
@@ -4,7 +4,7 @@
msgid ""
msgstr ""
"Project-Id-Version: Mimos\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-10-05 19:47+0800\n"
"Last-Translator: Sharuzzaman Ahmat Raslan <sharuzzaman@myrealbox.com>\n"
"Language-Team: Malay <kedidiemas@yahoogroups.com>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
msgstr "Pilih lajur:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Lajur"
@@ -13044,7 +13045,7 @@ msgstr "COLUMNS(A1:C3) mengembalikan 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) mengembalikan 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "&Baris"
@@ -13146,7 +13147,8 @@ msgstr "ROWS(A1:C3) mengembalikan 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) mengembalikan 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Nilai atas"
@@ -13183,6 +13185,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Pangkalan Data"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Kaedah (opsyenal)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-nb/messages/koffice/kspread.po b/koffice-i18n-nb/messages/koffice/kspread.po
index d6c9d672..6c61cf4b 100644
--- a/koffice-i18n-nb/messages/koffice/kspread.po
+++ b/koffice-i18n-nb/messages/koffice/kspread.po
@@ -17,7 +17,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-10-14 21:59+0200\n"
"Last-Translator: Bjørn Steensrud <bjornst@powertech.no>\n"
"Language-Team: Norwegian Bokmål <i18n-no@lister.ping.uio.no>\n"
@@ -561,6 +561,7 @@ msgid "Select columns:"
msgstr "Velg kolonner:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolonne"
@@ -12924,7 +12925,7 @@ msgstr "COLUMNS(A1:C3) gir 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) gir 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rad"
@@ -13031,7 +13032,8 @@ msgstr "ROWS(A1:C3) gir 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) gir 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Oppslagsverdi"
@@ -13076,6 +13078,62 @@ msgstr "LOOKUP(verdi; oppslagsvektor; resultatvektor)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 gir verdien til B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metode (valgfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-ne/messages/koffice/kspread.po b/koffice-i18n-ne/messages/koffice/kspread.po
index 276a0349..6fcdb0a5 100644
--- a/koffice-i18n-ne/messages/koffice/kspread.po
+++ b/koffice-i18n-ne/messages/koffice/kspread.po
@@ -6,7 +6,7 @@ msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
"Report-Msgid-Bugs-To: \n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-02-12 10:40+0545\n"
"Last-Translator: Mahesh Subedi <submanesh@gmail.com>\n"
"Language-Team: Nepali <info@mpp.org.np>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
msgstr "स्तम्भ चयन गर्नुहोस्:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "स्तम्भ"
@@ -12777,7 +12778,7 @@ msgstr "COLUMNS(A1:C3) ले 3 फर्काउँछ"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) ले 1 फर्काउँछ"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "पङ्क्ति"
@@ -12881,7 +12882,8 @@ msgstr "ROWS(A1:C3) ले 3 फर्काउँछ"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) ले 1 फर्काउँछ"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "मान हेर्नुहोस्"
@@ -12923,6 +12925,62 @@ msgstr "LOOKUP(मान; खोजी भेक्टर; परिणाम
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) का लागि A1 = 1, A2 = 2 B1 का मान फर्काउँछ ।"
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "डाटाबेस"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "विधि (वैकल्पिक)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-nl/messages/koffice/kspread.po b/koffice-i18n-nl/messages/koffice/kspread.po
index c3feaf2c..d084bc9d 100644
--- a/koffice-i18n-nl/messages/koffice/kspread.po
+++ b/koffice-i18n-nl/messages/koffice/kspread.po
@@ -18,7 +18,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-08-26 17:44+0200\n"
"Last-Translator: Bram Schoenmakers <bramschoenmakers@kde.nl>\n"
"Language-Team: Nederlands <kde-i18n-nl@kde.org>\n"
@@ -563,6 +563,7 @@ msgid "Select columns:"
msgstr "Kolommen selecteren:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolom"
@@ -13208,7 +13209,7 @@ msgstr "COLUMNS(A1:C3) geeft 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) geeft 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rij"
@@ -13315,7 +13316,8 @@ msgstr "ROWS(A1:C3) geeft 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) geeft 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Opzoekwaarde"
@@ -13363,6 +13365,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1,232; A1:A6; B1:B6) met A1 = 1, A2 = 2 geeft de waarde terug van B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Database"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Methode (optioneel)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-pl/messages/koffice/kspread.po b/koffice-i18n-pl/messages/koffice/kspread.po
index a6fd44a6..6988c63c 100644
--- a/koffice-i18n-pl/messages/koffice/kspread.po
+++ b/koffice-i18n-pl/messages/koffice/kspread.po
@@ -15,7 +15,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-10-04 10:01+0200\n"
"Last-Translator: Robert Gomulka <rgom@o2.pl>\n"
"Language-Team: Polish <pl@li.org>\n"
@@ -558,6 +558,7 @@ msgid "Select columns:"
msgstr "Wybierz kolumny:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolumna"
@@ -12968,7 +12969,7 @@ msgstr "COLUMNS(A1:C3) zwraca 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) zwraca 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Wiersz"
@@ -13075,7 +13076,8 @@ msgstr "ROWS(A1:C3) zwraca 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) zwraca 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Wartość wyszukiwana"
@@ -13122,6 +13124,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) dla A1 = 1, A2 = 2 zwraca wartość B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Baza danych"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Tryb (opcjonalny)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-pt/messages/koffice/kspread.po b/koffice-i18n-pt/messages/koffice/kspread.po
index b52b61f8..a29ff31f 100644
--- a/koffice-i18n-pt/messages/koffice/kspread.po
+++ b/koffice-i18n-pt/messages/koffice/kspread.po
@@ -1,7 +1,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-08-20 12:48+0100\n"
"Last-Translator: José Nuno Pires <jncp@netcabo.pt>\n"
"Language-Team: pt <kde-i18n-pt@kde.org>\n"
@@ -655,6 +655,7 @@ msgid "Select columns:"
msgstr "Seleccione as colunas:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Coluna"
@@ -13111,7 +13112,7 @@ msgstr "O COLUMNS(A1:C3) devolve 3"
msgid "COLUMNS(D2) returns 1"
msgstr "O COLUMNS(D2) devolve 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Linha"
@@ -13218,7 +13219,8 @@ msgstr "O ROWS(A1:C3) devolve 3"
msgid "ROWS(D2) returns 1"
msgstr "O ROWS(D2) devolve 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valor da procura"
@@ -13265,6 +13267,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"O LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 devolve o valor de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Base de Dados"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-pt_BR/messages/koffice/kspread.po b/koffice-i18n-pt_BR/messages/koffice/kspread.po
index f78042e6..c4a31676 100644
--- a/koffice-i18n-pt_BR/messages/koffice/kspread.po
+++ b/koffice-i18n-pt_BR/messages/koffice/kspread.po
@@ -4,7 +4,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2019-05-20 16:14+0000\n"
"Last-Translator: Sebastião Guerra <sebastiao.luiz.guerra@gmail.com>\n"
"Language-Team: Portuguese (Brazil) <https://mirror.git.trinitydesktop.org/"
@@ -545,6 +545,7 @@ msgid "Select columns:"
msgstr "Selecionar colunas:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Coluna"
@@ -12955,7 +12956,7 @@ msgstr "COLUMNS(A1:C3) retorna 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) retorna 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Linha"
@@ -13062,7 +13063,8 @@ msgstr "ROWS(A1:C3) retorna 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) retorna 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Valor da procura"
@@ -13109,6 +13111,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"O LOOKUP(1.232; A1:A6; B1:B6) para A1 = 1, A2 = 2 retorna o valor de B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Banco de dados"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Método (opcional)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-ru/messages/koffice/kspread.po b/koffice-i18n-ru/messages/koffice/kspread.po
index 37284a00..52657677 100644
--- a/koffice-i18n-ru/messages/koffice/kspread.po
+++ b/koffice-i18n-ru/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2024-05-01 20:00+0000\n"
"Last-Translator: Andrei Stepanov <adem4ik@gmail.com>\n"
"Language-Team: Russian <https://mirror.git.trinitydesktop.org/weblate/"
@@ -19,8 +19,8 @@ msgstr ""
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
-"Plural-Forms: nplurals=3; plural=n%10==1 && n%100!=11 ? 0 : n%10>=2 && "
-"n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2;\n"
+"Plural-Forms: nplurals=3; plural=n%10==1 && n%100!=11 ? 0 : n%10>=2 && n"
+"%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2;\n"
"X-Generator: Weblate 4.17\n"
#. Instead of a literal translation, add your name to the end of the list (separated by a comma).
@@ -554,6 +554,7 @@ msgid "Select columns:"
msgstr "Выберите столбцы:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Столбец"
@@ -12972,7 +12973,7 @@ msgstr "COLUMNS(A1:C3) возвратит 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) возвратит 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Строка"
@@ -13079,7 +13080,8 @@ msgstr "ROWS(A1:C3) возвратит 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) возвратит 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Поиск значения"
@@ -13122,6 +13124,62 @@ msgstr "LOOKUP(значение; вектор поиска; результиру
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) при A1 = 1, A2 = 2 возвратит значение B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "База данных"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Метод (необязательный параметр)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
@@ -16439,8 +16497,8 @@ msgstr ""
"При включении этой опции выделенные ячейки будут объединены в одну большую "
"ячейку (как при вызове пункта меню «Данные» -> «Объединить ячейки»). При "
"выборе этой ячейки и отключении этой опции все ячейки примут размеры до "
-"объединения. То же самое можно получить, выбрав пункт меню «Данные» -> «"
-"Разбить ячейки»."
+"объединения. То же самое можно получить, выбрав пункт меню «Данные» -> "
+"«Разбить ячейки»."
#: dialogs/position_cell_format.ui:253
#, no-c-format
diff --git a/koffice-i18n-sk/messages/koffice/kspread.po b/koffice-i18n-sk/messages/koffice/kspread.po
index 41acb543..ebd5a1fb 100644
--- a/koffice-i18n-sk/messages/koffice/kspread.po
+++ b/koffice-i18n-sk/messages/koffice/kspread.po
@@ -12,7 +12,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-01-27 09:42+0100\n"
"Last-Translator: Richard Fric <Richard.Fric@kdemail.net>\n"
"Language-Team: Slovak <sk@li.org>\n"
@@ -554,6 +554,7 @@ msgid "Select columns:"
msgstr "Výber stĺpca:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Stĺpec"
@@ -6471,8 +6472,8 @@ msgid ""
"No database drivers available. To use this feature you need to install the "
"necessary TQt 3 database drivers."
msgstr ""
-"Nie je dostupný žiadny ovládač databázy. Potrebujete nainštalovať TQt 3 modul "
-"s potrebnými ovládačmi."
+"Nie je dostupný žiadny ovládač databázy. Potrebujete nainštalovať TQt 3 "
+"modul s potrebnými ovládačmi."
#: kspread_view.cpp:4974
msgid "Sheet %1 could not be found for printing"
@@ -12776,7 +12777,7 @@ msgstr "COLUMNS(A1:C3) vracia 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) vracia 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "&Riadok"
@@ -12876,7 +12877,8 @@ msgstr "ROWS(A1:C3) vracia 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) vracia 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Horná hranica"
@@ -12913,6 +12915,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Databáza"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metóda (voliteľné)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-sl/messages/koffice/kspread.po b/koffice-i18n-sl/messages/koffice/kspread.po
index 05382109..fed9b08c 100644
--- a/koffice-i18n-sl/messages/koffice/kspread.po
+++ b/koffice-i18n-sl/messages/koffice/kspread.po
@@ -11,7 +11,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-01-07 15:44+0100\n"
"Last-Translator: Andrej Vernekar <andrej.vernekar@moj.net>\n"
"Language-Team: Slovenian <translation-team-sl@lists.sourceforge.net>\n"
@@ -552,6 +552,7 @@ msgid "Select columns:"
msgstr "Izberi stolpce:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Stolpec"
@@ -12812,7 +12813,7 @@ msgstr "COLUMNS(A1:C3) vrne 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) vrne 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Vrstica"
@@ -12917,7 +12918,8 @@ msgstr "ROWS(A1:C3) vrne 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) vrne 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Iskana vrednost"
@@ -12954,6 +12956,62 @@ msgstr "LOOKUP(vrednost; preiskovani vektor, vektor rezultata)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) za A1 = 1, A2 = 2 vrne vrednost celice B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Zbirka podatkov"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metoda (po želji)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-sr/messages/koffice/kspread.po b/koffice-i18n-sr/messages/koffice/kspread.po
index 18a941a9..504e2365 100644
--- a/koffice-i18n-sr/messages/koffice/kspread.po
+++ b/koffice-i18n-sr/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-11-05 14:41+0100\n"
"Last-Translator: Chusslove Illich <caslav.ilic@gmx.net>\n"
"Language-Team: Serbian <kde-yu@kde.org.yu>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
msgstr "Одабери колоне:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Колона"
@@ -12900,7 +12901,7 @@ msgstr "COLUMNS(A1:C3) враћа 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) враћа 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Врста"
@@ -13005,7 +13006,8 @@ msgstr "ROWS(A1:C3) враћа 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) враћа 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Вредност за потрагу"
@@ -13049,6 +13051,62 @@ msgstr "LOOKUP(вредност; вектор за потрагу; вектор
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) за A1 = 1, A2 = 2 враћа вредност B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "База података"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Метод (опционо)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-sr@Latn/messages/koffice/kspread.po b/koffice-i18n-sr@Latn/messages/koffice/kspread.po
index b5188272..ab174319 100644
--- a/koffice-i18n-sr@Latn/messages/koffice/kspread.po
+++ b/koffice-i18n-sr@Latn/messages/koffice/kspread.po
@@ -6,7 +6,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-11-05 14:41+0100\n"
"Last-Translator: Chusslove Illich <caslav.ilic@gmx.net>\n"
"Language-Team: Serbian <kde-yu@kde.org.yu>\n"
@@ -544,6 +544,7 @@ msgid "Select columns:"
msgstr "Odaberi kolone:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolona"
@@ -12905,7 +12906,7 @@ msgstr "COLUMNS(A1:C3) vraća 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) vraća 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Vrsta"
@@ -13010,7 +13011,8 @@ msgstr "ROWS(A1:C3) vraća 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) vraća 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Vrednost za potragu"
@@ -13054,6 +13056,62 @@ msgstr "LOOKUP(vrednost; vektor za potragu; vektor rezultata)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) za A1 = 1, A2 = 2 vraća vrednost B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Baza podataka"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metod (opciono)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-sv/messages/koffice/kspread.po b/koffice-i18n-sv/messages/koffice/kspread.po
index 281ac5b6..da923480 100644
--- a/koffice-i18n-sv/messages/koffice/kspread.po
+++ b/koffice-i18n-sv/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-10-14 06:48+0200\n"
"Last-Translator: Stefan Asserhäll <stefan.asserhall@comhem.se>\n"
"Language-Team: Swedish <sv@li.org>\n"
@@ -551,6 +551,7 @@ msgid "Select columns:"
msgstr "Välj kolumner:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Kolumn"
@@ -12986,7 +12987,7 @@ msgstr "COLUMNS(A1:C3) returnerar 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) returnerar 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Rad"
@@ -13093,7 +13094,8 @@ msgstr "ROWS(A1:C3) returnerar 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) returnerar 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Uppslagningsvärde"
@@ -13139,6 +13141,62 @@ msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
"LOOKUP(1,232; A1:A6; B1:B6) för A1 = 1, A2 = 2 returnerar värdet på B1."
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Databas"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Metod (valfri)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-tr/messages/koffice/kspread.po b/koffice-i18n-tr/messages/koffice/kspread.po
index 7bd4e588..5bf08939 100644
--- a/koffice-i18n-tr/messages/koffice/kspread.po
+++ b/koffice-i18n-tr/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-02-05 15:28+0200\n"
"Last-Translator: Engin Çağatay <engincagatay@yahoo.com>\n"
"Language-Team: Türkçe <tr@li.org>\n"
@@ -550,6 +550,7 @@ msgid "Select columns:"
msgstr "Sütunları seçin:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Sütun"
@@ -12694,7 +12695,7 @@ msgstr "COLUMNS(A1:C3), 3 değerini gönderir"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2), 1 değerini gönderir"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "Satır"
@@ -12794,7 +12795,8 @@ msgstr "ROWS(A1:C3), 3 değerini gönderir"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2), 1 değerini gönderir"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr ""
@@ -12831,6 +12833,62 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "Veritabanı"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "Yöntem (seçmeli)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-uk/messages/koffice/kspread.po b/koffice-i18n-uk/messages/koffice/kspread.po
index e4a6ccd0..5897837f 100644
--- a/koffice-i18n-uk/messages/koffice/kspread.po
+++ b/koffice-i18n-uk/messages/koffice/kspread.po
@@ -5,7 +5,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2007-05-26 17:12-0700\n"
"Last-Translator: Ivan Petrouchtchak <ivanpetrouchtchak@yahoo.com>\n"
"Language-Team: Ukrainian <translation@linux.org.ua>\n"
@@ -547,6 +547,7 @@ msgid "Select columns:"
msgstr "Виберіть стовпчики:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "Стовпчик"
@@ -12669,7 +12670,7 @@ msgstr "COMBIN(5;5) повертає 1"
msgid "COLUMNS(D2) returns 1"
msgstr "IMPOWER(\"1.2\";2) повертає 1.44 "
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, fuzzy, no-c-format
msgid "Row"
msgstr "Рядок"
@@ -12773,7 +12774,8 @@ msgstr "A1=4;A2=6;IF(A1>A2;5;3) повертає 3"
msgid "ROWS(D2) returns 1"
msgstr "IMPOWER(\"1.2\";2) повертає 1.44 "
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, fuzzy, no-c-format
msgid "Lookup value"
msgstr "Верхнє значення"
@@ -12810,6 +12812,61 @@ msgstr ""
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr ""
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "База даних"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+msgid "Sorted (optional)"
+msgstr "Паро&ль (не обов'язковий):"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, fuzzy, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-zh_CN/messages/koffice/kspread.po b/koffice-i18n-zh_CN/messages/koffice/kspread.po
index e738a2fd..06b0ab38 100644
--- a/koffice-i18n-zh_CN/messages/koffice/kspread.po
+++ b/koffice-i18n-zh_CN/messages/koffice/kspread.po
@@ -10,7 +10,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-04-01 12:52+0800\n"
"Last-Translator: Funda Wang <fundawang@linux.net.cn>\n"
"Language-Team: zh_CN <i18n-translation@lists.linux.net.cn>\n"
@@ -548,6 +548,7 @@ msgid "Select columns:"
msgstr "选择列:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "列"
@@ -12556,7 +12557,7 @@ msgstr "COLUMNS(A1:C3) 返回 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) 返回 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "行"
@@ -12655,7 +12656,8 @@ msgstr "ROWS(A1:C3) 返回 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) 返回 1"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "查阅值"
@@ -12692,6 +12694,62 @@ msgstr "LOOKUP(值;查阅向量;结果向量)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "LOOKUP(1.232; A1:A6; B1:B6) 当 A1=1,A2=2 时返回 B1 的值。"
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "数据库"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "方法(可选的)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"
diff --git a/koffice-i18n-zh_TW/messages/koffice/kspread.po b/koffice-i18n-zh_TW/messages/koffice/kspread.po
index 70faf8fe..176efcad 100644
--- a/koffice-i18n-zh_TW/messages/koffice/kspread.po
+++ b/koffice-i18n-zh_TW/messages/koffice/kspread.po
@@ -8,7 +8,7 @@
msgid ""
msgstr ""
"Project-Id-Version: kspread\n"
-"POT-Creation-Date: 2021-07-07 18:32+0000\n"
+"POT-Creation-Date: 2024-05-18 18:18+0000\n"
"PO-Revision-Date: 2006-08-22 10:21+0800\n"
"Last-Translator: Frank Weng (a.k.a. Franklin) <franklin at goodhorse dot idv "
"dot tw>\n"
@@ -549,6 +549,7 @@ msgid "Select columns:"
msgstr "選擇欄:"
#: dialogs/kspread_dlg_database.cpp:223 extensions/reference.xml:121
+#: extensions/reference.xml:243
#, no-c-format
msgid "Column"
msgstr "欄"
@@ -12603,7 +12604,7 @@ msgstr "COLUMNS(A1:C3) 傳回 3"
msgid "COLUMNS(D2) returns 1"
msgstr "COLUMNS(D2) 傳回 1"
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr "列"
@@ -12703,7 +12704,8 @@ msgstr "ROWS(A1:C3) 傳回 3"
msgid "ROWS(D2) returns 1"
msgstr "ROWS(D2) 傳回 3"
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr "Lookup 值"
@@ -12745,6 +12747,62 @@ msgstr "LOOKUP(value; lookup vector; result vector)"
msgid "LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1."
msgstr "若 A1 = 1,A2 = 2,則 LOOKUP(1.232; A1:A6; B1:B6)傳回 B1 的值。"
+#: extensions/reference.xml:213 extensions/reference.xml:239
+#, fuzzy, no-c-format
+#| msgid "Database"
+msgid "Data source"
+msgstr "資料庫"
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, fuzzy, no-c-format
+#| msgid "Method (optional)"
+msgid "Sorted (optional)"
+msgstr "方法 (選擇性的)"
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"