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 <[email protected]> >To: Tom Davies <[email protected]> >Sent: Sunday, 6 January 2013, 2:29 >Subject: Re: [libreoffice-users] data order > > > > > >________________________________ > From: Tom Davies <[email protected]> >To: Barry Say <[email protected]>; "[email protected]" ><[email protected]> >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 <[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
