How to apply the formatted text while editing the data in WinForms GridControl?
Formatting
You can use
the CurrentCellChanged event to apply formatting for the
current cell while editing the data and also set the CellValueType to GetType(Double).
Refer to the following code examples.
//Hook the CurrentCellChaged event in Form_Load
this.gridControl1.CurrentCellChanged += gridControl1_CurrentCellChanged;
void gridControl1_CurrentCellChanged(object sender, EventArgs e)
{
// change the format for the current cell
gridControl1.TableStyle.Format = "#,##0.00000";
// check the value entered in the current cell is a type of double.
gridControl1.TableStyle.CellValueType = typeof(double);
}'Hook the CurrentCellChaged event in Form_Load
AddHandler Me.gridControl1.CurrentCellChanged, AddressOf gridControl1_CurrentCellChanged
Private Sub gridControl1_CurrentCellChanged(ByVal sender As Object, ByVal e As EventArgs)
' change the format for the current cell
gridControl1.TableStyle.Format = "#,##0.00000"
' check the value entered in the current cell is a type of double.
gridControl1.TableStyle.CellValueType = GetType(Double)
End SubSamples:
C#: FormattedText
VB: FormattedText