Spread Windows Forms 11.0 Product Documentation
AutoCompleteCustomSource Property (GcComboBoxCellType)
Example 


GrapeCity.Win.PluginInputMan Assembly > GrapeCity.Win.Spread.InputMan.CellType Namespace > GcComboBoxCellType Class : AutoCompleteCustomSource Property
Gets or sets a custom System.Windows.Forms.AutoCompleteStringCollection to use when the AutoCompleteSource property is set to CustomSource.
Syntax
'Declaration
 
Public Property AutoCompleteCustomSource As AutoCompleteStringCollection
'Usage
 
Dim instance As GcComboBoxCellType
Dim value As AutoCompleteStringCollection
 
instance.AutoCompleteCustomSource = value
 
value = instance.AutoCompleteCustomSource
public AutoCompleteStringCollection AutoCompleteCustomSource {get; set;}

Property Value

The System.Windows.Forms.AutoCompleteStringCollection to use with AutoCompleteSource.
The default is a null reference (Nothing in Visual Basic).
Remarks

Use the AutoCompleteCustomSource, AutoCompleteMode, and AutoCompleteSource properties to create a GcComboBox that automatically completes input string by comparing the prefix being entered to the prefixes of all strings in a maintained source. This is useful for TextBox controls in which URLs, addresses, file names, or commands are frequently entered.

The use of the AutoCompleteCustomSource property is optional, but you must set the AutoCompleteSource property to CustomSource in order to use AutoCompleteCustomSource.

You must use the AutoCompleteMode and AutoCompleteSource properties together.

Example
This example creates a custom source.
AutoCompleteStringCollection acsc = new AutoCompleteStringCollection();
acsc.AddRange(new string[] { "Gouda", "Swiss", "Brie" });

GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType gccombo = new GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType();
gccombo.Items.Add("Gouda");
gccombo.Items.Add("Swiss");
gccombo.Items.Add("Brie");
gccombo.AutoCompleteCustomSource = acsc;
gccombo.AutoCompleteMode = AutoCompleteMode.Suggest;
gccombo.AutoCompleteSource = AutoCompleteSource.CustomSource;
fpSpread1.Sheets[0].Cells[0, 0].CellType = gccombo;
Dim acsc = New AutoCompleteStringCollection()
acsc.AddRange(New String() {"Gouda", "Swiss", "Brie"})

Dim gccombo As New GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType()
gccombo.Items.Add("Gouda")
gccombo.Items.Add("Swiss")
gccombo.Items.Add("Brie")
gccombo.AutoCompleteCustomSource = acsc
gccombo.AutoCompleteMode = AutoCompleteMode.Suggest
gccombo.AutoCompleteSource = AutoCompleteSource.CustomSource
FpSpread1.Sheets(0).Cells(0, 0).CellType = gccombo
See Also

Reference

GcComboBoxCellType Class
GcComboBoxCellType Members