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


In This Topic
    AutoCompleteMode Property (GcComboBoxCellType)
    In This Topic
    Gets or sets an option that controls how automatic completion works for the GcComboBox cell.
    Syntax
    'Declaration
     
    Public Property AutoCompleteMode As AutoCompleteMode
    'Usage
     
    Dim instance As GcComboBoxCellType
    Dim value As AutoCompleteMode
     
    instance.AutoCompleteMode = value
     
    value = instance.AutoCompleteMode
    public AutoCompleteMode AutoCompleteMode {get; set;}

    Property Value

    One of the values of AutoCompleteMode. The values are System.Windows.Forms.AutoCompleteMode.Append, System.Windows.Forms.AutoCompleteMode.Suggest, System.Windows.Forms.AutoCompleteMode.SuggestAppend, and System.Windows.Forms.AutoCompleteMode.None. The default is System.Windows.Forms.AutoCompleteMode.None.
    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