Hi :) Excel does exactly the same thing. When i show/train people to use spreadsheets i try to get them to make the row above the totals row much smaller so that people leave that row blank. Generally people don't have time for that sort of thing and then have to spend hours trying to work out why their formulas don't work. I've never understood why spreadsheet programs are designed that way. Regards from tom :) On 12 January 2014 21:34, mariosv <mariosv@miguelangel.mobi> wrote:
Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Inserting-a-row-does-not-change-formula-tp4091882p4091887.html Sent from the Users mailing list archive at Nabble.com. -- 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
-- 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