ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: scoular on December 11, 2024, 03:36:14 pm

Title: format zero as empty string
Post by: scoular on December 11, 2024, 03:36:14 pm

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. 

Title: Re: format zero as empty string
Post by: paramvir on December 11, 2024, 03:48:45 pm

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: "#;#;"