https://bugs.documentfoundation.org/show_bug.cgi?id=168064
--- Comment #8 from Olivier Hallot <[email protected]> --- (In reply to Mike Kaganski from comment #7) > (In reply to Olivier Hallot from comment #6) (snip) > In principle, we must only explain what happens when it is sorted, and warn > that it won't work on unsorted, not to hint on what the result could be in > unsorted case. > (snip) I agree. The ODF standard [1] does not specify what happens with Type +1 and -1 values if the lookup array is not sorted. Thus, I think this is implementation-dependent and as you point, if Calc uses a binary search, the results is indeed unpredictable. [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#__RefHeading__1018430_715980110 "If MatchType is 1 or -1, evaluators may use binary search or other techniques so that they do not need to examine every value in linear order." -- You are receiving this mail because: You are the assignee for the bug.
