Input format for GridNumericColumn

[??]

I'm testing sfDataGrid.

There is Format property in GridNumericColumn of sfDataGrid but it works only for displaying value.

When I edit the column, it always show like 'xxxx.xx' (i,e 23457.00). I want to edit value as integer only.

How can I do it? 

[Subburaj Pandian Veluchamy]

Hi, 

  

Thank you for contacting Syncfusion support. 

  

Based on the provided information, if you need to edit the numeric column with the integer value, you can use the column’s NumericFormtInfo property and set NumberDecimalDigits as 0. Kindly refer the following code example for the same, 

 

//Set the NumberFormatInfo for the numeric column. 

sfDataGrid.Columns.Add(new GridNumericColumn() { MappingName ="ColumnName",  NumberFormatInfo = newSystem.Globalization.NumberFormatInfo() { NumberDecimalDigits = 0 }}); 

  

You can refer our User Guide documentation regarding the same,

 

UG Link: https://help.syncfusion.com/windowsforms/sfdatagrid/columntypes#data-formatting 

 

Regards,
Subburaj Pandian V