On 06/10/2011 03:34 PM, Tanstaafl wrote: > 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.
I've only see that (from google) done as a macro. > > 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)... > As for Autofilter. Autofilter is easy: Select the column(s) data area(s) in the columns & Data|Filter|Autofilter That will ask you if you want to use the first line to be used as the column filter if you do not have column headers defined already. Note: when opening an .xls with autofilters, LO will not include/show the autofilters in the .xls. Unfortunately you'll need to review the .xls in Excel/Excel Viewer & then add your own in LO. This probably should be (if not already) filed as a bug as LO should open the .xls with the autofilters enabled. -- 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
