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
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.