Re: [libreoffice-users] Re: Add a 'Sort' button to the tops of columns?

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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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