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

Hi :)

I have just noticed details of the example you gave.  You might be in luck!  
Most of us have suffered from the problem at one time or another so you are NOT 
alone! :)

Please email me the spreadsheet before going any further in case it goes 
horribly wrong.  Or at least take a back-up.  Just back-up by making a copy 
under a different name.  I generally add the date in reverse date-order so that
customers.xls
is backed-up as 
customers-2011-04-15.xls
I try to copy one of these to a different machine every few months or sooner if 
i update it a lot.

When sorting a spreadsheet you have to be careful because the columns are 
independant of each other, unlike in a database.  So, see the row numbers at the 
far left?  Click on one of those and it selects the whole row.  Then scroll all 
the way down to the bottom of the spreadsheet and press the shift key while 
clicking the row at the bottom.  Now all the rows should all be selected.  If 
all the rows are wholly selected then sorting will keep all the information on 
each row together.  another way of selecting all the rows in the entire 
spreadsheet is to press the Ctrl key and A (Ctrl A) or to click the little 
square at the top (ish) left, just above the row numbers and to the left of the 
column letters.  The disadvantage is that there are probably a LOT of blank 
rows.

If you want to try using a datbase then you can use the spreadsheet as it's 
data-source ;) so you have already created the table.  I would NOT do that until 
after getting the rows right again!
Good luck and regards from
Tom :)




________________________________
From: Zed <zed@zed.net.nz>
To: users@libreoffice.org
Sent: Fri, 15 April, 2011 0:44:19
Subject: [libreoffice-users] A "Sort" problem...

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
-- 
Zed
Bachelor: A guy who has cheated a woman out of a divorce.  

-- 
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
-- 
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