Ok, i have a weird one here. Calc has always done what was expected, until I ran into a strange calculation.
I am running the standard Ubuntu distributed LibreOffice - Build ID: 1:5.1.6~rc2-0ubuntu1~xenial1
With the following spreadsheet
Beginning at A1, going down through A8. (numbers validated for accuracy - no hidden formatting - I initially thought I entered something wrong the first time, so manual entered it into a new sheet with the same result)
9.99
14.99
775.18
-26.44
-1.13
-280.24
-280.24
-212.11
In Cell A9, I put.
=SUM(A1:A8)
Cell A9 should contain 0, but instead shows
-1.22568621918617E-13
If I change cell A8 to
-212.1
Cell A9 shows 0.01 as expected.
Change it back to -212.11, and you get the weird result again.
Placing it in a single statement like…
=SUM(9.99,14.99,775.18,-26.44,-1.13,-280.24,-280.24,-212.11)
Also results in the correct answer of 0.
Formatting on all cells is “number → general”
If I force the format to “number → -1234”, the display is correct.
Any ideas what’s going on?
Thanks,
Brent