Jim Watson ha scritto:
...zot
Please look at menu Tools - Options - OpenOffice.org Calc - General
Look at checkbox in Input Settings - "Expand references when new column/rows are inserted"

I was able to reproduce the error you described, only if this box is checked. In that case the first cell address in the SUM range is not changed, so that sometimes the sum formula cell will end up inside the formula range, which is an error.

Thank you Jim... problem solved!

:-)

Bart

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to