Hi My first post, so be gentle...
I would like to insert a row in the next one above the row containing a SUM formula, and have the inserted row be a part of that SUM formula. I am sure this used to work with OpenOffice (there was even an option to "update cell references" in the Options) but it's not working with LibreOffice 3.3.2 e.g. 1 Description Amount 2 Chair £10.00 3 Table £45.00 4 £55.00 If I place my cursor on A4 and Insert --> Row, I want the cell B4 to be part of the SUM in B5. Download test file here:- http://www.paully.co.uk/not_updating.ods Thanks! -- View this message in context: http://nabble.documentfoundation.org/Calc-Insert-Row-just-above-SUM-row-does-not-carry-through-formula-tp2725066p2725066.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
