First time here? Check out the FAQ!
answered 2013-06-04 00:44:18 +0100
Enable the Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.
Instead of add data, use insert row below the last row with data.