Aspose::Cells::Pivot::PivotTableRefreshOption::SetIsKeepOriginalOrder method

PivotTableRefreshOption::SetIsKeepOriginalOrder method

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

void Aspose::Cells::Pivot::PivotTableRefreshOption::SetIsKeepOriginalOrder(bool value)

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.

See Also

Aspose::Cells::Pivot::PivotTableRefreshOption::IsKeepOriginalOrder method Aspose::Cells::Pivot::PivotTableRefreshOption::_impl field