Hi :) The problem is that sometimes you might want to sort Column A independently of the other columns but at other times you want the whole worksheet to get sorted keeping the rows or "record's fields" together.
Excel has made a mistake in trying to muddle those 2 separate functions together so now their results are unpredictable or is difficult to get working the non-default way. I think Calc still offers the versatility allowing single columns to be sorted without changing the order of other columns. Base is excellent if you want to keep all the fields of a record together and can use tables/worksheets without having to change their formats. Regards from Tom :) ________________________________ From: Arda Tunccekic <[email protected]> To: [email protected] Sent: Tue, 18 January, 2011 11:21:58 Subject: Re: [libreoffice-users] How to sort this dataset in Calc? Thank you, it works. :) I wish it could also be done by clicking on Column A and clicking on the Sort Icon (simpler) On 18.01.2011 12:30, Stefan Weigel wrote: > Hi Arda, > > Am 18.01.2011 11:08, schrieb Arda Tunccekic: > >> I have a dataset like this. There are empty rows. >> Is there a way to sort these values by choosing the first column? > (1) Select the whole range from "90" on the top left to "g" on the > bottom right, including the empty cells. > > (2) Use the TAB-Key to navigate the active cell within your > selection to a position in the first column. > > (3) Click the Sort-Icon > > Stefan -- 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 ***
