[Libreoffice-bugs] [Bug 133840] Calc Math error on INTEGER function

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #1 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Created attachment 161844
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161844&action=edit
int demo

Please have a look at the attachment:

If you add more decimal places you will see:
=MOD(A3,0.1)*100 results in 8,99999999999993

https://erack.de/bookmarks/D.html#Computer_Arithmetic_and_IEEE_754

btw: result in ms excel 2016 is 8 too.

-- 
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/20200610/c3f1974f/attachment.htm>