Ask Your Question
0

Can I construct a new row of data for Calc, then import it via macro? [closed]

asked 2014-05-07 13:43:42 +0200

Grimble gravatar image

updated 2015-09-06 22:20:58 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-22 11:02:19.519113

1 Answer

Sort by » oldest newest most voted
0

answered 2014-05-08 00:25:01 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

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.

Grimble gravatar imageGrimble ( 2014-05-08 13:31:59 +0200 )edit

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/ext...

m.a.riosv gravatar imagem.a.riosv ( 2014-05-08 21:12:42 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-05-07 13:43:42 +0200

Seen: 82 times

Last updated: May 08 '14