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.
Cell A9 should contain 0, but instead shows
If I change cell A8 to
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…
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?