aboutsummaryrefslogtreecommitdiff
path: root/source/fi/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2024-07-15 12:36:48 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2024-07-15 12:41:21 +0200
commitee64d2fdafe658ac658dc193b1ed59b1f063fc27 (patch)
tree3918bc8bc1b574dbf041d1ae38c91c476cc3424a /source/fi/helpcontent2
parentd8b21faf49eb9131634ab258d39a73427cbf7d26 (diff)
update translations for master/24-8
Change-Id: I959d23423e7f5f6f5cf91533b3ed9888e4b0a999 (cherry picked from commit 0e95a8dfb0b499b18834776b911c0b60725c215e)
Diffstat (limited to 'source/fi/helpcontent2')
-rw-r--r--source/fi/helpcontent2/source/text/scalc/01.po70
1 files changed, 35 insertions, 35 deletions
diff --git a/source/fi/helpcontent2/source/text/scalc/01.po b/source/fi/helpcontent2/source/text/scalc/01.po
index 5189a5b1511..30df75841f1 100644
--- a/source/fi/helpcontent2/source/text/scalc/01.po
+++ b/source/fi/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2024-07-08 17:35+0200\n"
+"POT-Creation-Date: 2024-07-15 12:05+0200\n"
"PO-Revision-Date: 2024-02-05 09:45+0000\n"
"Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
"Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/fi/>\n"
@@ -71737,103 +71737,103 @@ msgctxt ""
msgid "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) or regular expressions for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets."
msgstr ""
-#. TwFcc
+#. CY5Hu
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id211708281649651\n"
"help.text"
-msgid "XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )"
+msgid "XLOOKUP( [Search criterion] ; Search Array ; Result Array [ ; [ Result if not found ] [ ; [Match Mode] [ ; Search Mode ] ] ] )"
msgstr ""
-#. WoJu6
+#. 5W9TT
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id861708281340704\n"
"help.text"
-msgid "<emph>Lookup</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>."
+msgid "<emph>Search criterion</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Search Array</emph>."
msgstr ""
-#. hBE9s
+#. JexuJ
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id831708281625340\n"
"help.text"
-msgid "<emph>Array</emph>: is the reference of the array to search. Array must be a 1-dimensional array and must be contained in one sheet only."
+msgid "<emph>Search Array</emph>: is the reference of the array to search. Array must be a 1-dimensional array and must be contained in one sheet only."
msgstr ""
-#. nWhEP
+#. EGAYg
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id241708281629922\n"
"help.text"
-msgid "<emph>Return</emph>: is the reference of the array or range to return."
+msgid "<emph>Result Array</emph>: is the reference of the array or range to return."
msgstr ""
-#. G4DLq
+#. WKPAt
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id821708357634624\n"
"help.text"
-msgid "If <emph>Return</emph> is a range of cells, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>."
+msgid "If <emph>Result Array</emph> is a range of cells, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>."
msgstr ""
-#. WTFGZ
+#. sdzRc
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id271708281637035\n"
"help.text"
-msgid "<emph>NotFound</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>NotFound</emph> is omitted, the function returns the #N/A error."
+msgid "<emph>Result if not found</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>Result if not found</emph> is omitted, the function returns the #N/A error."
msgstr ""
-#. ruAWq
+#. 64MsW
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id121708281643207\n"
"help.text"
-msgid "<emph>MatchType</emph>: (optional) specifies the match type. Values can be:"
+msgid "<emph>Match Mode</emph>: (optional) specifies the match type. Values can be:"
msgstr ""
-#. go9sN
+#. VWPhz
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id111708281542144\n"
"help.text"
-msgid "<emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return the #N/A error."
+msgid "<emph>0</emph>: exact match (default). If <emph>Search criterion</emph> value is not found and <emph>Result if not found</emph> text is omitted, then return the #N/A error."
msgstr ""
-#. CtG9A
+#. PzWxb
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id851708281548335\n"
"help.text"
-msgid "<emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item."
+msgid "<emph>-1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next smaller item."
msgstr ""
-#. CpEkK
+#. N3DdJ
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id801708281553430\n"
"help.text"
-msgid "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item."
+msgid "<emph>1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next larger item."
msgstr ""
-#. JJ3M2
+#. vhHmc
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id881708281558005\n"
"help.text"
-msgid "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings."
+msgid "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters * (multiple characters), ? (single character), and ~ have special meanings."
msgstr ""
#. GAYga
@@ -71845,58 +71845,58 @@ msgctxt ""
msgid "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match."
msgstr ""
-#. EqTBc
+#. CFgfx
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id871708281607313\n"
"help.text"
-msgid "<emph>SearchMode</emph>: (optional) specifies the search mode to use."
+msgid "<emph>Search Mode</emph>: (optional) specifies the search mode to use."
msgstr ""
-#. FfKjN
+#. PrCaa
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id281708281579757\n"
"help.text"
-msgid "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Array</emph> (default)."
+msgid "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Search Array</emph> (default)."
msgstr ""
-#. 8CD3w
+#. oiSgS
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id251708281584285\n"
"help.text"
-msgid "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Array</emph>."
+msgid "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Search Array</emph>."
msgstr ""
-#. 6aABE
+#. aGQoN
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id191708281589997\n"
"help.text"
-msgid "<emph>2</emph>: binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned."
+msgid "<emph>2</emph>: binary search that relies on <emph>Search Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned."
msgstr ""
-#. pwwij
+#. M54Co
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id561708281595885\n"
"help.text"
-msgid "<emph>-2</emph>: binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned."
+msgid "<emph>-2</emph>: binary search that relies on <emph>Search Array</emph> being sorted in descending order. If not sorted, invalid results will be returned."
msgstr ""
-#. Ysd77
+#. hMFJt
#: func_xlookup.xhp
msgctxt ""
"func_xlookup.xhp\n"
"par_id551718627629229\n"
"help.text"
-msgid "<emph>MatchType</emph> values 2 and 3 cannot be combined with binary search (<emph>SearchMode</emph> value <emph>2</emph> or <emph>-2</emph>)."
+msgid "<emph>Match Mode</emph> values 2 and 3 cannot be combined with binary search (<emph>Search Mode</emph> value <emph>2</emph> or <emph>-2</emph>)."
msgstr ""
#. fHQrZ