Aspose::Cells::Pivot::PivotTable::CalculateData method

PivotTable::CalculateData() method

Calculates data of pivottable to cells.

void Aspose::Cells::Pivot::PivotTable::CalculateData()

Remarks

Cell.Value in the pivot range could not return the correct result if the method is not been called. This method calculates data with an inner pivot cache,not original data source. So if the data source is changed, please call RefreshData() method first.

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.

void Aspose::Cells::Pivot::PivotTable::CalculateData(const PivotTableCalculateOption &option)

Parameter	Type	Description
option	const PivotTableCalculateOption&	The options for calculating the pivot table

Remarks

If PivotTableCalculateOption.RefreshData is true, this method will refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

See Also

• Class Vector
• Class PivotTableCalculateOption
• Class PivotTable
• Namespace Aspose::Cells::Pivot
• Library Aspose.Cells for C++