[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
So yes, the "<>0" condition matches empty cells now, to comply with ODFF and
interoperability with other spreadsheet implementations, see also comment 3
about Excel that does the same. The previous behaviour that excluded empty
cells was wrong and a bug.

An empty cell is not a number 0 in this context.

See also ODFF 4.11.8 Criterion
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__434502_49873571
"For <>, if the value is not empty it matches any cell content except the
value, including empty cells. "

-- 
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/20181203/4c66e8de/attachment.html>