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
275
Problem with data entry in a column that is formatted as percent.
posted

I have a column in my grid for which the underlying database column definition is decimal(18,5). In the grid I have set the Format property to P (also tried p with no difference). When the data is displayed it is correct, so a value of .35 displays as 35.00%. The problem is that when you enter the cell the displayed value changes to .35000. That wouldn't be so bad but if you enter a value of .37 once you leave the cell it displays 0.37% and if you save the data to the database the result is .0037.

Is there a property somewhere that can be changed that will affect this behavior or is this a bug?

 Thanks, Dave

Parents
No Data
Reply Children
No Data