Re: [libreoffice-users] data order

Hi :)
Select all the rows or columns you want to sort and then (notice the "Data" menu between "Tools" 
and "Window")

Data - Sort

and then use the drop-downs to select which column you want to sort the data by.  
Regards from
Tom :)  






> ________________________________
> From: Barry Say <barry12@nspipes.co.uk>
> To: users@global.libreoffice.org 
> Sent: Saturday, 5 January 2013, 15:55
> Subject: Re: [libreoffice-users] data order
>
> When I have adjacent columns in a calc table and do a sort on a given column, a dialogue box opens 
> asking me whether I want to sort one column or many.
>
> Would this help you?
>
> Barry
>
> On 05/01/13 15:38, Paolo Debortoli wrote:
> > hi. I am preparing a calc file with 2 sheets; one with the results of matches and a first league 
> > table in alphabetical order; the second with the same  league table, but ordered by points, 
> > ranks. If I order the 'total points' column, it orders just thi colums, leaving the others 
> > unchanged (giving the points to the wrong team - bug?). then should i build a long list of 
> > complex nestled 'if' functions for each cell (trying, but gives more errors); using 'max' 
> > function it selects just the higher one value (but without possibility of excluding higher 
> > values or so -  could it be modified ?)   ....  suggestions ?
>
>
> -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted