Running LO 3.5.7.2 on Ubuntu 12.04
If I have cells:
A1 = 2
A2 = 2
A3 = 2
A4 = =SUM(A1:A3) which equals 6
If I right click on the number 2 to the left of cell A2 to select that
row and then insert a row from the popup menu and enter the number 2 in
that blank cell, I get:
A1 = 2
A2 = 2
A3 = 2
A4 = 2
A5 = =SUM(A1:A4) which equals 8
If instead I right click on the number 4 to the left of cell A4 to
select that row and then insert a row from the popup menu and enter the
number 2 in that blank cell, I get:
A5 = =SUM(A1:A3) which equals 6.
If you need to insert a new row in a column of figures, right above the
cell where you calculate a total seems to be the natural place to do it.
So why doesn't the formula update when you do so?
Thanks, Jim
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
