keme wrote:For other situations I often create my own template with a table, measuring sheet size and margins and calculating label size from that. Set column width and row height, and disable automatic sizing. You may need to set the margins slightly smaller than measured.
So do I. You can download ready made OpenOffice templates from avery.com. Their templates consist of a table with the right cell dimensions and spaces between cells. Design one of the cells to your liking and copy the final result to the other cells. If you changed the table layout by mistake, just open another document from the template and copy over the cell content you have so far.
menu:Edit>Exchange Database... lets you choose the right query or table from your database.
menu:Insert>Fields>Other... tab:Database lets you insert placeholder fields for the database content. The last field in the cell should be a [Next Record] field. Otherwise you get one page with the same content in all cells which may be wanted in some cases (e.g. business cards).
The wizard produces a tiled set of frames rather than table cells but this is just another way to get the same tiled layout. The content of the tiles is the same.
If you can't get any fields from your database:
File>New>Database...
[X] Connect to existing database
Type: Spreadsheet (I assume)
[X] Register the database
Save the database and forget the database. Just don't delete it. It is just a configuration file. All your data are still in the spreadsheet (or whatever type of database you connected to).