https://bugs.documentfoundation.org/show_bug.cgi?id=147669
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC| |[email protected] --- Comment #2 from Mike Kaganski <[email protected]> --- Note also, that it works with =MATCH("2";{"2"|"3"};0) => it gives the expected 1. 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. [1] https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#MATCH -- You are receiving this mail because: You are the assignee for the bug.
