jQuery UI Widgets › Forums › Grid › CSV Export not holding the format
Tagged: cellsformat, csv, export, Exportdata, grid, jqxgrid, year
This topic contains 3 replies, has 2 voices, and was last updated by Dimitar 8 years, 4 months ago.
I have a column Year, just has the year like 2015.
On the report view it shows 2015, but when I export to CSV it puts 2,015.00 in the CSV file.
Why is this and how do I correct this?
You can try setting the cellsformat property of the “year” column to ‘n’.
The issue with that is then it will display the year with comma. i.e. 2,015
In that case, change the type of the datafield corresponding to the “year” column to ‘string’ and remove the column’s cellsformat setting.
You must be logged in to reply to this topic.