wrong decimal format when exporting

[omargarroParticipant]

Hi, I have a grid with various a Price column, set like following:

columns = [{ text: ‘Id’, datafield: ‘Id_StkProd’, width: 100, cellsalign: ‘right’},
{ text: ‘Price’, datafield: ‘Price’, width: 100, cellsalign: ‘right’, cellsformat: ‘d3’} ];

Everything looks just fine when displaying the grid on screen, but when exporting ( to xls using exportada.js ) one decimal is missing and format is shown as 9,99 when it´s supposed to be 9,999 (d3 format)

[NadezhdaParticipant]

Hello omargarro,

Please, check if Format cells settings of Price column in your .xls file has the same format as the format in jqxGrid’s ‘cellsformat’. If this suggestion does not help you fix the issue, please, provide us with sample code or jsfiddle example.

Best Regards,
Nadezhda

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts