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