Spread 8.0 Documentation
TypeComboBoxMaxDrop Property
Support Options
ActiveX Reference > ActiveX Properties > TypeComboBoxMaxDrop Property

Glossary Item Box

TypeComboBoxMaxDrop Property


See Also    DLL    Example

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

C++

short CSpreadSheet::GetTypeComboBoxMaxDrop( )
void CSpreadSheet::SetTypeComboBoxMaxDrop(short value)

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.