Re: [libreoffice-users] data order

Hi :)
+1
There were 2 reasons why i think Barry's answer was better.  
1.  It gets the job done faster and deals with exactly the problem as described
2.  Barry got his answer out much faster

There is often more than 1 way to do something and the lists and forums are a good way of getting 
more than one answer.  It's one of the ways we act as a team.  'Traditional' telephone support and 
the "ask an expert" approach relies on a single person's viewpoint which may not suit every user 
and answers may vary depending on who you happen to get when you phone in and what mood they happen 
to be in at the time.  
Regards from
Tom :)  






> ________________________________
> From: Barry Say <barry12@nspipes.co.uk>
> To: users@global.libreoffice.org 
> Sent: Sunday, 6 January 2013, 9:13
> Subject: 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
-- 
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