jQWidgets Forums

jQuery UI Widgets Forums Grid How to set a grid column format to 0.00

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  Apeksha Singh 11 years, 11 months ago.

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

  • Apeksha Singh
    Participant

    Hi,

    Is it possible to set the format for a particular column in a grid to 0.00 and even if the value is 27 I want it to be display as 27.00 .

    Please guide me regarding this as soon as possible.

    Thanks & Regards,

    Apeksha


    Mariya
    Participant

    Hi Apeksha Singh,

    It is possible by using the ‘cellsformat’ of the column. Possible Number strings:
    “d” – decimal numbers.
    “f” – floating-point numbers.
    “n” – integer numbers.
    “c” – currency numbers.
    “p” – percentage numbers.
    In you case you should use ‘f2’.
    For adding decimal places to the numbers, add a number after the formatting string. For example: “c3” displays a number in this format $25.256.You can have a date formats as well.

    Best Wishes,
    Mariya

    jQWidgets Team
    http://www.jqwidgets.com


    Apeksha Singh
    Participant

    Hi Mariya,

    Thanks for your reply it resolved my issue .
    I also need to know is it possible to have the same format for a jqxinput field value.

    Regards,
    Apeksha

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

You must be logged in to reply to this topic.