source/text/scalc/01/func_xmatch.xhp | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-)
New commits: commit de354a5e67e0e079d471c3ba7d806044f997c238 Author: Stanislav Horacek <stanislav.hora...@gmail.com> AuthorDate: Sat Jul 20 22:19:06 2024 +0200 Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com> CommitDate: Sat Jul 20 22:54:15 2024 +0200 use same names of XMATCH arguments as in UI Change-Id: I1ce3a68d071bdccb1caa9af3c4389d8c0db82979 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170805 Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com> Tested-by: Jenkins diff --git a/source/text/scalc/01/func_xmatch.xhp b/source/text/scalc/01/func_xmatch.xhp index 7817ca451f..63de31ab20 100644 --- a/source/text/scalc/01/func_xmatch.xhp +++ b/source/text/scalc/01/func_xmatch.xhp @@ -28,20 +28,20 @@ <paragraph role="paragraph" id="par_id321716754048322">XMATCH outperforms function <link href="text/scalc/01/04060109.xhp#Section12">MATCH</link> as it allows searches according to the search mode.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id211708281649651">XMATCH(Lookup; Array [; MatchType [; SearchMode ] ] )</paragraph> -<paragraph role="paragraph" id="par_id861708281340704"><emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>.</paragraph> -<paragraph role="paragraph" id="par_id831708281625340"><emph>Array</emph>: is the reference of the array or range to search.</paragraph> +<paragraph role="code" id="par_id211708281649651">XMATCH(Search criterion; Search Array [; Match Mode [; Search Mode ] ] )</paragraph> +<paragraph role="paragraph" id="par_id861708281340704"><emph>Search criterion</emph>: The value of any type to search for in <emph>Search Array</emph>.</paragraph> +<paragraph role="paragraph" id="par_id831708281625340"><emph>Search Array</emph>: is the reference of the array or range to search.</paragraph> -<paragraph role="paragraph" id="par_id121708281643207"><emph>MatchType</emph>: (optional) specifies the match type. Values can be:</paragraph> +<paragraph role="paragraph" id="par_id121708281643207"><emph>Match Mode</emph>: (optional) specifies the match type. Values can be:</paragraph> <list type="unordered"> <listitem> - <paragraph id="par_id111708281542144" role="listitem"><emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found, then return the #N/A error.</paragraph> + <paragraph id="par_id111708281542144" role="listitem"><emph>0</emph>: exact match (default). If <emph>Search criterion</emph> value is not found, then return the #N/A error.</paragraph> </listitem> <listitem> - <paragraph id="par_id851708281548335" role="listitem"><emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item.</paragraph> + <paragraph id="par_id851708281548335" role="listitem"><emph>-1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next smaller item.</paragraph> </listitem> <listitem> - <paragraph id="par_id801708281553430" role="listitem"><emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item.</paragraph> + <paragraph id="par_id801708281553430" role="listitem"><emph>1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next larger item.</paragraph> </listitem> <listitem> <paragraph id="par_id881708281558005" role="listitem"><emph>2</emph>: a <link href="text/scalc/guide/wildcards.xhp">wildcard</link> match where characters *, ?, and ~ have special meanings.</paragraph>