SpreadJS 14
GC.Spread.Pivot Namespace / PivotTable type / layoutType Method
Indicates the pivot Table layout Type
In This Topic
    layoutType Method
    In This Topic
    Syntax
    var instance = new GC.Spread.Pivot.PivotTable(name, sheet, row, col, layout, style);
    var value; // Type: PivotTableLayoutType
    value = instance.layoutType(type);
    function layoutType( 
       (optional) type : PivotTableLayoutType
    ) : PivotTableLayoutType;

    Parameters

    type
    Indicates the pivot Table layout Type

    Return Value

    If no parameters are passed in, get the current layout type.
    Example
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
    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("pivotTable_1", 'sourceData', 1, 1, layout, theme, options);
    var pivotTableLayoutType = GC.Spread.Pivot.PivotTableLayoutType.compact;
    pivotTable.layoutType(pivotTableLayoutType);
    pivotTable.layoutType();//GC.Spread.Pivot.PivotTableLayoutType.compact
    See Also

    Reference

    PivotTable type