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
