Save as Spreadsheet shows field HTML coding
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>")
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>")
