Syindication
Getting the contents of a table or query into an OpenOffice.org Calc spreadsheet
Tue, 05/20/2008 - 17:47
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.
You have already tagged this post. Your tags:
Similar entries
- Getting the contents of a table or query into an OpenOffice.org Calc spreadsheet
- Un-displaying the grid lines in OpenOffice.org Calc
- Un-displaying the grid lines in OpenOffice.org Calc
- How to turn your spreadsheet into a database for mail merges in OpenOffice
- Making changes to an OpenOffice.org chart in Draw
- Quirks in OpenOffice.org Writer 2.x notes (comments) that you can easily get around
- Table and table-text flow control features for OpenOffice Writer
- Download this graphic if you want lines in your OpenOffice.org Impress presentations
- Sun Report Builder Extension
- How to apply multiple colors or other fills to a shape you draw in Openoffice.org Draw
