Spread Designer
To specify the width and alignment of the combo box drop-down list box
In the Spread Designer,
- Select a cell or block of cells.
-
Choose the cell type using one of the following methods:
- Display the pop-up menu by right-clicking the cell or block of cells and then choose Combobox.
- From the Cell menu, choose Cell Type, Combo Box.
- Choose the Combo Box button ( ) on the cell type toolbar.
The Cell Type dialog box appears. -
In the Cell Type dialog box, on the Settings tab,
- If you want the width of the drop-down list to be equal to the current width of the cell, choose Cell Width from the List Width drop-down combo box.
- If you want the width of the drop-down list to display the longest line of text and the text to be right-justified, type –1 in the List Width drop-down combo box.
-
If you want to set a specific width, type a value in the edit field of the List Width drop-down combo box.
If you enter a negative number, the drop-down list will be right-justified. If you enter a positive number, the drop-down list box will be left aligned or right aligned to the selection box depending on the cell width and the length of the longest line of text in the drop-down list. If the cell width is less than the longest line of text, the drop-down list is left-justified. If the cell width is greater than the longest of text, the drop-down list is right-justified.
- Choose the OK or Apply button.