ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: Akihiro Inoue on December 17, 2018, 11:16:58 am

Title: Export to excel
Post by: Akihiro Inoue on December 17, 2018, 11:16:58 am

Outputting column ("01","02","03"...) in PQgrid to Excel will change ("1","2","3"...).
But the Format Cells is General. We want it to set Text.
We want to output it as it is.

Please tell me what to do.

We wrote a sample in the jsfiddle.
http://jsfiddle.net/s_matsumoto/j1botfs7/4/

(We use pqGrid "ver 4.0.1")

Title: Re: Export to excel
Post by: paramvir on December 18, 2018, 11:52:13 am

Currently we don't have the feature to override/specify format of cells in Excel export.

May you can prepend the numbers with a letter to force them to format as strings like "a01", "a02", etc.

Title: Re: Export to excel
Post by: Akihiro Inoue on December 18, 2018, 12:03:17 pm

Thanks support.
I expect the next update.