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

Glossary Item Box

TypeComboBoxWidth Property


See Also    DLL    Example

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

C++

short CSpreadSheet::GetTypeComboBoxWidth( )
void CSpreadSheet::SetTypeComboBoxWidth(short value)

Visual Basic

[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

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