Spread Windows Forms 9.0 Product Documentation
AutoComplete Property (GcTextBoxCellType)
Example 


Gets the automatic complete related settings.
Syntax
'Declaration
 
Public ReadOnly Property AutoComplete As AutoCompleteInfo
'Usage
 
Dim instance As GcTextBoxCellType
Dim value As AutoCompleteInfo
 
value = instance.AutoComplete
public AutoCompleteInfo AutoComplete {get;}

Property Value

The automatic complete.
Example
This example uses the AutoComplete property.
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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

GcTextBoxCellType Class
GcTextBoxCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.