[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
Sun Nov 25 08:39:38 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=121696
Oliver Brinzing <oliver.brinzing at gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|6.1.2.1 release |6.1.3.2 release
--- Comment #7 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
the changed calulation started with lo 6.1.3.2,
lo 6.1.3.1 shows the previous behavior.
as mentioned above: opening a spreadsheet created with lo 6.1.3.2 in an older
version now will change formula result afer a hard recalc.
the change was intended:
an empty cell and a cell with formula ="" are same now (treated as <> 0),
formula ="0" is 0.
the "[ ] Treat empty string as zero" compatibility option seems to have no
influence. is this correct?
and the question is: which formula's are affected?
at least the release notes should mention the change and the documentaion
should be adjusted.
--
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/20181125/d068d2dd/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list