[libreoffice-users] Re: database2spreadsheet

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,
[More Options]
You can add a timer to the import range so it updates every x seconds.

[Tutorial] Using registered datasources in Calc:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511


> 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: users+unsubscribe@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