Issue with data type price

Suite and Optimus Suite 5
#1

I have a uneditable grid(read only) which has a column for price.The grid is not display the value zero when u declare the data type as grid.Please let me know how to display the value.Thanks in advance.

#2

If you need not to show 0 for empty cells , you can
a) declare different type for them in XML

b) redefine logic of price excell
eXcell_price.prototype.setValue=function(val){
if (isNaN(parseFloat(val))){
this.setCValue(val, val);
}
var color = “green”;

if (val < 0)
color=“red”;

this.setCValue("$"+val+"", val);
}