Creating and Setting up a Combo Box Cell

---

• Spread Designer Instructions
• ActiveX Instructions
• DLL Instructions

Overview

Note: You can create a more powerful combo box cell by placing a List Pro fpCombo control on the fpSpread control. For more information, see Creating a Combo Box Cell Using the FarPoint fpCombo Control.

Combo box cells can function as drop-down combo boxes or drop-down list boxes. By default, they function as drop-down list boxes, in which the user cannot edit the text in the cell. If you prefer, you can change the cell to act as a drop-down combo box, in which users can edit the text in the cell. The cell then acts as the edit field for the combo box.

If the combo box cell functions as a drop-down list box, you can allow the user to type one or more characters to search for an item in the list by typing either a single character or multiple characters.

By default, the drop-down list displays three rows. You can change the number of rows that display in the drop-down list. Also by default, the text in the edit field is limited to 60 characters and is left aligned. You can change the maximum number of characters allowed, and you can horizontally and vertically align the text in the edit field.