Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
aruna
35
Problem with Column format on Ultrawebgrid
posted
1.Column formatted to $: Loses the format after doing delete on newly added rows.

dgGrid.DisplayLayout.Bands(0).Columns.FromKey("MAXVALUE").Format = "$ ###,##0"

2.Column formatted as %:

dgGrid.DisplayLayout.Bands(0).Columns.FromKey("PERCEXP").Format = "0%"

I have a column in my grid for which the underlying database column definition is decimal. In the grid I have set the Column format . When the data is displayed it is correct, so a value of .25 displays as 25.00%. The problem is that when you enter the cell the displayed value changes to .25000. Added the column format in Initializelayout.

Is this a bug in the infragistics grid or Is there a work around???????

  • 45049
    posted

    If you need to use formats such as currency or percents, you should use editor controls rather than the Format property on the WebGrid columns.  Specifically, you should use WebCurrencyEdit for currency columns, and WebPercentEdit for percentage columns.

    WebGrid's client-side codebase simply can't keep up with all of the different formats that data can provide, while these specialized editors are able to do so.

  • 100
    posted

    Hi,

    I have exactly the same problem. Did you find a solution for it?

    Your help would be greatly appreciated !!!

    Thanx in advance,

    Christophe