[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