SSpread.TypeComboBoxMaxDrop Property

In the combo box cell, set the maximum number of rows to display in the list.

Only valid for cells with the CellType property set to $CellTypeComboBox. Before setting this property, use the Col , Row properties etc. to specify what to do.

If the number of items in the list is greater than the value of this property, the list will display a scrollbar.

The initial value is 6 .

You can get the number of items in the list with the TypeComboBoxCount property.

This property is subject to property inheritance of combo box type cells . Notes on property inheritance of combo box type cells

Use case

Col = 3;
Row = 2;
CellType = $ CellTypeComboBox;
TypeComboBoxList = "AAA\tBBB\tCCC\tDDD\tEEE";
TypeComboBoxMaxDrop = 3;
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeComboBox;
TypeComboBoxMaxDrop = 4;
BlockMode = $FALSE;

Related item
CellType , TypeComboBoxCount properties