https://bugs.documentfoundation.org/show_bug.cgi?id=123408
--- Comment #2 from Eike Rathke <[email protected]> ---
That is due to loss of precision when using the IEEE 754 floating point format.
All computer software not using binary coded decimals or other means to correct
precision round-offs suffers from it. See
http://0.30000000000000004.com/
https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel
https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/
If you format the cells involved to two decimals, for example 0.00 then that
format will be used in the status bar as well and the result displayed
accordingly rounded.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
