print template for chart? addressbook without empty cells

[soren]

Is there a function where each row of a spreadsheet is taken as a separate record, and I can specify a kind of template how to print the record? If so, where do I specify such a template, and how can I make empty cells to be ignored?

My application is at the moment to simply print a standard addressbook as exported by firefox. This gives a spreadsheet with columns like "name", "street address", "email" and also many of often but not always empty cells like "alternative email" etc. In a first lesson I simply want to print the cells of each record line by line, with empty cells being ignored, and probably a manual description added, something like

name: NAME1
address: ADDRESS1
email: EMAIL1

name: NAME2
address: ADDRESS2
email: EMAIL2
email: ALTERNATIVE_EMAIL2

[Villeroy]

Link the firefox address book to a Base document (read-only):
File>New>Database...
[X] Connect to existing database
Type: [Mozilla Address Book]
[Next >>]
[X] Yes, register database [Solved] What is "register the database"?
[X] Open database for editing
[Finish]
Save database as *.odb

Have a look at the table(s)
Go to the queries container and create a query (filtered set of table data)

Since you registered the database, you can use it in Writer and Calc

[soren]

Thanks for the helpful hint. I have now registered the addressbook, make a new writer document, press F4 to open the data source view, and successfully selected the entries.

The next dialog lets me define a print template like

<name> <vorname>
<email>
<adresse1>; <adresse2>; <phone>

and so on, which also works as expected. My next question: is it possible to do more sophisticated things in this template dialog? For example, if email field is empty I don't want to see an empty line but no line at all. Or if there is no address in the current data set, I don't want to print the semicolon separators. Probably there is some kind of "programming language" which allows testing for empty fields and stuff like that?