[Libreoffice-bugs] [Bug 126481] An option for Rounding mode in ScInterpreter::ScRound

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Jul 20 11:27:52 UTC 2019


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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #3 from Regina Henschel <rb.henschel at t-online.de> ---
I think, that is nothing about rounding. That are the usual problems with
converting between decimal and binary numbers and with double arithmetic.
For example compare (show 15 decimal places)
=233.75/1.1-212
=233.75*(1/1.1)-212
or
=100/3-33
=100*(1/3)-33
=1000/30-33
=10/0.3-33
[The purpose of the parts -212 and -33 is to make differences in the last bits
visible.]

-- 
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/20190720/b9526231/attachment.html>


More information about the Libreoffice-bugs mailing list