Page 1 of 1

[Solved] Avery 2160 label template request

Posted: Wed Aug 21, 2019 5:06 pm
by KenAZ
Avery 2160 label template request.
Thank you

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

Re: Avery 2160 label template request

Posted: Wed Aug 21, 2019 6:25 pm
by RoryOF
Any additional letters attaching to the 2160 label package?

Re: Avery 2160 label template request

Posted: Wed Aug 21, 2019 8:15 pm
by KenAZ
No, no letters or data source attached. Just doing a simple page at a time.
Thanks

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 1:18 pm
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.

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 1:29 pm
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.

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 3:46 pm
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.

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 3:52 pm
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

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 4:15 pm
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.

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 5:41 pm
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 9112 times

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 6:07 pm
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

Re: Avery 2160 label template request

Posted: Thu Aug 22, 2019 6:18 pm
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 9106 times
The AOO template descriptor cannot handle the gap - it assumes the vertical pitch remains constant.