GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType datecell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide;
datecell.ExcelExportFormat = "MM/dd/yy";
fpSpread1.Sheets[0].Cells[0, 0].CellType = datecell;
GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType textcell = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
textcell.AutoConvert = true;
textcell.FormatString = "A";
fpSpread1.Sheets[0].Cells[1, 1].CellType = textcell;
Dim datecell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType()
datecell.FieldsEditMode = GrapeCity.Win.Spread.InputMan.CellType.FieldsEditMode.RightSide
datecell.ExcelExportFormat = "MM/dd/yy"
fpSpread1.Sheets(0).Cells(0, 0).CellType = datecell
Dim textcell As New GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType()
textcell.AutoConvert = True
textcell.FormatString = "A"
fpSpread1.Sheets(0).Cells(1, 1).CellType = textcell