[Libreoffice-bugs] [Bug 127624] COUNTIF irregular result
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 19 06:23:29 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Winfried Donkers <winfrieddonkers at libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |winfrieddonkers at libreoffice
| |.org
--- Comment #10 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
Created attachment 154277
--> https://bugs.documentfoundation.org/attachment.cgi?id=154277&action=edit
simplified use cases
(In reply to Julien Nabet from comment #5)
I can explain what happens:
-if the cell to be compared and the criterion are of the same type, the
comparison result is true;
-if the cell to be compared is of type numeric and the criterion is of type
text, the comparison result is true, i.e. the cell to be compared is evaluated
as text;
-if the cell to be compared is of type text and the criterion is of type
numeric, the comparison result is false.
(see uploaded document, rows 3..6)
COUNTIF is defined in
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#COUNTIF
and the criterion is defined in
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Criterion.
In these paragraphs I cannot find explicit statements accepting or rejecting
the behaviour as described above.
The '=' operator, which can be used in the criterion, is defined in
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Infix_Operator_EQ.
Here the use of two different type should produce false as result. If we use
'=' in the criterion Calc does not comply with this. (see uploaded document,
rows 8..11)
I cannot say which is fully compliant with the ODFF standard and which is not,
probably Eike can tell.
Excel produces a result true for all 8 combinations used in the uploaded
document. However, if COUNTIF in Calc is compliant with the ODFF standard,
COUNTIF is not at fault, but we may need an Excel-compliant version of COUNTIF.
--
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/20190919/cdb253eb/attachment.html>
More information about the Libreoffice-bugs
mailing list