[Solved] Avery 2160 label template request

[KenAZ]

Avery 2160 label template request.
Thank you

***Cancel request, I made one. Wasn't as difficult as I thought
Thanks

[RoryOF]

Any additional letters attaching to the 2160 label package?

[KenAZ]

No, no letters or data source attached. Just doing a simple page at a time.
Thanks

[John_Ha]

1. File > New > Labels.
2. Labels. Brand > Avery Letter Size
3. Scroll to 2160 Addressing.

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.

[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.

[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.

[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

[KenAZ]

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.

[John_Ha]

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 (10.69 KiB) Viewed 12232 times

[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

[John_Ha]

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 (2.3 KiB) Viewed 12226 times

The AOO template descriptor cannot handle the gap - it assumes the vertical pitch remains constant.