<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - the sum of this selection is wrong, an offset of 1/100." href="https://bugs.documentfoundation.org/show_bug.cgi?id=123408#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - the sum of this selection is wrong, an offset of 1/100." href="https://bugs.documentfoundation.org/show_bug.cgi?id=123408">bug 123408</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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 <a href="http://0.30000000000000004.com/">http://0.30000000000000004.com/</a> <a href="https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel">https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel</a> <a href="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/">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/</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>