[libreoffice-users] Inserting a row does not change formula

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: users+unsubscribe@global.libreoffice.org
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