Am 15.04.2011 01:44, Zed wrote:
Using LibreOffice 3.3.1 on LinuxMint Debian Edition (LMDE)
I have created a spreadsheet in Calc as a Customer database, which I will
save as a CSV file and use to create form letters.
The columns are: Firstname, Surname, Street, Town, City, Postcode,
Salutation.
I originally sorted them Surname, Firstname, Town and got what I expected.
However, somehow I have made a complete "pigs ear" with a subsequent sort,
and for the life of me I cannot remember the three fields on which I chose
to sort, and the Salutation field is now not aligned with the correct
surname. For example, the customer name is Faye Abel and the Salutation
should be Dear Faye. However it is Dear Marion!
My question is, apart from completely retyping the correct Salutation, is
there any sort method by which i can have the correct salutation aligned
with the correct surname?
Zed
Your mail merge is based on a database document which reads the csv
files for any text or spreadsheet document. You can use the database
interface in the data source window (F4) or mail merge dialog for
sorting, filtering and/or picking manually selected row sets.
You can also define fixed sort orders and/or filters by means of
queries. A query derives a virtual table where the original table data
can be shown in any order of rows and columns. Queries are stored in the
database and they can be used in the same way the original tables.
--
Unsubscribe instructions: E-mail to [email protected]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
