source/text/scalc/01/04060109.xhp | 8 +++-----
1 file changed, 3 insertions(+), 5 deletions(-)
New commits:
commit 5beb12ef9f0c6099867dafbe1f16c7b43f6bdbb5
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Aug 28 11:34:30 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri Aug 29 00:33:44 2025 +0200
tdf#168064 Precision on MATCH function
+ Added a note on using type = +1 or -1 and the lookup array is not sorted.
Change-Id: I226173274805fb69317edee191c8097f3892b4f1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190334
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 55fb3696dd..2113b86067 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -344,12 +344,10 @@
<paragraph id="par_id3159152" role="code">MATCH(Search; LookupArray
[; Type])</paragraph>
<paragraph id="par_id3149336" role="paragraph">
<emph>Search</emph> is the value which is to be searched for in
the single-row or single-column array.</paragraph>
- <paragraph id="par_id3159167" role="paragraph">
- <emph>LookupArray</emph> is the reference searched. A lookup array
can be a single row or column, or part of a single row or column.</paragraph>
- <paragraph id="par_id3147239" role="paragraph">
- <emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or
if this optional parameter is missing, it is assumed that the first column of
the search array is sorted in ascending order. If Type = -1 it is assumed that
the column in sorted in descending order. This corresponds to the same function
in Microsoft Excel.</paragraph>
+ <paragraph id="par_id3159167"
role="paragraph"><emph>LookupArray</emph> is the reference searched. A lookup
array can be a single row or column, or part of a single row or
column.</paragraph>
+ <paragraph id="par_id3147239" role="paragraph"><emph>Type</emph> may
take the values 1, 0, or -1. If Type = 1 or if this optional parameter is
missing, it is assumed that the first column of the search array is sorted in
ascending order. If Type = -1 it is assumed that the column in sorted in
descending order. This corresponds to the same function in Microsoft
Excel.</paragraph>
+ <note id="par_id3147528">Unpredictable results are expected if
<emph>Type</emph> takes values -1 or +1 and the <emph>LookupArray</emph> is not
sorted.</note>
<paragraph id="par_id3154265" role="paragraph">If Type = 0, only
exact matches are found. If the search criterion is found more than once, the
function returns the index of the first matching value. Only if Type = 0 can
you search for regular expressions (if enabled in calculation options) or
wildcards (if enabled in calculation options).</paragraph>
- <paragraph id="par_id3147528" role="paragraph">If Type = 1 or the
third parameter is missing, the index of the last value that is smaller or
equal to the search criterion is returned. For Type = -1, the index of the last
value that is larger or equal is returned.</paragraph>
<embed href="text/shared/00/00000001.xhp#regex"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3155343" role="paragraph">
