Hi
I am using Ultrawin grid. I have a column where the user will enter currency value.
Grid should allow the user to enter only numeric values and currency symbol(Only at first position)
Grid should NOT allow the user to enter any special characters or alphabets
User has to type $1300400
After the user moves out of the cell it should display the value as $1,300,400
How to do the validation and set the comma separated format on a UltraWin Grid cell?
Thanks
Ashok
Hi,
I tried your solution but it did not work.
I added
ultraGrid1.DisplayLayout.Bands[0].Columns[5].Format =
"$#,###.##";
to my form load and it still not in the currecy format
Hello,
In order to set the appearance of the values you can set thr Column's Format property like so:
ultraGrid1.DisplayLayout.Bands[0].Columns[1].Format = "$#,###.##";
and there is a RegexPattern property you can set to validate the cell's input
ultraGrid1.DisplayLayout.Bands[0].Columns[1].RegexPattern
Hope this helps.
Sincerely,
Petar Monov
Developer Support Engineer,
Infragistics, Inc