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

Hi :)
Excel and the xls or xlsX formats have a LOT of vulnerabilities in amazingly 
basic functions.  Their macros have often carried malware and many organisations 
block macros as a result.  I have a feeling the reason LibreOffice/OpenOffice 
have such different systems for macros is to make sure those types of 
vulnerabilities don't exist.  IF it's the same for autofilters then the 
bug-reports should be filed with MS against Excel.
Regards from
Tom :)





----- Original Message ----
> From: NoOp <glgxg@sbcglobal.net>
> To: users@libreoffice.org
> Sent: Fri, 10 June, 2011 23:52:25
> Subject: [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

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