SpreadJS 14
GC.Spread.Sheets.Tables Namespace / Table type / expandBoundRows Method
Whether to expand by sheet or table insert/delete rows.
In This Topic
    expandBoundRows Method
    In This Topic
    Gets or sets a value that table expand rows mode in binding case.
    Syntax
    var instance = new GC.Spread.Sheets.Tables.Table(name,
                                                    row,
                                                    col,
                                                    rowCount,
                                                    colCount,
                                                    style,
                                                    options,
                                                    options.showHeader,
                                                    options.showFooter,
                                                    options.useFooterDropDownList,
                                                    options.showResizeHandle);
    var returnValue; // Type: any
    returnValue = instance.expandBoundRows(value);
    function expandBoundRows( 
       value : boolean
    ) : any;

    Parameters

    value
    Whether to expand by sheet or table insert/delete rows.

    Return Value

    If no value is set, returns whether to expand by sheet or table insert/delete rows; otherwise, returns the table.
    Example
    var spread = GC.Spread.Sheets.findControl("ss") || GC.Spread.Sheets.findControl("sampleDiv");
    var sheet = spread.getActiveSheet();
    var data = {
        name: 'Jones', region: 'East',
        sales: [
            { orderDate: '1/6/2013', item: 'Pencil', units: 95, cost: 1.99 },
            { orderDate: '4/1/2013', item: 'Binder', units: 60, cost: 4.99 },
            { orderDate: '6/8/2013', item: 'Pen Set', units: 16, cost: 15.99 },
            { orderDate: '8/1/2013', item: 'Pencil', units: 20, cost: 24.99 },
            { orderDate: '10/8/2013', item: 'Binder', units: 31, cost: 16.99 }
        ]
    };
    var table1 = sheet.tables.add('tableRecords', 0, 0, 4, 4);
    var table2 = sheet.tables.add('tableBelow', 4, 0, 4, 7);
    table1.bindingPath('sales');
    var dataSource = new GC.Spread.Sheets.Bindings.CellBindingSource(data);
    table1.expandBoundRows(true);
    sheet.setDataSource(dataSource);
    See Also

    Reference

    Table type