https://bugs.documentfoundation.org/show_bug.cgi?id=128312
Sam <serge...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Ever confirmed|0 |1
Resolution|NOTABUG |---
--- Comment #3 from Sam <serge...@gmail.com> ---
(In reply to Mike Kaganski from comment #2)
> This is normal: computers represent numbers as binary numbers, and not all
> decimal numbers are representable as finite binary floating-point numbers.
> E.g., a simple 0.1 is not finite in binary form.
>
> See http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems.
>
> Users working with fractional numbers should account for that.
>
> Closing NOTABUG.
We can't seriously expect home & business users to know about IEEE 754,
'floating point' and 'mantissa'. A significant number of people have very
limited knowledge of math. What our users will notice is that 31000.99 -
32000.12 does not equal -999.129999999997.
Microsoft Excel and Google Sheets do not exhibit this behaviour. Even VisiCalc
from 1981 (https://www.pcjs.org/apps/pcx86/1981/visicalc/) does not exhibit
this behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs