source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 5a4f9fe6afa18531f7403df99e555ea04d96e9b6
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Tue Sep 28 18:55:09 2021 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Tue Sep 28 19:07:23 2021 +0200
Resolves: tdf#144770 MATCH() remove plain wrong statement about unsorted
array
In since the initial 2004 commit. Whatever idea that was, it's wrong.
Change-Id: Ic54bed36b832d223e96d42efdee1a2f8067b6c41
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122784
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 43333f2de..2a8ff6cd9 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -341,7 +341,7 @@
<paragraph xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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. This applies even when
the search array is not sorted. For Type = -1, the first value that is larger
or equal is returned.</paragraph>
+ <paragraph xml-lang="en-US" 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 first
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 xml-lang="en-US" id="par_id3155343" role="paragraph">
