[Solved] Label Formatting

Using them, Making them , Finding them

[Solved] Label Formatting

Postby Wildfire2099 » Fri Jan 24, 2014 7:17 pm

Hi everyone! First post... hoping you guys can help, or point me somewhere this answer already exists.

I use return address labels for price tags in our store (the Avery 5167 labels). I was able to find how to generate them, but I'm having difficulty getting the fields to do what I want. Specifically, I want to 'lock' them in place, so that if the text in the field is too long, the extra just drops off, instead of running into the next field. I'm assuming there's an easy button for that, but I can't find it.

Any assistance would be greatly appreciated.

Thanks!
Last edited by Hagar Delest on Fri Jan 24, 2014 10:38 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.0 on Windows 8
Wildfire2099
 
Posts: 19
Joined: Fri Jan 24, 2014 7:11 pm

Re: Label Formatting

Postby acknak » Fri Jan 24, 2014 8:08 pm

Greetings and welcome to the community forum!

I believe you can do this if you use a table to contain the fields and set the column width & row height to specific sizes. This prevents Writer from changing the table layout and any "extra" text will just be clipped.

Another approach (which seems cleaner to me) is to use a special database query as the data source. You should be able to apply a function to the columns to limit the number of characters (sorry, I don't know the details of how to do that).
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Label Formatting

Postby Wildfire2099 » Fri Jan 24, 2014 10:25 pm

The Table method worked... I agree the other way sounds more precise, but that's more figuring out than I have time for right now... maybe once I've broken in this new inventory program ;)

Thanks for the help!
OpenOffice 4.0 on Windows 8
Wildfire2099
 
Posts: 19
Joined: Fri Jan 24, 2014 7:11 pm


Return to Templates

Who is online

Users browsing this forum: No registered users and 2 guests