how to use Apply autofilter

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

Hi, 

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

$objPHPExcel->getActiveSheet()->setAutoFilter('A1:C9');

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?

thanks

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

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

still.......nothing...