[opensuse] LibreOffice : labels
Hi, Any LibreOffice specialists here ? I have a spreadsheet containing members of an organisation containing their title, name, amount paid, etc. I want to make membership-cards, so I made a database referring to the spreadsheet. Then I defined a label to have three labels on a A4-page and defined the relationship between it and the database. Then I created the layout, with a number of fields. So far so good. But when I print the document, I get a page of three labels of the same record, then on the next page three labels of the next record, etc. That's not what I need, I need one label of each record. What did I do wrong ? I know I did this with a previous version of LibreOffice. I don't remember which version though, standard version of OS 12.2 I believe, but I can find that if needed (old disk). Running OS 13.1, LibreOffice 4.1.5.3 (stock opensuse). Koenraad -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Op vrijdag 9 mei 2014 09:48:37 schreef Koenraad Lelong:
Hi,
Any LibreOffice specialists here ? I have a spreadsheet containing members of an organisation containing their title, name, amount paid, etc. I want to make membership-cards, so I made a database referring to the spreadsheet. Then I defined a label to have three labels on a A4-page and defined the relationship between it and the database. Then I created the layout, with a number of fields. So far so good. But when I print the document, I get a page of three labels of the same record, then on the next page three labels of the next record, etc. That's not what I need, I need one label of each record.
What did I do wrong ? I know I did this with a previous version of LibreOffice. I don't remember which version though, standard version of OS 12.2 I believe, but I can find that if needed (old disk).
Running OS 13.1, LibreOffice 4.1.5.3 (stock opensuse).
Koenraad
You may find a how to on the following URL. http://www.niiranen.fi/Tech-Blog/how-tocreatemailinglabelsorstickers%E2%80%9... -- fr.gr. Freek de Kruijf -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
op 09-05-14 11:41, Freek de Kruijf schreef:
You may find a how to on the following URL. http://www.niiranen.fi/Tech-Blog/how-tocreatemailinglabelsorstickers%E2%80%9...
Well, that's what I did. It seems not enough. I had to add a "next record" command. But the tutorial is for LO3. I'm using LO4. With LO3 I made labels like described there and it worked. Koenraad. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 05/09/2014 03:48 AM, Koenraad Lelong pecked at the keyboard and wrote:
Hi,
Any LibreOffice specialists here ? I have a spreadsheet containing members of an organisation containing their title, name, amount paid, etc. I want to make membership-cards, so I made a database referring to the spreadsheet. Then I defined a label to have three labels on a A4-page and defined the relationship between it and the database. Then I created the layout, with a number of fields. So far so good. But when I print the document, I get a page of three labels of the same record, then on the next page three labels of the next record, etc. That's not what I need, I need one label of each record.
What did I do wrong ? I know I did this with a previous version of LibreOffice. I don't remember which version though, standard version of OS 12.2 I believe, but I can find that if needed (old disk).
Running OS 13.1, LibreOffice 4.1.5.3 (stock opensuse).
Koenraad
You need to insert a "next record" field. In the document you have your labels defined in, go to the last item defined in each label and: Insert (pulldown)--> Field-->Other-->(database tab)Next record This should help in your problem. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
op 09-05-14 14:54, Ken Schneider - openSUSE schreef:
You need to insert a "next record" field. In the document you have your labels defined in, go to the last item defined in each label and:
Insert (pulldown)--> Field-->Other-->(database tab)Next record
This should help in your problem.
Hi, Indeed, that did the trick. Just curious, do you happen to know if this changed since LO3something ? I don't find this very intuitive. Anyway, thanks, Koenraad. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 05/09/2014 05:05 PM, Koenraad Lelong pecked at the keyboard and wrote:
op 09-05-14 14:54, Ken Schneider - openSUSE schreef:
You need to insert a "next record" field. In the document you have your labels defined in, go to the last item defined in each label and:
Insert (pulldown)--> Field-->Other-->(database tab)Next record
This should help in your problem.
Hi,
Indeed, that did the trick. Just curious, do you happen to know if this changed since LO3something ? I don't find this very intuitive.
Anyway, thanks,
Koenraad.
No I don't. I first ran into this when working on a club roster 6-7 years ago. I don't remember if I found the answer in the docs or via a Google search. Glad I was able to help. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (3)
-
Freek de Kruijf
-
Ken Schneider - openSUSE
-
Koenraad Lelong