source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 5c8e8358756f7e5f62e5b6fd24410e59797bdf05
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Thu Nov 25 18:26:37 2021 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Thu Nov 25 18:38:16 2021 +0100
Fix MATCH() Type=-1, index of last >= value is returned
Change-Id: I8b84e60cb626ee3b0df334cb1b41d3ef9da4e209
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125824
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 8457ba3f3..17fb83262 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. 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 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 xml-lang="en-US" id="par_id3155343" role="paragraph">
