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


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

Context


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.