how to use Apply autofilter

Feb 22, 2011 at 1:45 PM
Edited Feb 22, 2011 at 3:25 PM


on page 17 of the documentation it says that to apply an autofilter this is the code:


When i try it, on excel, i can see the header cells with the autofilter (the boxes with the black triangle), but how can I trigger the autofilter to be something in particular, as in, how to order a column in alphabetically?


Feb 22, 2011 at 9:49 PM

There is no option in PHPExcel to activate the filtering or sorting or autofilter columns, merely to enable autofilter for a block of cells.

Feb 22, 2011 at 9:50 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Jul 19, 2012 at 8:23 AM
Edited Jul 19, 2012 at 8:23 AM

OMG......i found setAutoFilter()  

testing it for 4hourssssssss.............