I realize this thread is a little long in the tooth by now but one aspect
(why?) of Mr Byrnes query is still dangling.
On January 12, 2014 12:57:16 PM PST, Jim Byrnes jf_byr...@comcast.net wrote:
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?
In the first example cell A3 became cell A4 so the function call became
SUM(A1:A4) but in the second example cell A3 remained where it started so there
was no reason to alter the function call. Let's suppose that that function call
was elsewhere on the sheet (e.g. G1) instead of directly below the numbers
being summed. There would be no expectation for the function call to be
adjusted. Right? I found the answer that pointed to an option that handles this
issue when adding a row to be educational.
Thanks, Jim
--
Another Jim
--
To unsubscribe e-mail to: users+unsubscr...@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