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

2014-01-12 Thread Tom Davies
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 wh

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

2014-01-12 Thread Jim Byrnes
On 01/12/2014 03:34 PM, mariosv wrote: Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. Thank you, that worked. I'm curious why without that setting I can insert a row in the middle of a column of n

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

2014-01-12 Thread mariosv
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