[Libreoffice-bugs] [Bug 96923] Criteria evaluation of COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=96923

--- Comment #17 from konton at gmx.com ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200528/05673c5f/attachment.htm>