[Libreoffice-commits] help.git: source/text
Eike Rathke (via logerrit)
logerrit at kemper.freedesktop.org
Tue Sep 28 17:07:42 UTC 2021
source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 5a4f9fe6afa18531f7403df99e555ea04d96e9b6
Author: Eike Rathke <erack at redhat.com>
AuthorDate: Tue Sep 28 18:55:09 2021 +0200
Commit: Eike Rathke <erack at 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 <erack at 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">
More information about the Libreoffice-commits
mailing list