On Mon, Nov 17, 2008 at 6:05 PM, Cor Nouws <[EMAIL PROTECTED]> wrote: > Hi Adam,
Hi, Cor! > Adam Victor Nazareth Brandizzi wrote (6-11-2008 21:12) >> I have a spreadsheet with a list of values, let's say, at the interval >> B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row >> between B8 and B9, the formula at the now B10 cell is not updated. >> >> Is there a simple way to make this formula automatically update >> itself? [...] > > Apart from answers already given: there is an option that might help: > Tools|Options|OOoCalc|General > Expand references when new columns/rows are > inserted. > > Does that work for you? That is exactly what I was looking for, and it worked perfectly! Thank you a lot! > Regards, > Cor Best regards, -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
