Skip to main content
A
Anonymous
May 1, 2013
Question

ColdFusion spreadsheet questions

  • May 1, 2013
  • 1 reply
  • 945 views

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

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
May 5, 2013

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

A
Anonymous
May 6, 2013

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices