[Libreoffice-bugs] [Bug 123785] count functions count also empty fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
I'm not quite sure it's a bug.

OpenDocument v.1.2 documentation on COUNTIF (part 2, 6.13.9) [1] refers to
4.11.8 Criterion; and that section tells this:

> Note: "=0" does not match empty cells.

... which might imply that "<>0" does match empty cells as negation of "=0"...
Maybe Eike has a better explanation.

[1]
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018360_715980110

-- 
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/20190301/36dc3c75/attachment.html>