[Libreoffice-bugs] [Bug 126970] Function "SUM()" work doesn't correct if final result is zerro.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Created attachment 153465
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153465&action=edit
sum example

i think, this is the normal behaviour if one uses IEEE 754 standard for
floating point calculation.

even excel has same problems, e.g.:
https://support.microsoft.com/de-de/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel

4th example in attached spreadsheet will result in 0 (LO) and 2,04636E-12
(excel)

-- 
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/20190817/a157128c/attachment.html>