Auto Expand Tables

SpreadJS supports the automatic expansion of tables. A table will expand automatically if data is entered or pasted in the empty adjacent row or column of the table.

The allowAutoExpand method can be used to enable or disable the automatic expansion of tables. Its default value is true.

The following code sample adds a table and displays the value of the allowAutoExpand method.

// Add Table
var table = activeSheet.tables.add("ExpandTable", 1, 1, 4, 3, GC.Spread.Sheets.Tables.TableThemes.dark1);
// allowAutoExpand is true by default, but we can set it to false as well for disabling auto expansion of tables
alert(table.allowAutoExpand());