SpreadJS 14
GC.Spread.Sheets Namespace / Events type / PivotTableChanged Event
The PivotTable's name.
The specific operation name("filter" | "sort" | "collapse" | "fieldChanged" | "summarizedValueBy" | "showValueAs" | "dataPositionChanged" | "viewChanged").
Changed fieldName.
PivotTable changes the value of the previous attribute(collapse, summarizedValueBy, showValueAs).
PivotTable changes the value of the previous attribute(collapse, summarizedValueBy, showValueAs).
PivotTable sort changes the value of the attribute(sort).
PivotTable filter changes the value of the attribute(filter).
PivotTable clear filter changes the value of the attribute(filter).
Old PivotTable Field Type(fieldChanged).
Old PivotTable Field index(fieldChanged).
New PivotTable Field Type(fieldChanged).
New PivotTable Field index(fieldChanged).
Apply PivotTable Views Name(viewChanged).
In This Topic
    PivotTableChanged Event
    In This Topic
    After PivotTable filter/sort/collapse/fieldChanged.
    Syntax
    var instance; // Type: Events
    instance.PivotTableChanged = function(pivotTableName,
                                          type,
                                          fieldName,
                                          oldValue,
                                          newValue,
                                          sortType,
                                          filterInfo,
                                          clearType,
                                          oldArea,
                                          oldIndex,
                                          newArea,
                                          newIndex,
                                          viewName) { };
    PivotTableChanged = function ( 
       pivotTableName : string,
       type : string,
       (optional) fieldName : string,
       (optional) oldValue : boolean,
       (optional) newValue : boolean,
       (optional) sortType : number,
       (optional) filterInfo : Object,
       (optional) clearType : number,
       (optional) oldArea : number,
       (optional) oldIndex : number,
       (optional) newArea : number,
       (optional) newIndex : number,
       (optional) viewName : string
    ) { };

    Parameters

    pivotTableName
    The PivotTable's name.
    type
    The specific operation name("filter" | "sort" | "collapse" | "fieldChanged" | "summarizedValueBy" | "showValueAs" | "dataPositionChanged" | "viewChanged").
    fieldName
    Changed fieldName.
    oldValue
    PivotTable changes the value of the previous attribute(collapse, summarizedValueBy, showValueAs).
    newValue
    PivotTable changes the value of the previous attribute(collapse, summarizedValueBy, showValueAs).
    sortType
    PivotTable sort changes the value of the attribute(sort).
    filterInfo
    PivotTable filter changes the value of the attribute(filter).
    clearType
    PivotTable clear filter changes the value of the attribute(filter).
    oldArea
    Old PivotTable Field Type(fieldChanged).
    oldIndex
    Old PivotTable Field index(fieldChanged).
    newArea
    New PivotTable Field Type(fieldChanged).
    newIndex
    New PivotTable Field index(fieldChanged).
    viewName
    Apply PivotTable Views Name(viewChanged).
    Example
    //This example.
    sheet.bind(GC.Spread.Sheets.Events.PivotTableChanged, function (sender, args) {
        alert("pivotTableName: " + args.pivotTableName + "changeType: " + args.type);
    });
    See Also

    Reference

    Events type