Discussions

Expand all | Collapse all

Save as Spreadsheet shows field HTML coding

  • 1.  Save as Spreadsheet shows field HTML coding

    Posted 08-25-2016 21:53
    I currently have a formula field that includes HTML coding in order to highlight just the cell green (rather than the whole row) when the value is 100%. That works fine, however, when my users export the report using Save as Spreadsheet, all the HTML code appears in the CSV. Is there a way to remove or hide the HTML code for exporting and only show the actual value?

    Here is my code:

    var number trad=Round([% Stage 1 Complete_calc]*100); 

    var number percent=[% Stage 1 Complete_calc];

    var text sign="%"; 

    If($percent>0.995, "<div style=\"color:black;background-color:#19b319;font-weight:bold;text-align: center;\"> " & $trad & $sign & "<div>", "<div style=\"color:black;font-weight:bold;text-align:center\"> " & $trad & $sign & "<div>")


  • 2.  RE: Save as Spreadsheet shows field HTML coding

    Top
    Contributor
    Posted 08-26-2016 19:58
    Not natively. The best suggestion would be to have a plain text representation of the field and train users to either swap the field out on the report before download, or have two versions of the report.


  • 3.  RE: Save as Spreadsheet shows field HTML coding

    Posted 10-12-2018 19:18
    Harrison, how can this be accomplished? 

    When I create a Formula - Text field and set it equal to the Rich Text field, it also has HTML characters.




  • 4.  RE: Save as Spreadsheet shows field HTML coding

    Bronze
    Contributor
    Posted 10-15-2018 17:16
    An option is to have a URL Button, which could link to a report, and that report has the same filter logic, and same columns (or maybe have a plain text field equivalent without the html text) and have this reports format to be "Comma Separated Values" which instead of viewing, it instantly downloads this report onto the local computer.

    Hope this helps