Dropdown and autocomplete column type

jExcel brings a very powerful, flexivel and responsive dropdown column type to support a better user experience through your applications. The new dropdown column options include autocomplete, multiple options, data picker, different template types and much more advantages, such as:

Create a simple dropdown from array

Value or key-value selectbox is available

Populate a dropdown from a external JSON request

Dynamic autocomplete search based on another column value

Conditional dropdowns: options from a dropdown based on a method return

Multiple selection and internal dropdown search

Responsive data picker with multiple render types

Image icon and group items

Multiple and autocomplete options

The highlight features intruduced in the most version of the vanilla javascript spreadsheet is definetely the autocomplete and multiple options. The following example shows the column Product Origin with the autocomplete and multiple directives initiated as true.