SpreadJS 14
GC.Spread.Pivot Namespace / PivotTable type / getStyle Method
the specific pivotArea
In This Topic
    getStyle Method
    In This Topic
    Syntax
    var instance = new GC.Spread.Pivot.PivotTable(name, sheet, row, col, layout, style);
    var value; // Type: any
    value = instance.getStyle(pivotArea);
    function getStyle( 
       pivotArea : IPivotArea
    ) : any;

    Parameters

    pivotArea
    the specific pivotArea

    Return Value

    GC.Spread.Sheets.Style
    Example
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
    var sourceSheet = spread.getSheet(0)
    var sheet = spread.getSheet(1);
    var sourceData = [["Date","Buyer","Type","Amount"],
                     ["01-Jan","Mom","Fuel",74],
                     ["15-Jan","Mom","Food",235],
                     ["17-Jan","Dad","Sports",20],
                     ["21-Jan","Kelly","Books",125]];
    sourceSheet.setArray(0, 0, sourceData);
    sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
    var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
    var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
    var options = {showRowHeader: true, showColumnHeader: true};
    var pivotTable = sheet.pivotTables.add("pivotTable1", 'sourceData', 1, 1, layout, theme, options);
    pivotTable.add("Buyer", "Buyer", GC.Spread.Pivot.PivotTableFieldType.rowField);
    pivotTable.add("Type", "Type", GC.Spread.Pivot.PivotTableFieldType.rowField);
    pivotTable.add("Date", "Date", GC.Spread.Pivot.PivotTableFieldType.columnField);
    pivotTable.add("Amount", "Amount", GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
    var pivotArea = {
        dataOnly: false,
        references: [
            {
                fieldName: "Buyer",
                items: ["Mom", "Dad"]
            }
        ]
    };
    var style = new GC.Spread.Sheets.Style();
    redBack.backColor = '#ff0000';
    pivotTable.setStyle(pivotArea, style);
    pivotTable.getStyle(pivotArea);
    See Also

    Reference

    PivotTable type