TypeComboBoxMaxDrop Property
Applies To
fpSpread control
Description
Sets or returns the number of rows to display in the drop-down list of a combo box cell. This property is available at run time only.
Syntax
short CSpreadSheet::GetTypeComboBoxMaxDrop( )
void CSpreadSheet::SetTypeComboBoxMaxDrop(short value)
[form.]fpSpread.TypeComboBoxMaxDrop[ = value%]
Remarks
The default value for the TypeComboBoxMaxDrop property is 6 rows. The edit field and horizontal scroll bar, when displayed, are not counted as rows.
This property specifies how many rows the drop-down list displays. If the list contains fewer rows than the setting of this property, the list will only display the rows that contain data. For example, if the list only contains three items, and this property is set to its default value of six, the drop-down list only displays three items.
To use the TypeComboBoxMaxDrop property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties.
The TypeComboBoxMaxDrop property does not have an effect unless the CellType property is set to 8 (Combo Box) for the specified cell or cells.
Spread Designer
Choose the Cell menu, the Cell Type menu, the Combo Box menu, and then the Settings tab, and then choose or type a number in the Max Drop spin box in the Cell Type Settings dialog box.
Data Type
Integer
See Also
Creating and Setting up a Combo Box Cell
CellType, Sheet, TypeComboBoxAutoSearch, TypeComboBoxCount, TypeComboBoxCurSel, TypeComboBoxEditable, TypeComboBoxIndex, TypeComboBoxList, TypeComboBoxString, TypeComboBoxWidth properties
TypeComboBoxClear, TypeComboBoxRemoveItem methods
DLL Correspondence
SSSetTypeComboBoxEx function