https://bugs.documentfoundation.org/show_bug.cgi?id=96923
--- Comment #17 from [email protected] ---
Confirmed in LibreOffice 6.4.3.2.
See the attachment "Inconsistency between comparison order".
I get the following results:
1) If comparing a number to a number (2nd and 3rd argument to SUMIFS), we get a
match as expected.
2) If comparing a number to a string, we get a match.
3) If comparing a string to a number, we DON'T get a match.
4) If comparing a string to a number, but with an explicit equality operator
("="&) we get a match.
In Excel, all cases (1-4) result in a match. Because of the unexpected
inconsistency, I would say that this is indeed a bug, and that the Excel
behavior of having all four cases result in a match should be followed.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
