jQWidgets Forums

jQuery UI Widgets › Forums › Grid › Decimal places in excel

Tagged: 

This topic contains 3 replies, has 2 voices, and was last updated by  viji 9 years, 7 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Decimal places in excel Posts
  • October 26, 2015 at 11:34 am Decimal places in excel #77320

    viji
    Participant

    Hi,
    Is it possible to show the values as below in both grid and in downloaded excel.

    10.88 -> 10.88
    10 -> 10 (Should not be 10.00)
    -10.12 -> -10.12

    Regards,
    Viji

    October 26, 2015 at 12:45 pm Decimal places in excel #77331

    ivailo
    Participant

    Hi viji,

    In jqxGrid you can use cellsrenderer to display the values in prefered way.
    If you want the exported file to be modified you can first export the grid to variable, then to modify it an after to send it to the server script.
    The script have to generate your Excel file.

    Best Regards,
    Ivailo Ivanov

    jQWidgets Team
    http://www.jqwidgets.com

    October 28, 2015 at 6:51 am Decimal places in excel #77430

    viji
    Participant

    Could you please provide me a sample for the above.

    Regards,
    Viji

    October 28, 2015 at 7:29 am Decimal places in excel #77435

    viji
    Participant

    Ivailo,

    Working fine. Thank you so much

    Regards,
    Viji

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.