Re: [libreoffice-users] How to sort this dataset in Calc?

Yeh, if you want all the columns sorted then it is best to open with Base 
instead of Calc.  It sounds as though your spreadsheet is now really a database 
and needs database functionality instead of spreadsheet functionality.  Don't 
panic!  It is quite easy to use!

Alternatively in Calc just select the full range of the data that all needs to 
get sorted and either get the white cell into the right column using the tab key 
or use an advanced sort to sort on multiple columns at the same time or to 
specify which column to sort on.

Regards from
Tom :)





________________________________
From: Stefan Weigel <stefan.weigel@bildungskreis.org>
To: users@libreoffice.org
Sent: Tue, 18 January, 2011 12:03:16
Subject: Re: [libreoffice-users] How to sort this dataset in Calc?

Hallo Sigrid,

Am 18.01.2011 12:56, schrieb Sigrid Carrera:

> *It only sorts the column that is highlighted* the rest of the other columns
> stay as they are.

I know what you mean. But since some time, in this case Calc shows a
special Dialog asking the user, if he really means, what he is
doing. (which I don´t like, BTW) ;-)

However this Dialog and the options it provides do not handle the
case with empty rows...

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***



      
-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***