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

Eike Rathke <er...@redhat.com> changed:

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

--- Comment #6 from Eike Rathke <er...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to