Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.