You can provide automatic completion (type ahead) of user input to a cell. You use the IAutoCompleteSupport interface and its properties to provide the automatic completion feature in the editable cell types.

Basically there are two properties that are set. First you set the mode of automatic completion, as shown in the figure above. The options include whether to suggest a list of possible completions or a drop-down list of possible completions or both (or none).

Second, you can set the source of the suggestions and drop-down list. The source is the list of items that are considered for completion. You can create a custom source and define your own list of items or you can set various system sources. There are two properties in the interface that provide settings for the custom source. The first one sets the list of possible candidates for a custom source. The second sets whether to fill the list with the list of values from other cells in the column. To use the values in the cells in the column, for example, you would set the source to custom and then turn on automatic fill. The automatic fill only adds items to the custom source if they are above or below the cell without a blank cell in between.

For an example of automatic completion, refer to the web site at http://www.componentone.com/SuperProducts/SpreadStudio/Demos/.

For information on other features of cell types, refer to Understanding Additional Features of Cell Types.