Stevie wrote:I think there is an error that keeps adding up the longer the calculation is.

It is not a Calc error - it is a user error because the user does not understand how Calc (or any spreadsheet) operates.

If I set A1, A2and A3 to

- Code: Select all Expand viewCollapse view
`=1/3`

then each cell contains 0.333333333333333. That is an accuracy equivalent to measuring the distance from London to New York to about 1/100 of 1 millionth of an inch.

If

I choose to set the cells so that only 2 digits show I

see 0.33 but the cell

contains 0.333333333333333. Calc calculates with the actual cell values, not the shortened versions the user chooses to display.

When I sum A1 + A2 + A3 I see 1.00, and not 0.99, because 0.333333333333333 + 0.333333333333333 + 0.333333333333333 is equal to 1. There is a minor factor that Calc carries a non displaying extra digit which forces the sum to be 1.00000000000000.

- Code: Select all Expand viewCollapse view
`0.33`

0.33

0.33

1.00

If

I choose to display no figures after the decimal

I see 0 + 0 + 0 = 1, which is, of course, correct as Calc has used the actual value for the sum.

So, in your spreadsheet set each cell to display, say, 6 digits. You will see that C1 is actually 5.10100..., and not the displayed 5.1, a "difference" of 0.001. Sum lots and the "differences" accumulate to be as large as you want.