Spread Windows Forms 13.0 Product Documentation
GrapeCity.Win.PluginInputMan Assembly / GrapeCity.Win.Spread.InputMan.CellType Namespace / GcComboBoxCellType Class / AutoCompleteSource Property
Example


In This Topic
    AutoCompleteSource Property (GcComboBoxCellType)
    In This Topic
    Gets or sets the source for strings used for automatic completion.
    Syntax
    Remarks

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

    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