Re: [libreoffice-users] data order

Hi Tom,

Thanks for that, a much more sophisticated tool. However, the behaviour 
I described gets round the particular 'bug' Paolo described.

Barry

On 06/01/13 01:41, Tom Davies wrote:
> 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