Brian Barker wrote:
At 20:27 13/04/2010 +0200, Michelle Konzack wrote:
Now I have only to solve the sum(over) art which can only make the SUM
of a range of ROWS (eg C5 to C999) which does not work if I insert new
ROWS because the C999 is not updated to C1000.
In fact, the formula will be updated correctly if you add rows anywhere
except at the top or bottom of the row range. But adding such new rows
at the bottom is an obvious and common need, of course.
This is handled by an obscure global setting
Tools>Options...Calc>General: "Expand references when new rows or
columns are inserted"
With this option I can insert anywhere in A2:A6 and SUM(A2:A5) becomes
SUM(A2:A6).
Without this option I it only works within the referenced range A2:A5.
Keep this option on and turn it off when it becomes annoying which may
occur while rearranging a sheet, but not while using it as a database
replacement.
Hope this helps,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
