https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Winfried Donkers <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |winfrieddonkers@libreoffice
| |.org
--- Comment #10 from Winfried Donkers <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
