Context LibreOffice 4.2.0.4 running on Mageia 4 (x86_64)
I want to be able to construct one or more new rows of data for a Calc spreadsheet offline (eg CSV) then import them via a macro when I start Calc.
If all rows are in the CSV, I think you don’t need a macro to do it.
Go through Menu/Insert/Sheet, set up how every field must be imported and mark the link option, don’t forget to set up how it must be updated when opening the file in Menu/Tools/Options/LibreOffice calc/General - updating.
Also you can update at any time in Menu/Edit/Links.
Thanks, mariosv. That works by creating a new sheet. It is, of course, trivial to cut the data from that sheet and paste it into the sheet I’m trying to update. I was looking for a way to insert the rows directly. I don’t see why it’s necessary to maintain links - it is a one-off operation.
Mantain the link is your choice, but if the file has always the same name, it can simplify your operations.
Maybe this extension can help: http://extensions.libreoffice.org/extension-center/pyfeaturing