[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