On Fri, 11 Aug 2006 20:41:19 +0200 Andreas Saeger <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote: > > Hello > > When I insert a row just above a cell that has a sum total > > the sum formula does not adjust as it does in excel. > > ie: =SUM(B4:B29) does not changed to =SUM(B4:B30) > > > > thanks for listening > > Tools>option>Calc>General>"Extend References ..." 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. -- Will J G --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
