[Solved] Avery 2160 label template request

Using them, Making them , Finding them

[Solved] Avery 2160 label template request

Postby KenAZ » Wed Aug 21, 2019 5:06 pm

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
KenAZ
 
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

Re: Avery 2160 label template request

Postby RoryOF » Wed Aug 21, 2019 6:25 pm

Any additional letters attaching to the 2160 label package?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29473
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Postby KenAZ » Wed Aug 21, 2019 8:15 pm

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
KenAZ
 
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

Re: Avery 2160 label template request

Postby John_Ha » Thu Aug 22, 2019 1:18 pm

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.
AOO 4.1.6, Windows 7 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: 6775
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Postby RoryOF » Thu Aug 22, 2019 1:29 pm

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29473
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Postby John_Ha » Thu Aug 22, 2019 3:46 pm

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.
AOO 4.1.6, Windows 7 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: 6775
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Postby RoryOF » Thu Aug 22, 2019 3:52 pm

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29473
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Avery 2160 label template request

Postby KenAZ » Thu Aug 22, 2019 4:15 pm

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
KenAZ
 
Posts: 3
Joined: Wed Aug 21, 2019 4:55 pm

Re: Avery 2160 label template request

Postby John_Ha » Thu Aug 22, 2019 5:41 pm

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   Expand viewCollapse view
<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 131 times
AOO 4.1.6, Windows 7 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: 6775
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Postby John_Ha » Thu Aug 22, 2019 6:07 pm

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   Expand viewCollapse view
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.
AOO 4.1.6, Windows 7 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: 6775
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Avery 2160 label template request

Postby John_Ha » Thu Aug 22, 2019 6:18 pm

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 125 times

The AOO template descriptor cannot handle the gap - it assumes the vertical pitch remains constant.
AOO 4.1.6, Windows 7 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: 6775
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Templates

Who is online

Users browsing this forum: No registered users and 1 guest