Skip to main content
Known Participant
June 4, 2020
Question

Email id shows [email protected] while generating excel report

  • June 4, 2020
  • 1 reply
  • 2716 views

Hi,

I am trying to generate an excel report using ColdFusion 2018 and in the excel file there is a column for email id.  Instead of showing email id, it shows "[email protected]" as hyperlinked text. And if i click on the text is says "Cannot open the specified file".  Is there a setting where i can see the actual email id. 

 

This is happening only in coldfusion 2018, i was not facing this in earlier version.  If i generate a web report (Showing html report in table on the screen) using ColdFusion 2018, it works fine.   I presume this can be resolved by some security setting and not through code as code is the same for older versions.

 

Please find the attached screenshot, coldfusion code to generate the excel (removed unncessary code and kept only the necessary sections), excel spreadsheet generated.

 

Could someone help me with this.  I have been searching for the answer in internet and i couldn't find a single thread for this.

 

regards,

Sunil

    This topic has been closed for replies.

    1 reply

    Community Expert
    June 4, 2020

    What happens if you click on the "Enable Editing" button in the yellow "PROTECTED VIEW" bar at the top of the screen?

     

    Dave Watts, Eidolon LLC

    Dave Watts, Eidolon LLC
    Known Participant
    June 4, 2020

    Appreciate your reply Dave. I updated the screenshot now.  It just enables editing the spreadsheet, the end result is the same. This is the hyperlink on the text "..\..\..\cdn-cgi\l\email-protection" if this will help.