SpreadJS 15
Features / Tables / Auto Expand Tables
In This Topic
    Auto Expand Tables
    In This Topic

    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.

    Automatic expansion of tables

    Using Code

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

    Copy Code
    // 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