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

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 <arda@duzen.com.tr>
To: users@libreoffice.org
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 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 ***