[Solved] Re: [libreoffice-users] data order

Hi :)

I have not played around with it but in 

Data - Sort - Option
is an options to "Copy sort results to" and it looks like the empty field there could either be for 
a new sheet name or for a file-name.  I'm not sure which.  


This type of sorting and displaying data is best done by a database approach rather than as a 
spreadsheet and Base might be able to read your spreadsheet as it's back-end data.  It would allow 
you to have multiple views of the data while still keeping just 1 copy of the data.  However that 
might take a while to set-up especially if you are not familiar with databases.  
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
https://wiki.documentfoundation.org/Faq#Base

Regards from
Tom :)  






> ________________________________
> From: Paolo Debortoli <paolo_debortoli@yahoo.com>
> To: Tom Davies <tomdavies04@yahoo.co.uk> 
> Sent: Sunday, 6 January 2013, 2:29
> Subject: Re: [libreoffice-users] data order
>
>
>
>
>
> ________________________________
> From: Tom Davies <tomdavies04@yahoo.co.uk>
> To: Barry Say <barry12@nspipes.co.uk>; "users@global.libreoffice.org" 
> <users@global.libreoffice.org> 
> Sent: Sunday, January 6, 2013 2:41 AM
> Subject: Re: [libreoffice-users] data order
>
> 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 :)  
>
> yes, thanks guys.  my error was selecting just one column...  selecting multiple columns and going 
> to data -> order -> parameters   I can set multiple columns in order.  I have just to reorder the 
> lines every time, but it is not a problem.  now it works, thanks.
>
>
>
>
> > ________________________________
> > 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