https://bugs.documentfoundation.org/show_bug.cgi?id=147669
--- Comment #7 from Mike Kaganski <[email protected]> --- (In reply to Mike Kaganski from comment #2) > MATCH with MatchType = 0 is defined in ODFF 1.3 [1] differently compared to > MatchType = 1 and MatchType = -1; for the two latter, there's explicit "If > Search is of type Text and the value found is of type Number, the #N/A Error > is returned", while for the former, no such clause exists, implying that the > return value of 1 is really expected here. I take this back. The explanations about sorting order in the standard clarify the "If Search is of type Text and the value found is of type Number" clauses in 1/-1 cases: it may happen, that with sorted search, the value *greater than* the numeric Search may happen to be a text after the numeric block. For that, the clauses explain what to do. On the other case, the 0 case is "exact" search, for which, the found value must be equal to the Search - so the clause about different types is not applicable. So it's up to the settings of the program, not to the standard. -- You are receiving this mail because: You are the assignee for the bug.
