AutoFill gives an Excel like option to a DataTable to click and drag over multiple cells, filling in information over the selected cells and incrementing numbers as needed. AutoFill is initialised using the autoFilloption as shown in the example below. This can be set to be trueto use the AutoFill configuration defaults, or used as an objectto specify options.

The autoFill.alwaysAskoption can be used to force AutoFill to confirm the action to take, even if there is only one option. This provides the end user with the ability to cancelthe action if they made a mistake during the drag. This example shows autoFill.alwaysAskset to true- to demonstrate, try auto filling a single row or column.

The click-to-dragauto fill handle can be attached to the table using a number of different triggers. This is set by the autoFill.focusoption: click, focusand hover. The default behaviour is hover, unless KeyTable is also initialised on the same table, in which case focus is used. This example shows the clickbehaviour. Click a cell to show the auto fill handle. Note that a click outside of the table will cause the handle to be removed.

This ability to exclude columns from the AutoFill action can be particularly useful if the table contains non-data columns. This example uses the Selectextension for DataTables to allow row selection through the select option, with row selection restricted to the first column. Thus we do not wish to have AutoFillon that column and the selector :not(:first-child)for autoFill.columnsenacts that.