Ask Your Question

Labels start offset for partially used label sheets

asked 2019-11-29 09:27:54 +0200

Pele gravatar image

updated 2020-08-30 23:46:35 +0200

Alex Kemp gravatar image

I am really struggling to find an answer to this. I print say 7 labels on a sheet of 3x8 (24) labels. I come back next week and need to print another 5. I must use a brand new sheet as the one with 17 left is unusable with current mail-merge print dialog.

Can someone please implement a simple "offset" tick box and a number of labels to skip before labels start printing on a sheet? Unless there is already such a function somewhere but I cannot see it?

edit retag flag offensive close merge delete


If there is no such functionality, this site is not the right place to address enhancement requests (see Ask/Getting Started.

Opaque gravatar imageOpaque ( 2019-11-29 11:47:21 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-11-29 23:32:43 +0200

Ratslinger gravatar image


There is no easy method to do this currently. However can offer this workaround - a real "KLUDGE" if you allow me.

First create the initial Writer with the labels and database to be used. Save this as it will be a form to use for all printing. Here is my starting sample:

image description

Now you can use this to print labels which occupy more than one sheet.

To start printing at a specific label you need to delete some of the defined formats on the sheet. However the sheet is protected from doing this. A setting needs to be changed. From menu Tools->Options then under LibreOfficeWriter->Formatting Aids remove the selected Enable cursor under Protected Areas:

image description

Select OK and you are back on the formatted page. Now with the left mouse button you can select a label (click on the frame of the label) then delete. Result such as:

image description

Now you can print your labels BUT do not select more records than will fit on the remainder of the one page. Going to a second page will skip the deleted labels. Result:

image description

Do not save the Writer file as you will lose the basis for other printings. Also remember that the write protection mode is off.

edit flag offensive delete link more


Beautiful! I'll look into writing some sql code to do this for me but for now this will do nicely.

Pele gravatar imagePele ( 2019-11-30 10:26:02 +0200 )edit

Thank you very much - works for me!

JamesAB gravatar imageJamesAB ( 2019-12-15 19:50:51 +0200 )edit

answered 2019-12-13 13:44:27 +0200

Pansmanser gravatar image

I have an address book using basic macros to do just this. It will print one label at any point, or a number starting from any point. It is specific to one size of label (24 on A4 sheet), but could be adapted.


edit flag offensive delete link more



Tried your sample - works great. Figured a macro would provide some type of solution but personally had little interest in doing this for personal use.

The only down side, and certainly not negative as to what you have here, is that most likely the people who have asked this question have little experience is writing or modifying macros. There has even been a question where the only use (seemingly) of LO was once per year to print labels.

May try in future to utilize your process with what users select to arrive at something more universal. Have another year before the on-rush of those looking to produce labels for the holidays!

Again, nice work!

Ratslinger gravatar imageRatslinger ( 2019-12-13 20:05:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-29 09:27:54 +0200

Seen: 271 times

Last updated: Dec 13 '19