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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jul 19 20:57:16 UTC 2019


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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Looks like some kind of bug:

a1: 212,50000000000000000000    =(105 * 1,75 + 50) / 1,1
a2: 212,50000000000000000000    =ROUND(A1;16)
a3: 212,00000000000000000000    =ROUND(A1)

a5: 212,50000000000000000000    =VALUE("212,499999999999999999")
a6: 213,000     =ROUND(A5)

-- 
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/20190719/f465538c/attachment.html>


More information about the Libreoffice-bugs mailing list