Printing Labels from Calc

Discuss the spreadsheet application

Printing Labels from Calc

Postby JahRu » Wed Apr 01, 2009 1:06 am

Okay! So I want to print labels from the data in my spreadsheet. Something tells me this is probably really simple but I can't seem to find any answers. Here's what I'm dealing with:

I want to make labels to go on items that need to be distributed. Across the top of the sheet is the item description, with the names of my customers down the left hand side. The quantity is listed under the item. I would like to print a label for each item. The format for the label should have the item name, the customer and I would like the number of labels to reflect the number of items orderd. For example, if John ordered 2 of A and 1 of B, I would like 2 labels printed for A and 1 for B.This seems simple enough as I mentioned, but........
OOo 3.0.X on MS Windows Vista
JahRu
 
Posts: 2
Joined: Wed Apr 01, 2009 12:49 am

Re: Printing Labels from Calc

Postby acknak » Wed Apr 01, 2009 2:30 am

OOo has only one way to automate the creation of labels: you can "merge" data from a database into a Writer document that sserves as a template for the labels.

The database can be a spreadsheet, but it must conform to the basic structure of a database table. I.e., all data that belongs together--that pertains to the same thing--is stored in exactly one row of the table, and each column in the table holds data of the same type and describing the same attribute.

E.g. if each row pertains to one label, you might have: Column A: Item Name, Column B: Customer Name

Then you can set up a label template in Writer and merge in the data, one row providing the data for one label.

You can find a good introduction to making labels in OOo here: http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17424
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Printing Labels from Calc

Postby JahRu » Wed Apr 01, 2009 6:06 am

[Table=]Name Silicone Spatula Silicone Baking Mat Silicone Square s/2
Name 1
Name
Name
[/Table]

I hope I did this right. This is a sample of what I am working with. I think this is what you described, no?
OOo 3.0.X on MS Windows Vista
JahRu
 
Posts: 2
Joined: Wed Apr 01, 2009 12:49 am

Re: Printing Labels from Calc

Postby TheGurkha » Wed Apr 01, 2009 3:14 pm

Not quite, you need the data for each item to be on a single row, like this:

2009-04-01_141047.jpg
2009-04-01_141047.jpg (25.42 KiB) Viewed 968 times
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests