Aspose::Cells::Pivot::PivotTable::CalculateData method
Contents
[
Hide
]PivotTable::CalculateData() method
Calculates data of pivottable to cells.
void Aspose::Cells::Pivot::PivotTable::CalculateData()
Remarks
This method only calculate data with the cached data in the PivotCache. So if you want to calcualte with latest data source, please use PivotCache.Refresh() method to calculate. If only the setting of pivot table is changed, PivotTable.CalculateData() is enough.
See Also
- Class Vector
- Class PivotTable
- Namespace Aspose::Cells::Pivot
- Library Aspose.Cells for C++
PivotTable::CalculateData(const PivotTableCalculateOption&) method
Calculates pivot table with options.
Vector<PivotTable> Aspose::Cells::Pivot::PivotTable::CalculateData(const PivotTableCalculateOption &option)
| Parameter | Type | Description |
|---|---|---|
| option | const PivotTableCalculateOption& | The options for calculating the pivot table |
ReturnValue
Returns all pivot tables which have been calculated. If PivotTableCalculateOption.RefreshData is true,all pivot tables based on same pivot cache will be calculated together.
Remarks
If PivotTableCalculateOption.RefreshData is true, this method will refresh pivot cache from data source,then calculate all pivot tables based same pivot cache. Otherwise, only calculating with the cached data in the pivot cache.
See Also
- Class Vector
- Class PivotTable
- Class PivotTableCalculateOption
- Class PivotTable
- Namespace Aspose::Cells::Pivot
- Library Aspose.Cells for C++