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

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