How to Implement Excel Accounting Format in Windows Forms Grid Control

18 Nov 20181 minute to read

We can achieve this behavior by setting the cell type to Currency. The currency symbol is removed from the cell data with the following code:

C#

this.gridControl1[i, j].CurrencyEdit.CurrencySymbol = "";

VB.NET

Me.gridControl1[i, j].CurrencyEdit.CurrencySymbol = "";

The CurrencyDecimalDigits property is used and the digits after the decimal point are set using the code below:

C#

this.gridControl1[i, j].CurrencyEdit.CurrencyDecimalDigits = 2;

VB.NET

Me.gridControl1[i, j].CurrencyEdit.CurrencyDecimalDigits = 2;

By default the contents are left-aligned, so the horizontal alignment is set to Right.

C#

this.gridControl1.ColStyles[j].HorizontalAlignment = Syncfusion.Windows.Forms.Grid.GridHorizontalAlignment.Right;

VB.NET

Me.gridControl1.ColStyles[j].HorizontalAlignment = Syncfusion.Windows.Forms.Grid.GridHorizontalAlignment.Right;