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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 24 19:38:09 UTC 2018


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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |bibisected,
                   |                            |bibisectRequest, bisected

--- Comment #5 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
code changed with:

Resolves: tdf#73081 *) empty <> not-empty is also a match if numeric
This simplifies to match empty for the same conditions whether
numeric or not, an empty string does not result in numeric 0 here.

https://gerrit.libreoffice.org/plugins/gitiles/core/+/88f10aed35c19cc43a88bbcd12b026cb32c0003f

*) tdf#73081
COUNTIF with criterium <>number does not count empty cells.
https://bugs.documentfoundation.org/show_bug.cgi?id=73081

-- 
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/20181124/4a9fc0b2/attachment.html>


More information about the Libreoffice-bugs mailing list