Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
The ColdFusion equivalent to cr/lf is chr(10) & chr(13). Try it. It might work.
Copy link to clipboard
Copied
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.