jQWidgets Forums

jQuery UI Widgets Forums Grid Interpretation of "percentage" values

This topic contains 1 reply, has 1 voice, and was last updated by  cmo 7 years, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Interpretation of "percentage" values #98776

    cmo
    Participant

    Hello,

    Can anyone help with the following problem:

    When configuring a column to format displayed values as percentages ” cellsformat:’P2′ ” the value displayed is as expected (ex: 1.3 % , 2.4 % ) but when exporting the grid to excel using the default data export to Excel, these values become 130% and 240 % ( when opening the Excel document )

    So basically, formatting a field as a percentage just adds the percentage character suffix, but does not change the value . I’m not sure this is correct. Any ideas about this ?

    Interpretation of "percentage" values #98777

    cmo
    Participant

    Ok that was easy … cellsformat:”P2″ is incorrect, it should be “p2” ( small letter p )

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

You must be logged in to reply to this topic.