Am 17.03.2015 um 16:37 schrieb hw:
Am 16.03.2015 um 15:57 schrieb hw:
Some experimentation is required at this point ... Thank you for all
the replies so far!
Ok so I made a new spreadsheet and dragged a query from the datasources
view into it. Apparently that fills rows in the spreadsheet with the
data obtained from the query.
This can be useful and doesn't exactly seem to be what I would want in
each case: What if the data in the underlying tables changes? Will the
spreadsheet be updated automatically?
Click any single cell in that import range and call Data>Refresh
A one-line macro can update this on file open.
You can also set a flag to that import range to not store the data
within the spreadsheet. In this case you hit Enter when are prompted to
update the unsaved import data on file open.
You find this option under menu:Data>Define... pick your import range,
You can add a timer to the import range so it updates every x seconds.
[Tutorial] Using registered datasources in Calc:
What if I edit the data in the spreadsheet? I suppose I cannot update
the underlying tables through the query. So I pulled a table into the
spreadsheet and after an hour or so, I had to kill LO because it didn't
seem to do anything anymore.
Your edits will be lost on next refresh.
For database input you can add a true input form to this spreadsheet
document or any other office document (Writer, Calc Draw).
In some cases you may use the data source window for data entry into
updatable record sets.
To unsubscribe e-mail to: firstname.lastname@example.org
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
- Re: [libreoffice-users] Re: database2spreadsheet (continued)
Impressum (Legal Info)
: 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