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

    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


    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,

    jQWidgets team

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

You must be logged in to reply to this topic.