GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType inputcell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
inputcell1.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
inputcell1.DisplayAlignment = GrapeCity.Win.Spread.InputMan.CellType.DisplayAlignment.Distributed;
AutoCompleteStringCollection acsc = new AutoCompleteStringCollection();
acsc.AddRange(new string[] { "One", "Two", "Three", "Four" });
inputcell1.AutoCompleteCustomSource = acsc;
inputcell1.AutoCompleteMode = AutoCompleteMode.Suggest;
inputcell1.AutoCompleteSource = AutoCompleteSource.CustomSource;
inputcell1.AutoComplete.HighlightStyle.BackColor = Color.Crimson;
inputcell1.AutoComplete.HighlightMatchedText = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = inputcell1;
Dim inputcell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType
inputcell1.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
inputcell1.DisplayAlignment = GrapeCity.Win.Spread.InputMan.CellType.DisplayAlignment.Distributed
Dim acsc As New AutoCompleteStringCollection
acsc.AddRange(New String() {"One", "Two", "Three", "Four"})
inputcell1.AutoCompleteCustomSource = acsc
inputcell1.AutoCompleteMode = AutoCompleteMode.Suggest
inputcell1.AutoCompleteSource = AutoCompleteSource.CustomSource
inputcell1.AutoComplete.HighlightStyle.BackColor = Color.Crimson
inputcell1.AutoComplete.HighlightMatchedText = True
fpSpread1.Sheets(0).Cells(1, 1).CellType = inputcell1