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 <[email protected]> >To: [email protected] >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 <[email protected]> >>> To: [email protected] >>> 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: [email protected] >>> 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: [email protected] >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: [email protected] 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
