Using SpreadsheetFormatRows

I am using cfspreadsheet to generate the spreadsheets from Database. Recently i came up with a need to generate a Excel file having option to filter data by colums.

I have searched and found below code:

    format1-SructNew() 
    format1.font="Courier"; 
    format1.fontsize="10"; 
    format1.color="dark_blue;"; 
    format1.italic="true"; 
    format1.bold="true"; 
    format1.alignment="left"; 
    format1.textwrap="true"; 
    format1.fgcolor="pale_blue"; 
    format1.bottomborder="dotted"; 
    format1.bottombordercolor="blue_grey"; 
    format1.leftborder="thick"; 
    format1.leftbordercolor="blue_grey"; 
    format1.rightborder="thick"; 
    format1.rightbordercolor="blue_grey"; 
    SpreadsheetFormatRows(theSheet,format1,"1-5"); 

which is very cool. But its not allowing me to generate any excel with filter option....

i have already tried these:

format1.filter = "true"; and format1.filter="ALL"; 
 
Any way to reach this or is this is a limitation in SpreadsheetFormatRows

--
Rahul