Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier to adjust the table style labels. To adjust the top spacing, simply adjust the top margin for the page. To adjust the column width, simply drag the column borders and the entire column is adjusted. At one time OpenOffice had these label templates available as an extension. I don't know if they still do or not. But they are available from World Label here: 
http://www.worldlabel.com/Pages/openoffice-template.htm
They can be downloaded individually, or all together as a pdf.
I've found them much easier to use and adjust, and have never used any other label templates since then. Also, when you enter the text or fields in them, the text is starts with being paced in the center of the label between the top and the bottom, and then as additional lines are added, the text of fields are automatically centered within the label itself, top to bottom. I've never used the standard templates with OpenOffice or LibreOffice since finding these. Nor have I wasted any sheets of labels because they didn't print properly. 

Don



On 12/16/2013 05:07 PM, John Clegg wrote:

I have just done my labels too - only using Avery 8165 (I just happened to
have some in the drawer) It worked find, but I too found the printing
started right on the edge - and I couldn't see any way to change this other
than adding spaces manually. I had to add a blank line at the top for the
same reason. Or is there a way that I have missed?


On 5 December 2013 23:37, Jeff Hahn <hahn.jp@outlook.com> wrote:


I use LO 4.1.3 and Windows 7.  I should repeat that in my case the first 2
columns print properly (although the print starts right at the edge of the
label).  It is only the third (right) column that is off.

Jeff Hahn


From: cuyfalls@hotmail.com
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels
Date: Thu, 5 Dec 2013 12:31:46 -0500

I just noticed this thread, and I have to chime in that, the last time I
tried to create labels, I too noticed that the LO Avery 5160 template
alignment was off. I had to adjust the contents of every cell. At that

time,

I was still using LO 3.5.x. I have not yet tried since upgrading to the
4.x.x range.

At the time, I just installed Apache OO, as its template worked properly.

If I recall correctly, I think there may have been other label templates
online as extensions that worked better than LO's label template.

Virgil

-----Original Message-----
From: Niklas Johansson
Sent: Thursday, December 05, 2013 12:20 PM
To: Jeff Hahn ; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

So I looked at the configuration in LibreOffice 4.0.6 and LibreOffice
4.2 beta-version and the configuration seems to be correct. I even
compared it to the result that I get in Word 2013 for the same label
(sorry for not thinking about doing that earlier). So before I put
anymore time into this it would be good to know what version of
LibreOffice you used when you created the labels?

Niklas Johansson

Jeff Hahn skrev 2013-12-05 17:22:

I think the configuration in the wizard may be wrong.  The Avery 5160

has

30 labels on a 8.5" x 11" sheet each measuring 1" x 2 5/8".  It is
probably one of the most common labels used so I am surprised the issue
hasn't previously been raised.  As I indicated in my email, I didn't

have

any problem when I switched to Word so I am reasonably confident the

issue

is not related to my printer.

Jeff Hahn



Date: Thu, 5 Dec 2013 17:04:24 +0100
From: sleeping.pillow@gmail.com
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

Hi Jeff

Is the issue that you used lable sheets of the type Avery 5160 and

that

the preconfiguration for these lables were wrong?
I think that I remember reading some issues with the label

functionality

(File -> New -> Label) in an earlier version of LibreOffice that

might

or might not be fixed in newer versions. What version of LibreOffice

did

you use?

Do you have any specifications for the measurements of these specific
labels so I can do a quick review if there seems to be any issues

there?

Note also that you can tweak the measurements under the Format tab of
the Labels-dialog. Not that you should need to if you use labels that
has a preset configuration.

Kind regards,
Niklas Johansson

Jeff Hahn wrote 2013-12-04 16:41:



I tried to do my labels for Christmas
cards using LO's mail merge. I was able to create the data base and
print without difficulty. Unfortunately, the entire third column

was not

properly spaced and printed outside of the label, a couple of

spaces to the left. The first two columns were they were supposed to

be. I

was using standard

configuration for Avery 5160. I finally gave up created the labels
with Excel and Word.




I am not sure where to send an email to
suggest that the matter be looked into so I am sending this
information to this list with the hope the matter will be picked

for

investigation. Also, although I suspect it has been suggested
before, it would be nice to be able to do a mail merge directly

from

the spreadsheet without creating a database file.




Jeff Hahn




--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?

http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more:

http://wiki.documentfoundation.org/Netiquette

List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot

be deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?

http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be

deleted
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




--

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Don C. Myers
Manager, Farm and Rural Property Division
e-PRO Certified by the National Association of Realtors
Don's Cell Phone: 814-571-9518, Don's Home Phone: 814-422-8111
Don's E-mail: donmyers@myersfarm.com <mailto:donmyers@myersfarm.com>
*RE/MAX Centre Realty
**1375 Martin Street, State College, PA 16803*
Office Phone: 814-231-8200 Fax: 814-231-8220
Visit the Farm and Rural Property Division web site at _www.CentralPaRuralProperty.com <http://www.CentralPaRuralProperty.com/> _ Visit the RE/MAX Centre Realty main web site at _www.StateCollegeHomeSales.com <http://www.statecollegehomesales.com/> _ 
View Don's Farm Web Site at www.myersfarm.com <http://www.myersfarm.com/>
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.