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 function can be used to enable or disable the automatic expansion of tables. Its default value is true.

Using Code

The following example adds a table and displays the value of allowAutoExpand function.

// 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());