[Solved] Avery 2160 label template request

Using them, Making them, Finding them
Post Reply
KenAZ
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

[Solved] Avery 2160 label template request

Post by KenAZ »

Avery 2160 label template request.
Thank you

***Cancel request, I made one. Wasn't as difficult as I thought :-)
Thanks
Last edited by KenAZ on Thu Aug 22, 2019 2:42 am, edited 1 time in total.
Apache OpenOffice v. 4.1.5
Windows 10 Home
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Post by RoryOF »

Any additional letters attaching to the 2160 label package?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
KenAZ
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

Re: Avery 2160 label template request

Post by KenAZ »

No, no letters or data source attached. Just doing a simple page at a time.
Thanks
Apache OpenOffice v. 4.1.5
Windows 10 Home
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Post by John_Ha »

1. File > New > Labels.
2. Labels. Brand > Avery Letter Size
3. Scroll to 2160 Addressing.
Clipboard04.png
Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Post by RoryOF »

I had missed that the Label wizard allowed selection of different paper sizes, John (shows how few labels I print!).

I tried your suggestion and my (development) version of OpenOffice did produce a column of 8 labels, left aligned on the page. The little research I carried out on the Avery site showed thumbnails indicating that the actual labels should be centre aligned to the sheet, with a slight gap between the top four and the bottom four labels.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Post by John_Ha »

I wish I knew where the installed label and envelope templates are stored as I think some envelope templates are incorrect. I searched in the profile but they aren't there suggesting they must be hard coded in the application.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Post by RoryOF »

As far as I can see, the templates are stored, integrated into, the following file on my Xubuntu system, as part of the OO installation files
file:///opt/openoffice4/share/registry/main.xcd

I'm sure you'll be able to suss out the location on Windows.

If the .xcd is renamed to .xml, it will prettyprint or format using any XML editor. Some XML editors/formatter will do so without the need to rename to .xml
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
KenAZ
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

Re: Avery 2160 label template request

Post by KenAZ »

John_Ha wrote:1. File > New > Labels.
2. Labels. Brand > Avery Letter Size
3. Scroll to 2160 Addressing.
The attachment Clipboard04.png is no longer available
Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
Yes I have that but template is bad. No spacing between rows 4-5 and paragraph indent/spacing are slightly off. I just created my own.

Thank you for the response.
Attachments
2160 template.JPG
Apache OpenOffice v. 4.1.5
Windows 10 Home
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Post by John_Ha »

RoryOF wrote:As far as I can see, the templates are stored, integrated into, the following file on my Xubuntu system, as part of the OO installation files
file:///opt/openoffice4/share/registry/main.xcd
grep is a lovely command! It's C:\Program Files (x86)\OpenOffice 4\share\registry\main.xcd on W7 and indeed does have labels in it - the Avery 2160 Addressing template is as below. I will see if I can work out what the measures are.

Code: Select all

<node oor:name="L194" oor:op="replace" oor:finalized="true">
	<prop oor:name="Name">
		<value>2160 Addressing</value>
	</prop>
	<prop oor:name="Measure">
		<value>S;6680;2540;6680;2540;2057;1270;1;8</value>
	</prop>
</node>
I cannot seem to find envelopes in main.xcd. Can you look for Long Bond or #9 Envelope to see where envelopes are stored. Thanks.
Clipboard01.gif
Clipboard01.gif (10.69 KiB) Viewed 8826 times
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Post by John_Ha »

The values for the Avery 2160 Addressing label are <value>S;6680;2540;6680;2540;2057;1270;1;8</value>. I compared them with the values in the 2160 Addressing label template and it seems they are 1/100 mm giving:

Code: Select all

S;  presumably S = Letter size paper ????    
66.80mm;  Horizontal pitch 
25.40mm;  Vertical pitch
66.80mm;  Width
25.40mm;  Height
20.57mm;  Left margin
12.70mm;  Top Margin
1;     Columns
8      Rows
Clipboard01.gif
Last edited by John_Ha on Sun Aug 25, 2019 12:01 am, edited 2 times in total.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Post by John_Ha »

RoryOF wrote:The little research I carried out on the Avery site showed thumbnails indicating that the actual labels should be centre aligned to the sheet, with a slight gap between the top four and the bottom four labels.
Yes. The sheet isn't Letter width though it may be Letter long. The labels are grouped into a top group of four, a gap, and a lower group of four.
Clipboard02.gif
Clipboard02.gif (2.3 KiB) Viewed 8820 times
The AOO template descriptor cannot handle the gap - it assumes the vertical pitch remains constant.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply