SpreadJS 13
GC.Spread.Sheets.Tables Namespace / Table type / getColumnValue Method
The column index of the table footer. The index is zero-based.
In This Topic
    getColumnValue Method
    In This Topic
    Gets the table footer value with the specified index.
    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 value; // Type: string
    value = instance.getColumnValue(tableColumnIndex);
    function getColumnValue( 
       tableColumnIndex : number
    ) : string;

    Parameters

    tableColumnIndex
    The column index of the table footer. The index is zero-based.

    Return Value

    The table footer value.
    Example
    This example creates a table.
    //Add data
    for (var col = 1; col < 6; col++) {
        for (var row = 2; row < 11; row++) {
            activeSheet.setValue(row, col, row + col);
        }
    }
    
    var sTable = activeSheet.tables.add("table1", 1, 1, 10, 5, GC.Spread.Sheets.Tables.TableTheme.medium2);
    sTable.showFooter(true);
    //set footer value
    sTable.setColumnValue(0, "Total");
    //set footer formula
    sTable.setColumnFormula(4, "SUM(F3:F11)");
    var value = sTable.getColumnValue(0);
    alert(value);
    See Also

    Reference

    Table type