format zero as empty string

[scoular]

I have a colModel with datatype integer.  I just want to display zero as empty string instead of zero.  format: "#"  doesn't work and I have tried other things including using a function for format. 

[paramvir]

In new version 10.x, you may use use the excel format #;#; to display 0 as empty string where first part # is for +ve numbers, 2nd part # is for -ve numbers, 3rd part is for 0.

You may try it out in this example: https://paramquery.com/pro/demos/format_number, you can enter the format from the toolbar button.

In colModel, it would be

Code: [Select]

format: "#;#;"