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


In This Topic
    AutoCompleteSource Property (GcTextBoxCellType)
    In This Topic
    Gets or sets a value that specifies the source of strings used for automatic completion.
    Syntax
    'Declaration
     
    Public Property AutoCompleteSource As AutoCompleteSource
    'Usage
     
    Dim instance As GcTextBoxCellType
    Dim value As AutoCompleteSource
     
    instance.AutoCompleteSource = value
     
    value = instance.AutoCompleteSource
    public AutoCompleteSource AutoCompleteSource {get; set;}

    Property Value

    One of the values of System.Windows.Forms.AutoCompleteSource. The options are AllSystemSources, AllUrl, FileSystem, HistoryList, RecentlyUsedList, CustomSource, and None.
    The default is None.
    Remarks

    Use the GcTextBox.AutoCompleteCustomSource,GcTextBox.AutoCompleteMode, and AutoCompleteSource properties to create a GcTextBox 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 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 uses the AutoCompleteSource 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;
    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
    fpSpread1.Sheets(0).Cells(1, 1).CellType = inputcell1
    See Also