[Solved] Bug in custom labels section

Using them, Making them, Finding them
Locked
dellr007
Posts: 1
Joined: Fri Sep 12, 2014 4:58 am

[Solved] Bug in custom labels section

Post by dellr007 »

The custom labels will NOT allow me to type in a label size greater than 2 inches tall. I typed in 5 inches and it corrected it to 2 inches for me and THEN the resulting page printed in landscape not portrait even though portrait was selected as the wanted method by the print dialog.
Last edited by MrProgrammer on Wed Oct 28, 2020 6:26 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.1 on Windows 7
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: bug in custom labels section

Post by keme »

I have used different versions of Writer and never had a fault (IIRC). However, you need to set the measurements in correct order, and the auto-update preview can be annoying, especially when you try give measurements in a different unit from what is chosen as default.

I can try to make a template for you.
  • What size label do you need, and how large are the sheets (or do you use continuous paper)?
    Spacing between labels?
    How many labels per sheet/page (if appplicable)?
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: bug in custom labels section

Post by acknak »

Many people find the label pages that OO generates to be difficult to work with. It uses a series of text frames that have to wrap just right to give the necessary layout. This approach makes it easy to "clone" the contents of the first label into all the others, at the expense of a more complex layout method.

The alternative is to use a table, which is much easier to work with. The only problem is that any cloning of the content has to be done manually, by copy/paste.

If you're already making custom labels, you may want to skip the File > New > Labels ... approach altogether and just make your own table-based layout.
AOO4/LO5 • Linux • Fedora 23
DJandrews
Posts: 2
Joined: Tue May 31, 2016 3:39 pm
Location: Nova Scotia

Re: Bug in custom labels section

Post by DJandrews »

dellr007 wrote:The custom labels will NOT allow me to type in a label size greater than 2 inches tall. I typed in 5 inches and it corrected it to 2 inches for me and THEN the resulting page printed in landscape not portrait even though portrait was selected as the wanted method by the print dialog.
I had the same problem setting the height, and for me the answer was to change the setting for the number of rows first. So for 5 inch tall labels on letter size paper, you would only be able to have two rows, so enter this first, then it should let you set the height to 5 inches.
OpenOffice 4.1.2 on Windows 10
DJandrews
Posts: 2
Joined: Tue May 31, 2016 3:39 pm
Location: Nova Scotia

Re: Bug in custom labels section

Post by DJandrews »

I have also found that it will adjust the page dimensions even though you may have selected something like Avery letter size.

Everything looked ok on the screen and page preview, but it was not printing the last quarter inch on the right hand side of the page. Took me a lot of fiddling before I realized what was going on.

So always check Format, Page if it doesn't behave as expected.
OpenOffice 4.1.2 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Mail Merge with tables and linked, protected sections

Post by MrProgrammer »

acknak wrote:The alternative is to use a table, which is much easier to work with. The only problem is that any cloning of the content has to be done manually, by copy/paste.
I've used the table approach, but did the cloning via linked, protected sections. I find it easiest to refresh the links using File → Save, then File → Reload. I've attached an example. Look at Format → Sections. For a one-time job, copy/paste would be easier, but my file is a template that I use many times a year so the extra effort to create and link the sections was worthwhile.

 Edit: 2024-02-29: Tools → Update → Update All will refresh the section links 
 Edit: 2024-02-29: The end of the page gets an automatic Next Record, so do not put Next Record in the section, since that would copy it to every label. Instead put the Next Record field after the section in every label but the last one. 
Attachments
201606122015.ott
(8.9 KiB) Downloaded 404 times
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Bug in custom labels section

Post by acknak »

Very nice!

I'd never thought about using sections inside a table. Good to know that's an option.
AOO4/LO5 • Linux • Fedora 23
Locked