Getting the contents of a table or query into an OpenOffice.org Calc spreadsheet
For the longest time, the really easy way of bringing database content into a document didn't work in Calc spreadsheets. At least, not for me. But now in 2.4 it does. So here you go. It's the same approach you use in Writer, just a little more limited.
Choose View > Data sources or press F4.
Expand the DB you want, then the table or query you want. Select the table or query name.
Click on the upper left corner as shown, the un-obvious little gray square.
Click and hold down and drag into the document. And you'll get your data.
Choose View > Data sources or press F4.
Expand the DB you want, then the table or query you want. Select the table or query name.
Click on the upper left corner as shown, the un-obvious little gray square.
Click and hold down and drag into the document. And you'll get your data.
I guess data is not linked? If the data in database changes is it reflected in the spreadsheet? Is it possible to refresh data without manually dragging data again (refresh button? auto refresh? close&open spreadsheet document?) I badly need linking feature.
DataPilot is not what I need.
Posted by: linked? | August 31, 2008 at 06:30 PM
Hi "linked",
It isn't linked with this approach but it is if you do it this way
http://openoffice.blogs.com/openoffice/2007/05/wayyyyy_simpler.html
and choose to bring in the data as fields.
Posted by: Solveig | August 31, 2008 at 06:38 PM