[Libreoffice-bugs] [Bug 127624] COUNTIF irregular result

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to Winfried Donkers from comment #10)
> Created attachment 154277 [details]
> 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)
Except using "isNumeric"/"isText" function, how to distinguish them and above
all how to change them?
I only that know that if I put a simple quote before a number, it's considered
as text but the simple quote stays.
Also, when clicking to modify, sometimes the number is aligned at left,
sometimes at right.



> 
> 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
> ... 
> 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.

Just my personal opinion but ODFF standard should be the top priority compared
to Excel compatibility.

-- 
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/30621098/attachment.html>