<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - ROUNDDOWN is inaccurate with decimal numbers" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124286#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - ROUNDDOWN is inaccurate with decimal numbers" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124286">bug 124286</a> from <a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> Winfried Donkers</a> <pre>I understand the cause and in a way it is unavoidable. It is in most cases not possible with fractional numbers for the internal (binary) value to be exactly the same value as the (decimal) number. That means that the binary representation of 0.94 could be something like 0.939999999999999 (figures are an example, not actual values). Rounding down the latter will always produce 0.93. A similar problem will be visible with ROUNDUP for some values. I will see if I can find a way to avoid or at least significantly reduce the above phenomenon. As I don't know yet if that will be possible, I am not assigning the bug report to myself yet.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>