Labels start offset for partially used label sheets

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?

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

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.



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!


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:

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:

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:

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:

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

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

Thank you very much - works for me!