jQWidgets Forums

jQuery UI Widgets Forums Grid wrong decimal format when exporting

This topic contains 1 reply, has 2 voices, and was last updated by  Nadezhda 9 years, 11 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • wrong decimal format when exporting #70081

    omargarro
    Participant

    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)

    wrong decimal format when exporting #70101

    Nadezhda
    Participant

    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/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.