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 <[email protected]> > To: [email protected] > 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 [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 > > -- 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
