// DecimalGeneralFormat only works for ja-JP or zh-CN culture. It is similar to Excel.
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo numfield = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo();
numfield.Pattern = GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat.DBNum1_G;
numfield.BackColor = Color.Bisque;
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.DisplayFields.Add(numfield);
ncell1.PaintByControl = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 12.31;
'DecimalGeneralFormat only works for ja-JP or zh-CN culture. It is similar to Excel.
Dim numfield As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo()
numfield.Pattern = GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat.DBNum1_G
numfield.BackColor = Color.Bisque
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.DisplayFields.Add(numfield)
ncell1.PaintByControl = True
fpSpread1.Sheets(0).Cells(1, 1).CellType = ncell1
fpSpread1.ActiveSheet.Cells(1, 1).Value = 12.31