ColdFusion spreadsheet questions

[Guest]

I have two requests that I am not sure can be done with CF's spreadsheet functions. 

The first is to insert cr/lf after multiple values in a cell.  It is done in Excel with alt-enter. 

The other is adding AutoFilter to the header row.

Are either of these possible?

Thanks

[Dan_Bracuk]

The ColdFusion equivalent to cr/lf is chr(10) & chr(13).  Try it.  It might work.

[Guest]

Thank you, Dan.  That addressed the cr/lf issue perfectly.  The AutoFilter looks like it will be the tough one if it is even possible.  I found a solution that involves updating the POI on CF 9 and below but we are on CF 10.