diff options
37 files changed, 2187 insertions, 115 deletions
diff --git a/koffice-i18n-bg/messages/koffice/kspread.po b/koffice-i18n-bg/messages/koffice/kspread.po index 1bf770f8..69de0a00 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 20:19+0000\n" "PO-Revision-Date: 2007-05-02 08:18+0000\n" "Last-Translator: Zlatko Popov <[email protected]>\n" "Language-Team: Bulgarian <[email protected]>\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,60 @@ 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 "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 #, 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..38aaee85 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 20:19+0000\n" "PO-Revision-Date: 2006-10-26 20:08+0200\n" "Last-Translator: Antoni Bella Pérez <[email protected]>\n" "Language-Team: Catalan <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Base de dades" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..c9cc53d0 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 20:19+0000\n" "PO-Revision-Date: 2018-10-22 01:57+0000\n" "Last-Translator: Slávek Banko <[email protected]>\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,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 "Databáze" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..158ca508 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 20:19+0000\n" "PO-Revision-Date: 2004-09-09 12:35+0100\n" "Last-Translator: Kyfieithu <[email protected]>\n" "Language-Team: Cymraeg <[email protected]>\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,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 "Cronfa Ddata" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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 1b85cdcd..e95029ae 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 20:19+0000\n" "PO-Revision-Date: 2006-08-25 06:22-0400\n" "Last-Translator: Erik Kjær Pedersen <[email protected]>\n" "Language-Team: Danish <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Database" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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-de/messages/koffice/kspread.po b/koffice-i18n-de/messages/koffice/kspread.po index 0ea8b21a..c7e50dca 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 20:19+0000\n" "PO-Revision-Date: 2020-03-25 00:27+0000\n" "Last-Translator: Chris <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Datenbank" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..00bc2176 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 20:19+0000\n" "PO-Revision-Date: 2007-03-14 15:32+0200\n" "Last-Translator: Spiros Georgaras <[email protected]>\n" "Language-Team: Greek <[email protected]>\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,60 @@ 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 "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 #, 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..c261da7d 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 20:19+0000\n" "PO-Revision-Date: 2006-01-22 11:33+0000\n" "Last-Translator: Malcolm Hunter <[email protected]>\n" "Language-Team: British English <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Database" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..e4483fa4 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 20:19+0000\n" "PO-Revision-Date: 2007-05-03 11:33+0200\n" "Last-Translator: Enrique Matias Sanchez (aka Quique) <[email protected]>\n" "Language-Team: Spanish <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Base de datos" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..b301a1b4 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 20:19+0000\n" "PO-Revision-Date: 2006-08-31 12:52+0200\n" "Last-Translator: Marek Laane <[email protected]>\n" "Language-Team: Estonian <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Andmebaas" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..a7793872 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 20:19+0000\n" "PO-Revision-Date: 2005-08-08 23:53-0600\n" "Last-Translator: Ion Gaztañaga <[email protected]>\n" "Language-Team: Basque <[email protected]>\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,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 "Datu-basea" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..539f7791 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 20:19+0000\n" "PO-Revision-Date: 2007-02-08 09:45+0330\n" "Last-Translator: MaryamSadat Razavi <[email protected]>\n" "Language-Team: Persian <[email protected]>\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,60 @@ 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 "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 #, 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..927b14ca 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 20:19+0000\n" "PO-Revision-Date: 2005-06-13 15:33+0300\n" "Last-Translator: Ilpo Kantonen <[email protected]>\n" "Language-Team: finnish <Finnish <[email protected]." @@ -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,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 "Tietokanta" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..282c30e9 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 20:19+0000\n" "PO-Revision-Date: 2006-09-22 00:06+0200\n" "Last-Translator: Matthieu Robin <[email protected]>\n" "Language-Team: French <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Base de données" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..44eb9e8f 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 20:19+0000\n" "PO-Revision-Date: 2004-12-03 14:52-0500\n" "Last-Translator: Kevin Patrick Scannell <[email protected]>\n" "Language-Team: ga <[email protected]>\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,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 "Bunachar Sonraí" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..70d7d2ec 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 20:19+0000\n" "PO-Revision-Date: 2007-01-14 18:43+0100\n" "Last-Translator: Xabi G. Feal <[email protected]>\n" "Language-Team: Galician <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Base de Datos" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..099d16b7 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 20:19+0000\n" "PO-Revision-Date: 2007-03-26 22:22+0100\n" "Last-Translator: Tamas Szanto <[email protected]>\n" "Language-Team: Hungarian <[email protected]>\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,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 "Adatbázis" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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 6ec928d6..0c64b5ec 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 20:19+0000\n" "PO-Revision-Date: 2022-04-01 15:20+0000\n" "Last-Translator: Michele Calgaro <[email protected]>\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" @@ -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,60 @@ 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 "Data source" +msgstr "Database" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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" diff --git a/koffice-i18n-ja/messages/koffice/kspread.po b/koffice-i18n-ja/messages/koffice/kspread.po index e06959c1..6fc80cb5 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 20:19+0000\n" "PO-Revision-Date: 2006-11-11 18:00+0900\n" "Last-Translator: Yukiko Bando <[email protected]>\n" "Language-Team: Japanese <[email protected]>\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,60 @@ 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 "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 #, 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..4a12b440 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 <[email protected]>\n" "Language-Team: Latviešu <[email protected]>\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" @@ -18039,3 +18091,7 @@ msgstr "Krāsa/Rāmis" #~ msgid "POLA(12;12) returns 16.9705" #~ msgstr "POLA(12;12) atgriež 16.9705" + +#, fuzzy +#~ msgid "A1 Style (optional)" +#~ msgstr "Teksta opcija" diff --git a/koffice-i18n-ms/messages/koffice/kspread.po b/koffice-i18n-ms/messages/koffice/kspread.po index 38176bc4..abacb346 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 20:19+0000\n" "PO-Revision-Date: 2006-10-05 19:47+0800\n" "Last-Translator: Sharuzzaman Ahmat Raslan <[email protected]>\n" "Language-Team: Malay <[email protected]>\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,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 "Pangkalan Data" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..b3d4ff68 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 20:19+0000\n" "PO-Revision-Date: 2006-10-14 21:59+0200\n" "Last-Translator: Bjørn Steensrud <[email protected]>\n" "Language-Team: Norwegian Bokmål <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Database" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..8dcf48ab 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 20:19+0000\n" "PO-Revision-Date: 2007-02-12 10:40+0545\n" "Last-Translator: Mahesh Subedi <[email protected]>\n" "Language-Team: Nepali <[email protected]>\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,60 @@ 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 "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 #, 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..d9ea841b 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 20:19+0000\n" "PO-Revision-Date: 2006-08-26 17:44+0200\n" "Last-Translator: Bram Schoenmakers <[email protected]>\n" "Language-Team: Nederlands <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Database" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..b8844b8f 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 20:19+0000\n" "PO-Revision-Date: 2006-10-04 10:01+0200\n" "Last-Translator: Robert Gomulka <[email protected]>\n" "Language-Team: Polish <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Baza danych" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..8ac2a1ff 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 20:19+0000\n" "PO-Revision-Date: 2006-08-20 12:48+0100\n" "Last-Translator: José Nuno Pires <[email protected]>\n" "Language-Team: pt <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Base de Dados" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..7ea1fe45 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 20:19+0000\n" "PO-Revision-Date: 2019-05-20 16:14+0000\n" "Last-Translator: Sebastião Guerra <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Banco de dados" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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 0b59bfa2..12918396 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 20:19+0000\n" "PO-Revision-Date: 2024-05-01 20:00+0000\n" "Last-Translator: Andrei Stepanov <[email protected]>\n" "Language-Team: Russian <https://mirror.git.trinitydesktop.org/weblate/" @@ -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,60 @@ 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 "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 #, no-c-format msgid "Statistical" diff --git a/koffice-i18n-sk/messages/koffice/kspread.po b/koffice-i18n-sk/messages/koffice/kspread.po index df345499..ccd3c1a7 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 20:19+0000\n" "PO-Revision-Date: 2007-01-27 09:42+0100\n" "Last-Translator: Richard Fric <[email protected]>\n" "Language-Team: Slovak <[email protected]>\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" @@ -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,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 "Databáza" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..a09d663f 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 20:19+0000\n" "PO-Revision-Date: 2007-01-07 15:44+0100\n" "Last-Translator: Andrej Vernekar <[email protected]>\n" "Language-Team: Slovenian <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Zbirka podatkov" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..58e238a5 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 20:19+0000\n" "PO-Revision-Date: 2006-11-05 14:41+0100\n" "Last-Translator: Chusslove Illich <[email protected]>\n" "Language-Team: Serbian <[email protected]>\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,60 @@ 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 "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 #, 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..cdd27463 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 20:19+0000\n" "PO-Revision-Date: 2006-11-05 14:41+0100\n" "Last-Translator: Chusslove Illich <[email protected]>\n" "Language-Team: Serbian <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Baza podataka" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..182c1d47 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 20:19+0000\n" "PO-Revision-Date: 2006-10-14 06:48+0200\n" "Last-Translator: Stefan Asserhäll <[email protected]>\n" "Language-Team: Swedish <[email protected]>\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,60 @@ 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 "Data source" +msgstr "Databas" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..006415c3 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 20:19+0000\n" "PO-Revision-Date: 2006-02-05 15:28+0200\n" "Last-Translator: Engin Çağatay <[email protected]>\n" "Language-Team: Türkçe <[email protected]>\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,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 "Veritabanı" + +#: extensions/reference.xml:221 extensions/reference.xml:247 +#, fuzzy, no-c-format +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..10f6e825 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 20:19+0000\n" "PO-Revision-Date: 2007-05-26 17:12-0700\n" "Last-Translator: Ivan Petrouchtchak <[email protected]>\n" "Language-Team: Ukrainian <[email protected]>\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,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 "База даних" + +#: 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..2ae12aea 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 20:19+0000\n" "PO-Revision-Date: 2006-04-01 12:52+0800\n" "Last-Translator: Funda Wang <[email protected]>\n" "Language-Team: zh_CN <[email protected]>\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,60 @@ 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 "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 #, 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..bdafc7ce 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 20:19+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,60 @@ 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 "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 #, no-c-format msgid "Statistical" |