[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