Suppress 0 In Grid Column

[rkanemeier]

I have a db file that contains a 3 digit number field (no decimals). If this field is "empty", naturally the value is 0. When I display this field in a grid, it shows up as 0. Instead of displaying 0, I want the field to display as blank. If the value is 3, it should show 3 (not 003). How do I suppress a value of zero (and any leading zeros) in a grid column? I tried searching for this answer but came up empty.

[Alexander Bauer]

You can specify a custom renderer on a column, i.e.:

{
// ...

renderer : function(value) {
value = parseInt(value);
 return value === 0 ? "" : value;
}

}

[droessner]

Make sure you do parseInt(value, 10) so that it parses as a decimal.

[rkanemeier]

Thanks for the replies.


I think I see how this works. I'm a little new to the syntax of value === 0 ? "" : value;


Once I added that renderer to my column, the cell is now showing NaN.


*EDIT* BAH! User error. This works like a charm!