[libreoffice-users] Re: A "Sort" problem...

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 users+help@libreoffice.org
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