jQuery UI Widgets Forums Grid data from grid saved differently at backend csv file

This topic contains 1 reply, has 2 voices, and was last updated by  Dimitar 8 years, 6 months ago.

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

  • ashwin prabhu
    Participant

    Hi,
    I have a grid with column as textbox. If i write any data in the cell, it gets saved differently at the backend csv file.

    for eg.
    1) 232434564645.54645 gets saved as 2.32435E+11
    2) -12132432 gets saved as -1.2E+07

    Can anyone pls help me on why i am getting such differences while saving to csv excel file at the backend


    Dimitar
    Participant

    Hi ashwin prabhu,

    We tested for this issue by entering 232434564645.54645 and -12132432 in the “Quantity” column of our Data Export demo (modified with editable: true) and then exporting to CSV. The numbers are correctly exported as “232,434,564,645.55” and “-12,132,432.00”.

    Maybe there is something in your back end causing this number conversion. Please also make sure you are using the latest version of jQWidgets (3.8.2).

    Best Regards,
    Dimitar

    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.