PivotTableRefreshOption

PivotTableRefreshOption class

Represents the options of refreshing data source of the pivot table.

class PivotTableRefreshOption;

Constructors

Name	Description
constructor()	Represents the options of refreshing data source of the pivot table.

Properties

Property	Type	Description
reserveMissingPivotItemType	ReserveMissingPivotItemType	Represents how to reserve missing pivot items.
isKeepOriginalOrder	boolean	Indicates whether to keep pivot items’ original order as old data source.
keepCachedLocalGroupData	boolean	Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. The default value is false which means refreshing group with local setting.

constructor()

Represents the options of refreshing data source of the pivot table.

constructor();

reserveMissingPivotItemType

Represents how to reserve missing pivot items.

reserveMissingPivotItemType : ReserveMissingPivotItemType;

isKeepOriginalOrder

Indicates whether to keep pivot items’ original order as old data source.

isKeepOriginalOrder : boolean;

Remarks

Only applicable for the pivot field which is not sorted. When refreshing such kind of pivot field, Ms Excel keeps the original order of old data source. Default value of this property is true, representing the same behavior with Ms Excel. If user needs the pivot field to be refreshed completely as the data in the new data source, this property should be set as false.

keepCachedLocalGroupData

Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. The default value is false which means refreshing group with local setting.

keepCachedLocalGroupData : boolean;

Remarks

This is a temporary solution, please localize pivot tables by implementing Aspose.Cells.Settings.PivotGlobalizationSettings