Creating a custom label problem

users
#1

LO 5.2.7.2

I cannot find a way to create a label on 8.5 X 11 page labels, where the label height is .67". The sheet of labels is 15 rows by 4 columns.

Such a template would be compatible with the following Avery labels: 18195, 42895, 5155, 5195, 8195, 15695, 18695, 88695, 48335, 38667, 42995, 18294

Adding to this difficulty is the fact that when you try to type into the input fields, apparently random numbers simply appear.

Known problem?

#2

HI,

You are right. The fields for user-defined layouts seem to adjust
themselves randomly (looks like a validation problem where the value
that is entered is validated before the cursor leaves the field). The
only way I was able to create something that looks like what you are
looking for is to:

1) Create an empty document.
2) Adjust the page margins to match the cutout locations of your Avery
label sheet (Format -> Page -> Page).
3) Insert a 1 row/4 column table that has no headers and no borders; if
your margins are correctly set, the table should now occupy the full
usable width of the page and each cell should be of the correct width.
4) Adjust the height of your row by right-clicking in a cell and
selecting "Size" -> Row Height. Set it to 0.67 inch.
5) Once this is done, go to the rightmost cell and insert a new row by
hitting TAB (the new row will be of the same height as the first one).
Do this until you have the correct number of rows on your page.

You may need to play with the Spacing to Content (Table -> Properties
-> Borders) of the cells to position the text inside the cells so it
stays clear of the cutout lines.

Not fantasticly user friendly but it should do the job.

I hope this helps.

Rémy Gauthier.

LO 5.2.7.2

> I cannot find a way to create a label on 8.5 X 11 page labels, where

the

label height is .67".  The sheet of labels is 15 rows by 4 columns.

Such a template would be compatible with the following Avery labels: 
18195, 42895, 5155, 5195, 8195, 15695, 18695, 88695, 48335, 38667, 
42995, 18294

> Adding to this difficulty is the fact that when you try to type into

the

#3

Hi, Remy,

Or, you could just create a table of 15 rows, and do the height adjustment for all rows at once. <G>

Then, there's the option of using the Avery template that's available, but I think it requires the Avery software. I did not investigate that option.

Or, you can do what I did. I used a different program that had one of the Avery labels in the list, and got it done. <G>

#4

Hi Ken,

Unsure if 'glabels' will run on your Mac but it have does templates
for the Avery 15 x 4 series.

Goer

#5

Hi, gordon,

Thanks for the suggestion.

I just looked, and there is no Mac specific download for it. I have the impression that a lot of Linux/Unix software will run on the Mac, but I don't know how to do that level of installations.

Doing it doesn't really turn me on anyway. LO

#6

If you go to the Avery.com site and create an account you can use their
online label tool. It's fairly easy to use and allows you to save your
"projects" for future use. I printed the result to PDF and used the PDF to
create labels as needed. It's helpful to have access to a high end printer
(like at work) which can feed the label stock more precisely than the
inexpensive printers typically used at home.

#7

Hi,

I'm using LO 5.1.6.2 in UbuntuStudio 16.04.2 LTS

I never used to have a problem setting up labels on a custom brand of A4
sized label sheet. But in the current version I'm using, when I come to
setting up a custom label, the standard user sheet size is 10.00 x 10.00
cms. Trying to reset that to A4 size (21.00cm x 29.7 cm) also gets me
funny numbers not exactly random but either 10.00 x 10.00 or 56.00 x
56.00. There is no option for A4 or any other standard sheet size.

After much fiddling, I got it set up by :

1. setting page dimensions to 21.00 and 29.70 by using the spinners

2. setting the label width to 7.00 by putting the cursor in the
horizontal pitch box and spinning the number down from the default of
10.00 to 7.00 - this takes the label width box down in parallel

3. setting the label width to 4.20 by putting the cursor in the vertical
pitch box and spinning the number down from the default of 10.00 to 4.20
- this takes the label height box down in parallel

4. setting up 3 columns
5. setting up 7 rows
6. leaving left margin and top margin at the default of 0.00

If I try to set columns before setting up label width, the page size
changes to multiples of the column width - bringing the columns back
down to 1 doesn't take the paper width back to the carefully set value.

In steps 2 and 3, if I put the cursor directly in the width/height
boxes, this did not bring down the corresponding pitch boxes but they
could be brought down afterwards without difficulty other than the time
it takes.

Using the spinners is a bit like watching paint dry but once the cursor
is in the field, you can use the up / down arrows instead of the mouse.
Don't try a short cut of page up/ page down because that just resets the
page to 10.00 x 10.00 or 56.00 x 56.00

I was able to set my label user values like this and to save them
successfully.

Philip

#8

It's my preferences, but I try not to do things online, since doing things at home are often faster than the lag I have doing things online. Plus, if my internet goes down, I can still do the work. <G>

But I rarely have the need for a high end printer. :slight_smile:

#9

IOW, it's broken. :slight_smile:

#10

Well, I would say that's a slight exaggeration. The set up of the user
sheet is 'handicapped' rather than broken, certainly degraded from what
I knew in the past.

But I can set up label content and print them out on my set of label
sheets. Once set up, it saves and sticks so it is usable but not
friendly and should be fixed. :slight_smile:

#11

To me, if it doesn't work right, it's broken. :slight_smile: