KeyTable

Reference

Spreadsheet navigation of a DataTable makes for an attractive and rapid data input interface, and also a very familiar one for those users experienced in Excel, OpenOffice or similar, who are now transitioning to web based apps.

KeyTable adds keyboard navigation to DataTables, operating in exactly the same way as traditional spreadsheet applications.

Enable the KeyTable extension for DataTables.

.KeyTable(true)

Or, configure it.

.KeyTable(kt => kt.Blurable(false).Clipboard(false))

Blurable

Allow KeyTable's focus to be blurred (removed) from a table.

.Blurable(false)

ClassName

Set the class name used for the focused cell.

.ClassName("highlight")

Clipboard

Enable / disable clipboard interaction with KeyTable.

.Clipboard(false)

ClipboardOrthogonal

Set the orthogonal data to copy to clipboard.

.ClipboardOrthogonal("export")

Columns

Select the columns that can gain focus.

.Columns(":not(:last-child)")

EditOnFocus

Control if editing should be activated immediately upon focus.

.EditOnFocus(true)

Editor

Attach an Editor instance for Excel like editing.

.Editor("editor")

Focus

Cell to receive initial focus in the table.

.Focus(":eq(0)")

Keys

Limit the keys that KeyTable will listen for and take action on.

.Keys(0, 1)

TabIndex

Set the table's tab index for when it will receive focus.

.TabIndex(-1)