Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Create a dedicated directory.
Put your data.ods into that directory.
I would use .txt or .csv as file name suffix here.
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.
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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.