https://bugs.documentfoundation.org/show_bug.cgi?id=152774
Bug ID: 152774
Summary: MATCH returns incorrect result when searching for a
string in a mixed numeric/string matrix
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
=MATCH("a";{1;3;"b";"d"};1) returns 2 but should return #N/A.
ODF, 6.14.9 MATCH says for "MatchType = 1 or omitted" that "If Search is of
type Text and the value found is of type Number, the #N/A Error is returned."
Steps to Reproduce:
Enter
=MATCH("a";{1;3;"b";"d"};1)
in any cell in Calc.
Actual Results:
2
Expected Results:
#N/A
Reproducible: Always
User Profile Reset: No
Additional Info:
ODF, 6.14.9 MATCH says for "MatchType = 1 or omitted" that "If Search is of
type Text and the value found is of type Number, the #N/A Error is returned."
--
You are receiving this mail because:
You are the assignee for the bug.
