On 2011-06-10 6:04 PM, NoOp wrote: > On 06/10/2011 12:48 PM, Tanstaafl wrote: >> 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.
> Can you post a sample somewhere? I know that when you turn on 'Auto > Filter' in Excel and LO it will add a dropdown filter button to the > header. But I've not seen an 'Sort' button on a column header. Crap... yeah, that's what I was seeing... But I just can't imagine this is so hard... I just want to be able to click a column header, and have that execute a 'Sort Rows B3 thru Y18 by column R in descending order'... Then, if I click the column header again, have it sort it in the opposite order. And yes, I know a database would be better for this, but it isn't a database, the boss wants it done in a spreadsheet... and I'm not a VB (or whatever the equivalent is in calc) programmer)... -- 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
