diff options
| author | Eike Rathke <erack@redhat.com> | 2021-09-28 18:55:09 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2021-09-28 19:07:23 +0200 |
| commit | 5a4f9fe6afa18531f7403df99e555ea04d96e9b6 (patch) | |
| tree | 442f5439288eb14254a77194fd15f8d015957f7e /source/text/scalc | |
| parent | 7a89e385e842191c215e407541a96343fbb5dc97 (diff) | |
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@redhat.com>
Tested-by: Jenkins
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 43333f2de6..2a8ff6cd9e 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"> |