Leading '0' values are not exported properly.

[gtwangi]

When exporting leading '0' values(ex. '012345') by using 'exportData' method, the leading zero are deleted in Excel(12345 instead of '012345').

in pqgrid    ->>  in excel
'012345' ->>  12345

Is there way to preserve the leading zero while exporting to excel?

[paramvir]

It can be done by adding dataType: 'string' and format property to the column.

Code: [Select]

format: function(val){
return " "+val;
},

For example, it can be verified by replacing Freight column definition in this demo ( https://paramquery.com/pro/demos/export ) with this:

Code: [Select]

                       { title: "Freight", width: 120,
format: function(val){
return " "+val;
},
//dataType: "float",
dataIndx: "Freight"
},


[gtwangi]

I appreciate your help.
The solution you provided doesn't work on v5.5.0 (I'm using). it probably works well above v5.6

1.
Is there a solution for v5.5.0?

2.
How compatible are v5.5.0 and v5.6.1? which part of code should I modify when upgrading my app to v5.6.1?

[gtwangi]

There is another issue about exporting data.
Negative number is exported as number on v5.5 properly. but after I upgraded pqgrid version to 5.6.1, negative number is exported as text.



How I could export this as number?