Unable to Export to Excel with Custom Column Type

Suite and Optimus Suite 5
#1

I am using a custom column type that turns the ron type into red when negative (based on one of your examples). The type name is roncl.

This type prevents an export to eXcel. If I change my col types back to ron the export works fine.

//extended ron to use color for number
function eXcell_roncl(cell){
this.base=eXcell_ron;
this.base(cell);
this.setValue=function(val){
if(!val||val.toString()._dhx_trim()==“”)val=“0”;
if(val>=0)this.cell.style.color=“black”;
else this.cell.style.color=“red”;
this.cell.innerHTML=this.grid._aplNF(val,this.cell._cellIndex);
}
};
eXcell_roncl.prototype=new eXcell_ron;

#2

You can add getContent method in your custom excel. Value which it returns will be used in data export.

this.base=eXcell_ron; this.base(cell); this.getContent = function(){ return this.cell.innerHTML; //or something else }; this.setValue=function(val){ ...