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]