Fork me on GitHub

# Handsontable

a minimalistic Excel-like data grid editor for HTML, JavaScript & jQuery

## 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.

For more examples, head back to the main page.

Handsontable © 2012 Marcin Warpechowski and contributors.
Code and documentation licensed under the The MIT License.