https://bugs.documentfoundation.org/show_bug.cgi?id=94394
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |INVALID
--- Comment #1 from Eike Rathke <er...@redhat.com> ---
Of course Calc uses IEEE 754 double precision floating point values. However,
that does not resolve the fact that not all decimal numbers are exactly
representable in binary floating point formats. That is not a fault of Calc and
Calc is not the only spreadsheet program suffering from it. See also
https://support.microsoft.com/kb/78113 and
https://blogs.office.com/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/
and https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel and
http://floating-point-gui.de/
Other algorithms could be implemented, but only at the cost of performance on
large data sets, which would be a different RFE.
If you need exactly rounded results you have to use the ROUND() spreadsheet
function wherever appropriate or activate the Tools->Options->Calc->Calculate
"Precision as shown" option, which rounds every result to the precision of the
number format that is used to display the value.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
