Hi,
I'd like to format one of my columns with a thousand separator. I also would like to not show any decimal places. So I want my numeric values to look like:
1001,1004,555,111
How can I achieve that?
Thanks. That works. Still a question about this. I have a column that displays with two decimal points. I set the format for the column as "d" in InitializeLayout event, and it displays just fine. Once a value is updated for that column, say I enter 400, I want the value to automatically display as 400.00. How can I achieve that? I was trying to apply some formatting in the AfterCellUpdate event, but doesn't seem to work.
Here is small sample with different column`s dataType:
Hello Khaled,
Maybe you could try to use both properties of your column:
- Format - determines the format of the cell`s value when the cell is not in edit mode
- MaskInput - determines the input mask for the cell when it is in Edit mode
More details about different format and MaskInput options you could find in our online documentation:
- http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/WinGrid_Localizing_Cell_Display_Format.html
- //help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/WinGrid_Formatting_Cells_Containing_Dates.html
- http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/WinGrid_Formatting_Cells_Containing_Specific_Number_of_Characters.html
Let me know if you have any questions.
Regards