[Libreoffice-bugs] [Bug 114295] Calc addition is broken: 751.19+(-700.1) != 51.09

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
It's a known fact in computer world that decimal floating point numbers can't
be accurately represented as binary floating point numbers and specifically
adding or subtracting numbers may introduce an error margin.

See also
https://support.microsoft.com/kb/78113
https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers
https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

This is similar true in Calc.

-- 
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/20171213/77996db5/attachment.html>