Autocomplete cell type

This page shows how to configure Handsontable with Autocomplete cell type:

Autocomplete lazy mode
Autocomplete strict mode
Autocomplete strict mode (Ajax)

Autocomplete lazy mode

This example shows the usage of the Autocomplete feature.

List of autocomplete suggestions is rendered by Twitter Bootstrap Typeahead library.

The property options overrides $.fn.typeahead.defaults from Bootstrap. It may be useful to configure the number of displayed suggestions.

Autocomplete strict mode

This is the same example as above with a difference that autocomplete now runs in strict mode.

In this mode, the autocomplete cells will only accept values that are defined in the source array.

Autocomplete strict mode (Ajax)

Autocomplete can be also used with Ajax data source. In the below example, suggestions for the "Car" column are loaded from server.

To load data from remote (asynchrous) source, assign a function to the 'source' property. Function should perform the server side request and call the callback function when the result is available.