When I set the MaskInput property of an integer or double column to "{double:7.2}" the editor uses the number formatting set at the operating system level (decimal symbol character, digit grouping character).
When I set the MaskInput property of a decimal column to "{double:7.2}" the editor uses the currency formatting set at the operating system level (decimal symbol character, digit grouping character).
Why is this? How do I control the input mask format of a decimal column to use the number formatting and not the currency formatting? My decimal column does not represent currency, so why is it using currency formatting and not number formatting?
Thank you.
Hello daway,
I am just checking about the progress of this issue. Let me know If you need our further assistance on this issue?
Thank you for using Infragistics Components.
Hi,
That's the intended behavior. In VB, the decimal DataType is called Currency. So the two are essentially interchangeable (decimal/currency). You can, of course, control this using the Format property on the column.
Hi Mike,
I am referring to the currency decimal symbols, and currency digit grouping symbols, not the currency symbol itself.
When using a decimal type, the mask shows me the currency decimal and digit grouping symbols.
Thanks
I tried this out with a decimal column in the grid using the same input mask you have here, and I'm not seeing any currency symbol in the cells. Are yuo sure it's the MaskInput that's doing this?
MaskInput typically only applies to a cell when it is in edit mode. When it's not in edit mode, it's the column's Format that applies.