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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Alain Touret <alain.touret at free.fr> ---
I tried the same on the 6.2.6.2 version of LibreOffice on Linux (build
1:6.2.6-0ubuntu0.19.04.1): the same behavior was observed.

I tried something more: 
1) I added a first column to compare two immediate values in the range column :
=EXACT(E3;E4) : it says that all equals values are equal (correct behavior)
2) dragging the first column in the range column onto the whole range. Then the
counif values columns are becoming equal and correct. 

The values in the range are pure numbers. However, are they considered
differently because some would be assimilated to TEXT values and other to
NUMBER values ?
As you can see in the attached file, the count is only correct in the first and
last lines.

-- 
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/20190918/db0631b2/attachment-0001.html>