Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / ComboBoxCellType Class / AutoCompleteSource Property
Example


In This Topic
    AutoCompleteSource Property (ComboBoxCellType)
    In This Topic
    Gets or sets the source for automatic completion of entries in the combo box.
    Syntax
    'Declaration
     
    Public Property AutoCompleteSource As AutoCompleteSource
    'Usage
     
    Dim instance As ComboBoxCellType
    Dim value As AutoCompleteSource
     
    instance.AutoCompleteSource = value
     
    value = instance.AutoCompleteSource
    public AutoCompleteSource AutoCompleteSource {get; set;}

    Property Value

    AutoCompleteSource object containing the source for the automatic completion
    Example
    This example uses the custom source for automatic completion.
    AutoCompleteStringCollection acsc = new AutoCompleteStringCollection(); 
    acsc.AddRange(new string[]{"One", "Two", "Three", "Four"}); 
    FarPoint.Win.Spread.CellType.ComboBoxCellType cb = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); 
    cb.Items = new string[]{"One", "Two", "Three", "Four"}; 
    cb.Editable = true; 
    cb.AutoCompleteCustomSource = acsc; 
    cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; 
    cb.AutoCompleteSource = AutoCompleteSource.CustomSource;
    Dim acsc As New AutoCompleteStringCollection
    acsc.AddRange(New String() {"One", "Two", "Three", "Four"})
    
    Dim cb As New FarPoint.Win.Spread.CellType.ComboBoxCellType
    cb.Items = New String() {"One", "Two", "Three", "Four"}
    
    cb.Editable = True
    cb.AutoCompleteCustomSource = acsc
    cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend
    cb.AutoCompleteSource = AutoCompleteSource.CustomSource
    
    fpSpread1.ActiveSheet.Cells(0, 0).CellType = cb
    See Also