Hi,
I think my number formatting is being overwritten by my data styling.
I am trying to set a number mask:
mygrid.setNumberFormat("0,000.00",9);
However i am also adding a span to my data to make the numbers green or red:
eXcell_ron.prototype.setValue = function(val){
if(isNaN(Number(val))){
val = 0;
}
var color = "green";
if(val<0) {color = "red";}
if(val != 0){
this.setCValue("<span></span><span style='padding-right:2px;color:"+color+";'>"+val+"</span>",val);
}
}
It seems that my number formatting is being ignored if I include my data styling.
Is there a way around this?
Cheers
Nic