ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: vijay@spinetechnologies on March 27, 2023, 05:24:53 pm

Title: Issues while formating decimal values in export
Post by: vijay@spinetechnologies on March 27, 2023, 05:24:53 pm

Hi Paramvir,

We have a pqGrid with some decimal columns. We applied format to decimal columns as "##,###.00".

If the cell value is zero, then in excel export cell shows .00 instead of 0.00.

You can find the same case in the given URL: https://paramquery.com/pro/demos87/export
Just need to update the Freight value as Zero for any cell and then export it to Excel.

Also, find an attached PDF for your reference

Title: Re: Issues while formating decimal values in export
Post by: paramvir on March 27, 2023, 07:15:24 pm

Please use "##,##0.00" instead of "##,###.00"

Title: Re: Issues while formating decimal values in export
Post by: vijay@spinetechnologies on March 27, 2023, 07:18:51 pm

Thanks for your reply. Now showing in the proper format