[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Apr 12 11:00:47 UTC 2021


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

--- Comment #6 from Uwe Auer <uwe at franke-auer.de> ---
(In reply to Chuck from comment #5)

> Uwe Auer, your solution also works. Thanks for the work-around.

Thanks, but it is not meant as a workaround but the way it needs to be done
using spreadsheet applications and when doing math with computers using a
binary representation of decimal values, which inherently is only an
approximation to the decimal value. This binary approximation causes a small
difference and when using functions like SUM this difference is added as well
and you get error propagation.

-- 
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/20210412/bf3ff567/attachment.htm>


More information about the Libreoffice-bugs mailing list