Hi :) In spreadsheets there is a danger with this. You can sort the single column without the rest of the rows getting sorted so that John Doe could end up being called John Dolittle while Eliza Dolittle ends up being Eliza Doe.
The better way is to select an area or all the rows and then use the tab-key (on the keyboard) to get the currently selected cell (the one with the large black border) into the column the you want to sort by. Then click the "A-Z" button (on the icon bar), or the Z-A if you want reverse order. Note it also sorts numbers and other ascii. Databases are better at keeping relevant fields locked together for a particular record/row. I think there is a way of defining a particular area in a spreadsheet to do this but it's a lot more flaky than using a proper database if you want to be able to add new rows/records. Calc, Gnumeric and Excel all act the same way. I haven't tried others such as google-docs or KOffice but i imagine they are about the same too. Good luck and regards from Tom :) ________________________________ From: Tanstaafl <[email protected]> To: [email protected] Sent: Fri, 10 June, 2011 20:48:58 Subject: [libreoffice-users] Add a 'Sort' button to the tops of columns? There has got to be a reasonably easy way to do this (by 'reasonable', I mean a way that doesn't require me to become a programmer)... How do I add a 'Sort' button to the tops of columns, so that I can easily sort the data in a spreadsheet on different columns simply by clicking the button in the column header? I've seen these in spreadsheets I get from Excel users all the time, but for the life of me can't figure out how to do this in Calc. -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
