Skip to main content
S
sunilk86642652
Known Participant
June 4, 2020
Question

Email id shows [email protected] while generating excel report

  • June 4, 2020
  • 1 reply
  • 2720 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

    D
    Community Expert
    Dave WattsCommunity Expert
    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
    S
    sunilk86642652Author
    Known Participant
    June 4, 2020

    Hi Dave, I found that this is an email address obfuscation done at Cloudflare. Thanks.

     

    S
    sunilk86642652Author
    Known Participant
    June 9, 2020

    Just curious.. what happens if you place the email off code around the entire anchor tag?

     

    V/r,

     

    ^ _ ^


    Thanks for your comment.  Yes, it works that way.  I finally found this solution after couple of trial and error.  

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