[Libreoffice-bugs] [Bug 124286] ROUNDDOWN is inaccurate with decimal numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190324/8f49e72e/attachment-0001.html>