TypeComboBoxWidth Property
Applies To
fpSpread control
Description
Sets or returns the width of the drop-down list portion of a combo box cell. This property is available at run time only.
Syntax
short CSpreadSheet::GetTypeComboBoxWidth( )
void CSpreadSheet::SetTypeComboBoxWidth(short value)
[form.]fpSpread.TypeComboBoxWidth[ = value%]
Remarks
The following settings are available:
| Setting | Description |
|---|---|
| 0 - Cell Width | (Default) Sets the width to the current width of the cell |
| 1 - Widest Item | Sets the width to display the longest line of text in the drop-down list and aligns the list according to the following tables |
| – n - Right Justify | Sets the width, n (where n is a negative number less than –1) of the drop-down list in twips and right aligns the list to the selection box |
| n - Width | Sets the width, n (where n is a positive number greater than +1) of the drop-down list in twips and aligns the list according to the following tables |
| –1 | Right justifies the drop-down list to the selection box and sets the width to display the longest line of text in the drop-down list |
The unit of measurement for the TypeComboBoxWidth property is pixels.
The drop-down list is left-justified when the following are true:
| TypeComboBoxWidth property value is . . . | and the Cell width is . . . |
|---|---|
| 1 | < longest line in the drop-down list |
| >1 | < longest line in the drop-down list |
The drop-down list is right-justified when the following are true:
| TypeComboBoxWidth property value is . . . | and the Cell width is . . . |
|---|---|
| 1 | > longest line in the drop-down list |
| >1 | > longest line in the drop-down list |
| –1 | no effect |
| <–1 | no effect |
To use the TypeComboBoxWidth 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 TypeComboBoxWidth 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 select an item in the List Width drop-down list box in the Cell Type Settings dialog box.
Data Type
Integer
See Also
Specifying the Width and Alignment of the Combo Box Drop-Down List
CellType, Sheet, TypeComboBoxAutoSearch, TypeComboBoxCount, TypeComboBoxCurSel, TypeComboBoxEditable, TypeComboBoxIndex, TypeComboBoxList, TypeComboBoxMaxDrop, TypeComboBoxString, TypeMaxEditLen properties
TypeComboBoxClear, TypeComboBoxRemoveItem methods
DLL Correspondence
SSSetTypeComboBoxEx function