Ask Your Question

how do I print a whole page of one label?

asked 2017-07-08 08:47:54 +0200

sumaruc gravatar image

updated 2017-07-08 16:15:20 +0200

I am trying to print multiple copies of one label on a page.


That was the problem. Printing now works.

But why does the document show the field name and not the contents? The toggle for view->field names shows either the full database reference, <database.table.field> or just <field> but not the contents of the field

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-08 13:58:10 +0200

sumaruc gravatar image

Thanks. This just doesn't work. I've followed all the steps as described in the manual: made a spreadsheet then 1) Choose File > New > Labels. 2) On the Options tab, ensure that the Synchronize contents option is selected. 3) On the Labels tab (Figure 326), select the Database and Table. Select the Brand of labels to be used, and then select the Type of label. 4) If you are unable to identify your label product in the list, then you can define the labels you have. Select ... 5) You can now save your label template if you are likely to use it again. Click Save. 6) In the Save Label Format ... 7) Click the Labels tab. Click the drop-down arrow under Database field. Select the first field to be used in the label ... 8) Continue adding fields ... 9) Click New Document. You now have a new, single-page document containing a series of frames, one for each label of the selected type and filled with the data source address fields that you selected.

I then followed the steps for removing blank lines, and inserting Next record:Database.Table and then synchronised the labels. Then file-print and choose to print only record 1 to 1 or (select record 1 and choose selected records).

I have tried all sorts of cominations of the above work flow but only ever see one label per page in the print preview pane. My labels are 8 per page in 2 columns and 4 rows. The page in the document looks as expected. I was doing this successfully in Word but decided not to try this program instead. Your help is appreciated.

edit flag offensive delete link more


@sumaruc - It would have been better to add a comment to your question (or to edit it) rather than adding an answer ... which is not.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-07-08 15:01:46 +0200 )edit

answered 2017-07-08 09:08:58 +0200

pierre-yves samyn gravatar image

updated 2017-07-08 15:01:18 +0200


This is explained in this FAQ.


In your case (if I understand correctly), do not insert the "Next record" field: the next record applies automatically when the page is changed.

The example attached works with the bibliography installed by default with LibreOffice. It prints pages of identical labels on each page.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-08 08:47:54 +0200

Seen: 827 times

Last updated: Jul 08 '17