I have a cell which the underling property is of type decimal. It is being display as a currency. Is there a way to get rid of dollar sign as this property is not a currency number?
Thanks
Although this has already been verified, here's an additional line that I found through trial-and-error: field.Settings.EditAsType = typeof(Double);By default, if a field is of type Decimal then you see $_____.__ when in edit mode even after setting the EditorType to a XamNumericEditor. Using the above line removes the dollar sign.
If you are seeing the currency symbol, that means that this property is of type Decimal. By default, the XamDataGrid uses XamCurrencyEditor for decimal type values. If you want to change that, you can change the EditorType property of the Field's Settings to a XamNumericEditor. More information you can find here
Check your source data table in database, and make sure you specified datatype properly.
For eg. Datatype should be 'Number (8)' and not 'Number() '
This worked for me.