On Sun, 09 Oct 2005 22:54:26 -0300, Josias Almeida wrote: > When we use the function sum() ou subtotal() associated with a range of > cells and we try to shift part of the cells, the new range of cell in > the function box doesn's change as it is supposed to happen. > See the spreadsheet below.
How are you shifting the cells downward? When I do it via Insert new cells the formula is changed correctly. p. -- Using OOo 2.0 rc2 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
