MaxDrop Property (ComboBoxCellType)

Visual Basic
C#

'Declaration
 
Public Property MaxDrop As Integer

'Usage
 
Dim instance As ComboBoxCellType
Dim value As Integer
 
instance.MaxDrop = value
 
value = instance.MaxDrop

public int MaxDrop {get; set;}

Property Value

Integer number of items in the list to display

This property specifies how many items the drop-down list displays. If the list contains fewer items than the setting of this property, the list only displays those items. For example, if the list only contains three items, and this property is set to its default value of eight, the drop-down list only displays three items.

This example sets up a cell on the first sheet with a combo box with the first six months of the year and specifies the size of the portion displayed.

C#

FarPoint.Win.Spread.CellType.ComboBoxCellType cmbocell = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
cmbocell.Items = (new String[] {"January", "February", "March", "April", "May", "June"});
cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter;
cmbocell.Editable = true;
cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left;
cmbocell.ListOffset = 20;
cmbocell.ListWidth = 0;
cmbocell.MaxDrop = 4;
fpSpread1.Sheets[1].Cells[2,2].CellType = cmbocell;

Visual Basic

Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType()
cmbocell.Items = (new String() {"January", "February", "March", "April", "May", "June"})
cmbocell.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
cmbocell.AutoSearch = FarPoint.Win.AutoSearch.SingleCharacter
cmbocell.Editable = True
cmbocell.ListAlignment = FarPoint.Win.ListAlignment.Left
cmbocell.ListOffset = 20
cmbocell.ListWidth = 0
cmbocell.MaxDrop = 4
fpSpread1.Sheets(1).Cells(2,2).CellType = cmbocell

Reference

ComboBoxCellType Class
ComboBoxCellType Members

User-Task Documentation

Setting a Combo Box Cell