[libreoffice-users] Re: Updating a previously opened ods via Python script without closing LibreOffice

Create a dedicated directory.
Put your data.ods into that directory.
I would use .txt or .csv as file name suffix here.
File>New>Database...
Connect to existing database.
Type: Text
Specify .ods as name suffix, the column separator, encoding, text separator.
[x] Register the database
Save the database.odb and forget it.

Open main.ods.
Get the data source window (hit F4)
Browse your registered database and the table therein.
Drag the table icon from the left pane into your sheet.
menu:Data>Define...
Select "Import1" (the imported cells linked to the database table)
Button [More Options]
[X] Contains column headers (true for all import ranges)
[X] Keep formatting (=keep sheet cell formatting)
[X] Insert&Remove cells (=preserve, expand and shrink adjacent formulas)
[X] Do not store linked data (=prompt for update on open)
Button [Modify], [OK]
Save the spreadsheet.
########## END OF SETUP ##############

[Text file] --> [Base configuration] --> [Office document (Writer or Calc)]

Every time you open the spreadsheet, you will be prompted to refresh the 
linked (but not saved) database data coming from your text file actually.
menu:Data>Refresh performs a manual refresh.


--
For unsubscribe instructions e-mail to: users+help@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