[Libreoffice-bugs] [Bug 132990] The sum of these specific numbers all of which have a maximum of two decimal places produces a wrong result that has 14

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from roy.magne at indrebo.net ---
I reproduced the problem in version Versjon 6.4.4.2 (x64)
Build-ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff

I noticed this when I had a spreadsheet with several digits with only two
decimals. When I summed up the numbers the sum had more than two decimals

In a new sheet enter this in a cell:

=4.35-4.28

The sum I get is this:
0.069999999999999

I had expected this:
0.07

-- 
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/20200530/5e601dfc/attachment.htm>