summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--template/messages/koffice/kspread.pot62
1 files changed, 59 insertions, 3 deletions
diff --git a/template/messages/koffice/kspread.pot b/template/messages/koffice/kspread.pot
index 24510a69..400252c6 100644
--- a/template/messages/koffice/kspread.pot
+++ b/template/messages/koffice/kspread.pot
@@ -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: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -522,6 +522,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 ""
@@ -12270,7 +12271,7 @@ msgstr ""
msgid "COLUMNS(D2) returns 1"
msgstr ""
-#: extensions/reference.xml:117
+#: extensions/reference.xml:117 extensions/reference.xml:217
#, no-c-format
msgid "Row"
msgstr ""
@@ -12368,7 +12369,8 @@ msgstr ""
msgid "ROWS(D2) returns 1"
msgstr ""
-#: extensions/reference.xml:187
+#: extensions/reference.xml:187 extensions/reference.xml:209
+#: extensions/reference.xml:235
#, no-c-format
msgid "Lookup value"
msgstr ""
@@ -12405,6 +12407,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
+#, no-c-format
+msgid "Data source"
+msgstr ""
+
+#: extensions/reference.xml:221 extensions/reference.xml:247
+#, no-c-format
+msgid "Sorted (optional)"
+msgstr ""
+
+#: extensions/reference.xml:225
+#, no-c-format
+msgid ""
+"Look for a matching value in the first row of the given table, and return the value of the "
+"indicated row."
+msgstr ""
+
+#: extensions/reference.xml:226
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first row of the 'data source'. If a "
+"value matches, the value in the 'row' and the column, the value was found "
+"in, is returned. If 'sorted' is true (default), the first row is assumed to "
+"be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:227
+#, no-c-format
+msgid "HLOOKUP(Lookup value; data source; Row; Sorted)"
+msgstr ""
+
+#: extensions/reference.xml:251
+#, no-c-format
+msgid ""
+"Look for a matching value in the first column of the given table, and return the value of the "
+"indicated column."
+msgstr ""
+
+#: extensions/reference.xml:252
+#, no-c-format
+msgid ""
+"Looks up the 'lookup value' in the first column of the 'data source'. If a "
+"value matches, the value in the 'column' and the row, the value was found "
+"in, is returned. If 'sorted' is true (default), the first column is assumed "
+"to be sorted. The search will end, if the 'lookup value' is lower than the "
+"value, currently compared to."
+msgstr ""
+
+#: extensions/reference.xml:253
+#, no-c-format
+msgid "VLOOKUP(Lookup value; data source; Column; Sorted)"
+msgstr ""
+
#: extensions/statistical.xml:5
#, no-c-format
msgid "Statistical"