You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/01/14 09:13:59 UTC

[Issue 118473] MATCH() returns wrong value for large values

https://issues.apache.org/ooo/show_bug.cgi?id=118473

hanya <ha...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
                 CC|                            |hanya.runo@gmail.com
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #2 from hanya <ha...@gmail.com> ---
The help content says in MATCH function: 
> MATCH(SearchCriterion; LookupArray; Type)
> 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.
Therefore the results are correct in the attached document.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.