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


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

    Property Value

    AutoCompleteStringCollection object containing the set of automatic completion strings.
    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