• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

ColdFusion spreadsheet questions

Guest
May 01, 2013 May 01, 2013

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

TOPICS
Advanced techniques

Views

823

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 05, 2013 May 05, 2013

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
May 06, 2013 May 06, 2013

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation