Labels

users
#1

The Labels formatting seems utterly Kaput! No resemblance between what the formatting specifications are and what appears. I am on Windows 7 and and have LO 3.5.0rc3.

Sylvain

#2

Also, 3.5.1 did fix some of the issues with 3.5.0, so I wonder if they fixed that issue as well.

Are you using the "New/Labels", or are you using a preformatted sheet design?

I tend to load up a template with the label in blocks of a sheet of labels. Most larger label paper providers should either have their own label site so you can download the .doc sheet of labels, or will give you a generic Avery label reference and have you go there.

So are you using the sheet template and something is not correct, or are you going to the "New/Labels" section and getting the label design from there?

That is important to know who you are creating and formatting your labels, so we know what part of the process is going wrong.

#3

Hi Sylvain,

Instead of using the Microsoft type templates, I would suggest that you try the table style label templates for OpenOffice. I've had no problems with them in any of the OpenOffice/LibreOffice versions, including LibreOffice 3.5.1. There was/is? an OpenOffice extension for them, but they are also available here:
http://www.worldlabel.com/Pages/openoffice-template.htm

If you need to adjust the left margin, simply drag it from the top and the entire column will adjust. If you need to adjust the vertical alignment, simply change the top margin of the entire page. I never have a problem with the labels towards the bottom of the page running up into the label above like with the Microsoft style.

Don

#4

I am using File then New then Labels. I then requested instructions on width, columns, rows etc. but the output when I click on new document does not fit the instructions.

Sylvain

#5

I am using the new/labels approach. WordPerfect, which I used for many years before switching to Open Office and then to Libre Office had pre-formated Avery Labels. LO does not have the ones I use and so I tried to format by filling in the blanks on the new/labels blanks

Sylvain

#6

Hi Sylvain,

None of that is necessary with the table style templates.

Don

#7

Could you say a little more. Where do I find such templates?

Sylvain

#8

Hi Sylvain,

I used Word Perfect for many years. It was much better than Microsoft Word in how it handled labels. OpenOffice/LibreOffice use a very similar approach to Microsoft. In Word Perfect, if you had a list entered alphabetically, you could add or remove any individual label by simply deleting and moving the remaining ones up, or insert a new one by moving everything past where you wanted to enter the new label. In the Microsoft style, you can only add on to the end, and if you want to delete one in the middle somewhere, you deleted it, but then had a blank label if you wanted to keep things alphabetical. I presently have all of my addresses in base, and use that information for printing the labels with fields in the label form to pull in the information, letting Base putting them in alphabetical order using a mail merge in LibreOffice. Here is what I had written earlier today:

Instead of using the Microsoft type templates, I would suggest that you try the table style label templates for OpenOffice. I've had no problems with them in any of the OpenOffice/LibreOffice versions, including LibreOffice 3.5.1. There was/is? an OpenOffice extension for them, but they are also available here:
http://www.worldlabel.com/Pages/openoffice-template.htm

If you need to adjust the left margin, simply drag it from the top and the entire column will adjust. If you need to adjust the vertical alignment, simply change the top margin of the entire page. I never have a problem with the labels towards the bottom of the page running up into the label above like with the Microsoft style.

If you are using a database and pulling the information in from fields, I can send you some additional information to help you using the table style forms. If you are making a label form with the information in that you want (no fields or database, and the information is the same in all of the labels, simply enter the information in the first label. Then copy it and paste it in the other labels in that row. When that is done, then copy the first row and paste it in the second and successive rows. I actually once I have the first two rows done, copy the first two rows and paste it in the balance of the sheet doing two rows at a time.

Don

#9

Try the template page for the North American DVD, as well as looking at the Template Center that LO has.

http://libreoffice-na.us/English-3.4-installs/templates.html

http://templates.libreoffice.org/template-center

In the NA-DVD page, there are a few label templates here that use with OOo years ago, when I used it instead of MSO. There use to be an EXE file that added a "special" template manager to the Windows OOo, along with more templates, but I do not know if it ever worked with OOo 3.0.0.

When I stated about using a .doc template, that is what is easiest to find. Having places, like WordLabel, having .odt templates are getting easier to find. I hate sites that give you only .docx templates. That is not the best type of site to use.

The thing I tend to do is save working files of label that work for the size/shape needs I had [back when I was doing them more]. Then I would just edit the labels to the new design.

Having the option to do the New/Label is good, but you really need to know pretty EXACT dimensions for the margins of the paper, as well as the label size. THEN, you have to worry about your printer's print margins. I have 3 working printers within arm's reach and I would not like to try to create all my needed labels with the New/Labels option. Actually, I tend to stick with Avery templates, if I can get then.

To be honest, if you go and do a search for purchasing labels for your size, the package for those labels generally keep an up-to-date idea where you can get a template for your label or paper type. I have some "tent cards" that have preprinted backgrounds and the company has specific templates for each and every paper style and decoration. Finding a site that has your specific label paper needs should also have where to get the needed template for those labels.

To be honest, if you can search on a company's specific label sheet number, it would be easier. Every one of my packages of labels have a "compare to Avery" reference number. So it is easy to search Google for sites that might have templates for these labels, other than Avery itself. If the label sheets are still in production, then there should be a ready made template for it.
<http://libreoffice-na.us/English-3.4-installs/templates.html>

#10

Sylvain,

Go to avery.com, look for the software tab, select design and print online.
All the labels are there, you can import from any database, and you print
on your desktop printer. It just works.

Mark

#11

Thank you! That solves my problem.

Sylvain

#12

Sylvian, DON,

I have the experience, that labels is working perfect in LO 3.5.
Start with a adreslist in Calc with the simple headers of Name, Zip code,City etc. And save this file, of course.
Then start Writer, New, Labels
Select in Edit, Change database and select one. Please, take care, that there will be a page in the Calc-file
Then select in View, Source.
You will be presented with a Base-copy of your selected file. Move the requested items from the database tot the label e.g. <database> item
Once the labels items are completed, print and you will have the labels.

Paul

-----Oorspronkelijk bericht-----