On Fri, 11 Aug 2006 21:13:10 +0200 Andreas Saeger <[EMAIL PROTECTED]> wrote:
> Folderol wrote: > > > Interesting. Does this also apply to deleting a row in the middle of a > > block of lines? I'd always thought this was a bug and worked round it. > > > > Have you tried? > Numbers in A1:A10, A11: =SUM(A1:A10), A12: =FORMULA(A11) > Unset "Extend references ..." > Insert in A2:A10 always extends the summed reference. > Deletion in A1:A10 always shrinks the summed reference. > Now set "Extend References..." > Insert in A1 extends the summed reference. > Insert in A11 extends the summed reference. Still makes a complete mess of it :( The formula I have in column F(n) is: =F(n-1)-C(n)-D(n)+E(n) This produces a running total. Adding or removing a line screws up the rest. I have to do a 'fill down' on the F column (hmmm, appropriate) covering the cells either side of any insertion or deletion. Ideally I would like to be able to just copy in (or out) a block of lines from another part of the spreadsheet. -- Will J G --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
