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 <[email protected]> To: [email protected] 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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
