Summary description for PivotTable. More...

Inherits IDisposable, and Object.

Public Member Functions
virtual void	Dispose ()=0
	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. More...

virtual bool	IsExcel2003Compatible ()=0
	Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. More...

virtual void	SetExcel2003Compatible (bool value)=0
	Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetRefreshedByWho ()=0
	Gets the name of the user who last refreshed the PivotTable More...

virtual intrusive_ptr< Aspose::Cells::Systems::DateTime >	GetRefreshDate ()=0
	Gets the date when the PivotTable was last refreshed. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetPivotTableStyleName ()=0
	Gets and sets the pivottable style name. More...

virtual void	SetPivotTableStyleName (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Sets the pivottable style name. More...

virtual Aspose::Cells::Pivot::PivotTableStyleType	GetPivotTableStyleType ()=0
	Gets the built-in pivot table style. More...

virtual void	SetPivotTableStyleType (Aspose::Cells::Pivot::PivotTableStyleType value)=0
	Sets the built-in pivot table style. More...

virtual void	CopyStyle (intrusive_ptr< Aspose::Cells::Pivot::IPivotTable > pivotTable)=0
	Copies named style from another pivot table. More...

virtual void	ShowReportFilterPage (intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pageField)=0
	Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields. More...

virtual void	ShowReportFilterPageByName (intrusive_ptr< Aspose::Cells::Systems::String > fieldName)=0
	Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields. More...

virtual void	ShowReportFilterPageByIndex (Aspose::Cells::Systems::Int32 posIndex)=0
	Show all the report filter pages according to the position index in the PageFields More...

virtual void	RemoveField (Aspose::Cells::Pivot::PivotFieldType fieldType, intrusive_ptr< Aspose::Cells::Systems::String > fieldName)=0
	Removes a field from specific field area More...

virtual void	RemoveField (Aspose::Cells::Pivot::PivotFieldType fieldType, Aspose::Cells::Systems::Int32 baseFieldIndex)=0
	Removes a field from specific field area More...

virtual void	RemoveField (Aspose::Cells::Pivot::PivotFieldType fieldType, intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField)=0
	Remove field from specific field area More...

virtual Aspose::Cells::Systems::Int32	AddFieldToArea (Aspose::Cells::Pivot::PivotFieldType fieldType, intrusive_ptr< Aspose::Cells::Systems::String > fieldName)=0
	Adds the field to the specific area. More...

virtual Aspose::Cells::Systems::Int32	AddFieldToArea (Aspose::Cells::Pivot::PivotFieldType fieldType, Aspose::Cells::Systems::Int32 baseFieldIndex)=0
	Adds the field to the specific area. More...

virtual Aspose::Cells::Systems::Int32	AddFieldToArea (Aspose::Cells::Pivot::PivotFieldType fieldType, intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField)=0
	Adds the field to the specific area. More...

virtual void	AddCalculatedField (intrusive_ptr< Aspose::Cells::Systems::String > name, intrusive_ptr< Aspose::Cells::Systems::String > formula, bool dragToDataArea)=0
	Adds a calculated field to pivot field. More...

virtual void	AddCalculatedField (intrusive_ptr< Aspose::Cells::Systems::String > name, intrusive_ptr< Aspose::Cells::Systems::String > formula)=0
	Adds a calculated field to pivot field and drag it to data area. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIPivotFields (Aspose::Cells::Pivot::PivotFieldType fieldType)=0
	Gets the specific fields by the field type. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIColumnFields ()=0
	Returns a PivotFields object that are currently shown as column fields. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIRowFields ()=0
	Returns a PivotFields object that are currently shown as row fields. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIPageFields ()=0
	Returns a PivotFields object that are currently shown as page fields. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIDataFields ()=0
	Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotField >	GetIDataField ()=0
	Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFieldCollection >	GetIBaseFields ()=0
	Returns a PivotFields object that includes all fields in the PivotTable report More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFilterCollection >	GetIPivotFilters ()=0
	Returns a PivotFilterCollection object. More...

virtual intrusive_ptr< Aspose::Cells::ICellArea >	GetIColumnRange ()=0
	Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only. More...

virtual intrusive_ptr< Aspose::Cells::ICellArea >	GetIRowRange ()=0
	Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only. More...

virtual intrusive_ptr< Aspose::Cells::ICellArea >	GetIDataBodyRange ()=0
	Returns a CellArea object that represents the range that contains the data area in the list between the header row and the insert row. Read-only. More...

virtual intrusive_ptr< Aspose::Cells::ICellArea >	GetITableRange1 ()=0
	Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only. More...

virtual intrusive_ptr< Aspose::Cells::ICellArea >	GetITableRange2 ()=0
	Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only. More...

virtual void	Move (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
	Moves the PivotTable to a different location in the worksheet. More...

virtual void	Move (intrusive_ptr< Aspose::Cells::Systems::String > destCellName)=0
	Moves the PivotTable to a different location in the worksheet. More...

virtual bool	GetColumnGrand ()=0
	Indicates whether the PivotTable report shows grand totals for columns. More...

virtual void	SetColumnGrand (bool value)=0
	Indicates whether the PivotTable report shows grand totals for columns. More...

virtual bool	IsGridDropZones ()=0
	Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid) More...

virtual void	SetGridDropZones (bool value)=0
	Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid) More...

virtual bool	GetRowGrand ()=0
	Indicates whether the PivotTable report shows grand totals for rows. More...

virtual void	SetRowGrand (bool value)=0
	Indicates whether the PivotTable report shows grand totals for rows. More...

virtual bool	GetDisplayNullString ()=0
	Indicates whether the PivotTable report displays a custom string in cells that contain null values. More...

virtual void	SetDisplayNullString (bool value)=0
	Indicates whether the PivotTable report displays a custom string in cells that contain null values. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetNullString ()=0
	Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. More...

virtual void	SetNullString (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. More...

virtual bool	GetDisplayErrorString ()=0
	Indicates whether the PivotTable report displays a custom string in cells that contain errors. More...

virtual void	SetDisplayErrorString (bool value)=0
	Indicates whether the PivotTable report displays a custom string in cells that contain errors. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetErrorString ()=0
	Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. More...

virtual void	SetErrorString (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. More...

virtual bool	IsAutoFormat ()=0
	Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007 More...

virtual void	SetAutoFormat (bool value)=0
	Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007 More...

virtual Aspose::Cells::Pivot::PivotTableAutoFormatType	GetAutoFormatType ()=0
	Gets the PivotTable auto format type. More...

virtual void	SetAutoFormatType (Aspose::Cells::Pivot::PivotTableAutoFormatType value)=0
	Gets the PivotTable auto format type. More...

virtual bool	HasBlankRows ()=0
	Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows. More...

virtual void	SetHasBlankRows (bool value)=0
	Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows. More...

virtual bool	GetMergeLabels ()=0
	Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells. More...

virtual void	SetMergeLabels (bool value)=0
	Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells. More...

virtual bool	GetPreserveFormatting ()=0
	Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated. More...

virtual void	SetPreserveFormatting (bool value)=0
	Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated. More...

virtual bool	GetShowDrill ()=0
	Gets whether expand/collapse buttons is shown. More...

virtual void	SetShowDrill (bool value)=0
	Sets whether expand/collapse buttons is shown. More...

virtual bool	GetEnableDrilldown ()=0
	Gets whether drilldown is enabled. More...

virtual void	SetEnableDrilldown (bool value)=0
	Sets whether drilldown is enabled. More...

virtual bool	GetEnableFieldDialog ()=0
	Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. More...

virtual void	SetEnableFieldDialog (bool value)=0
	Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. More...

virtual bool	GetEnableFieldList ()=0
	Gets whether enable the field list for the PivotTable. More...

virtual void	SetEnableFieldList (bool value)=0
	Gets whether enable the field list for the PivotTable. More...

virtual bool	GetEnableWizard ()=0
	Indicates whether the PivotTable Wizard is available. More...

virtual void	SetEnableWizard (bool value)=0
	Indicates whether the PivotTable Wizard is available. More...

virtual bool	GetSubtotalHiddenPageItems ()=0
	Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False. More...

virtual void	SetSubtotalHiddenPageItems (bool value)=0
	Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetGrandTotalName ()=0
	Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". More...

virtual void	SetGrandTotalName (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". More...

virtual bool	GetManualUpdate ()=0
	Indicates whether the PivotTable report is recalculated only at the user's request. More...

virtual void	SetManualUpdate (bool value)=0
	Indicates whether the PivotTable report is recalculated only at the user's request. More...

virtual bool	IsMultipleFieldFilters ()=0
	Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. More...

virtual void	SetMultipleFieldFilters (bool value)=0
	Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. More...

virtual Aspose::Cells::Pivot::PivotMissingItemLimitType	GetMissingItemsLimit ()=0
	Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. More...

virtual void	SetMissingItemsLimit (Aspose::Cells::Pivot::PivotMissingItemLimitType value)=0
	Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. More...

virtual bool	GetEnableDataValueEditing ()=0
	Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area More...

virtual void	SetEnableDataValueEditing (bool value)=0
	Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area More...

virtual bool	GetShowDataTips ()=0
	Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells. More...

virtual void	SetShowDataTips (bool value)=0
	Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells. More...

virtual bool	GetShowMemberPropertyTips ()=0
	Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips. More...

virtual void	SetShowMemberPropertyTips (bool value)=0
	Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips. More...

virtual bool	GetShowValuesRow ()=0
	Specifies a boolean value that indicates whether show values row. show the values row More...

virtual void	SetShowValuesRow (bool value)=0
	Specifies a boolean value that indicates whether show values row. show the values row More...

virtual bool	GetShowEmptyCol ()=0
	Specifies a boolean value that indicates whether to include empty columns in the table More...

virtual void	SetShowEmptyCol (bool value)=0
	Specifies a boolean value that indicates whether to include empty columns in the table More...

virtual bool	GetShowEmptyRow ()=0
	Specifies a boolean value that indicates whether to include empty rows in the table. More...

virtual void	SetShowEmptyRow (bool value)=0
	Specifies a boolean value that indicates whether to include empty rows in the table. More...

virtual bool	GetFieldListSortAscending ()=0
	Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list. More...

virtual void	SetFieldListSortAscending (bool value)=0
	Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list. More...

virtual bool	GetPrintDrill ()=0
	Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable. More...

virtual void	SetPrintDrill (bool value)=0
	Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetAltTextTitle ()=0
	Gets the title of the alttext More...

virtual void	SetAltTextTitle (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Gets the title of the alttext More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetAltTextDescription ()=0
	Gets the description of the alt text More...

virtual void	SetAltTextDescription (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Gets the description of the alt text More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetName ()=0
	Gets the name of the PivotTable More...

virtual void	SetName (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Sets the name of the PivotTable More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetColumnHeaderCaption ()=0
	Gets the Column Header Caption of the PivotTable. More...

virtual void	SetColumnHeaderCaption (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Sets the Column Header Caption of the PivotTable. More...

virtual Aspose::Cells::Systems::Int32	GetIndent ()=0
	Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. More...

virtual void	SetIndent (Aspose::Cells::Systems::Int32 value)=0
	Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetRowHeaderCaption ()=0
	Gets the Row Header Caption of the PivotTable. More...

virtual void	SetRowHeaderCaption (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Sets the Row Header Caption of the PivotTable. More...

virtual bool	GetShowRowHeaderCaption ()=0
	Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs More...

virtual void	SetShowRowHeaderCaption (bool value)=0
	Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs More...

virtual bool	GetCustomListSort ()=0
	Indicates whether consider built-in custom list when sort data More...

virtual void	SetCustomListSort (bool value)=0
	Indicates whether consider built-in custom list when sort data More...

virtual intrusive_ptr< Aspose::Cells::Pivot::IPivotFormatConditionCollection >	GetIPivotFormatConditions ()=0
	Gets the Format Conditions of the pivot table. More...

virtual Aspose::Cells::PrintOrderType	GetPageFieldOrder ()=0
	Gets the order in which page fields are added to the PivotTable report's layout. More...

virtual void	SetPageFieldOrder (Aspose::Cells::PrintOrderType value)=0
	Sets the order in which page fields are added to the PivotTable report's layout. More...

virtual Aspose::Cells::Systems::Int32	GetPageFieldWrapCount ()=0
	Gets the number of page fields in each column or row in the PivotTable report. More...

virtual void	SetPageFieldWrapCount (Aspose::Cells::Systems::Int32 value)=0
	Sets the number of page fields in each column or row in the PivotTable report. More...

virtual intrusive_ptr< Aspose::Cells::Systems::String >	GetTag ()=0
	Gets a string saved with the PivotTable report. More...

virtual void	SetTag (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
	Sets a string saved with the PivotTable report. More...

virtual bool	GetSaveData ()=0
	Indicates whether data for the PivotTable report is saved with the workbook. More...

virtual void	SetSaveData (bool value)=0
	Indicates whether data for the PivotTable report is saved with the workbook. More...

virtual bool	GetRefreshDataOnOpeningFile ()=0
	Indicates whether Refresh Data when Opening File. More...

virtual void	SetRefreshDataOnOpeningFile (bool value)=0
	Indicates whether Refresh Data when Opening File. More...

virtual bool	GetRefreshDataFlag ()=0
	Indicates whether Refresh Data or not. More...

virtual void	SetRefreshDataFlag (bool value)=0
	Indicates whether Refresh Data or not. More...

virtual intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String * > >	GetDataSource ()=0
	Gets and sets the data source of the pivot table. More...

virtual void	SetDataSource (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> value)=0
	Sets and sets the data source of the pivot table. More...

virtual void	ChangeDataSource (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> source)=0
	Set pivottable's source data. Sheet1!$A$1:$C$3 More...

virtual intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String * > >	GetSource ()=0
	Get pivottable's source data. More...

virtual void	RefreshData ()=0
	Refreshes pivottable's data and setting from it's data source. More...

virtual void	CalculateData ()=0
	Calculates pivottable's data to cells. More...

virtual void	ClearData ()=0
	Clear PivotTable's data and formatting More...

virtual void	CalculateRange ()=0
	Calculates pivottable's range. More...

virtual void	FormatAll (intrusive_ptr< Aspose::Cells::IStyle > style)=0
	Format all the cell in the pivottable area More...

virtual void	FormatRow (Aspose::Cells::Systems::Int32 row, intrusive_ptr< Aspose::Cells::IStyle > style)=0
	Format the row data in the pivottable area More...

virtual void	Format (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column, intrusive_ptr< Aspose::Cells::IStyle > style)=0

virtual bool	GetItemPrintTitles ()=0
	A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form. More...

virtual void	SetItemPrintTitles (bool value)=0
	A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form. More...

virtual bool	GetPrintTitles ()=0
	Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false. More...

virtual void	SetPrintTitles (bool value)=0
	Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false. More...

virtual bool	GetDisplayImmediateItems ()=0
	Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true. More...

virtual void	SetDisplayImmediateItems (bool value)=0
	Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true. More...

virtual bool	IsSelected ()=0
	Indicates whether the PivotTable is selected. More...

virtual void	SetSelected (bool value)=0
	Indicates whether the PivotTable is selected. More...

virtual bool	GetShowPivotStyleRowHeader ()=0
	Indicates whether the row header in the pivot table should have the style applied. More...

virtual void	SetShowPivotStyleRowHeader (bool value)=0
	Indicates whether the row header in the pivot table should have the style applied. More...

virtual bool	GetShowPivotStyleColumnHeader ()=0
	Indicates whether the column header in the pivot table should have the style applied. More...

virtual void	SetShowPivotStyleColumnHeader (bool value)=0
	Indicates whether the column header in the pivot table should have the style applied. More...

virtual bool	GetShowPivotStyleRowStripes ()=0
	Indicates whether row stripe formatting is applied. More...

virtual void	SetShowPivotStyleRowStripes (bool value)=0
	Indicates whether row stripe formatting is applied. More...

virtual bool	GetShowPivotStyleColumnStripes ()=0
	Indicates whether column stripe formatting is applied. More...

virtual void	SetShowPivotStyleColumnStripes (bool value)=0
	Indicates whether column stripe formatting is applied. More...

virtual bool	GetShowPivotStyleLastColumn ()=0
	Indicates whether column stripe formatting is applied. More...

virtual void	SetShowPivotStyleLastColumn (bool value)=0
	Indicates whether column stripe formatting is applied. More...

virtual void	SetAutoGroupField (Aspose::Cells::Systems::Int32 baseFieldIndex)=0
	Sets auto field group by the PivotTable. More...

virtual void	SetAutoGroupField (intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField)=0
	Sets auto field group by the PivotTable. More...

virtual void	SetManualGroupField (Aspose::Cells::Systems::Int32 baseFieldIndex, Aspose::Cells::Systems::Double startVal, Aspose::Cells::Systems::Double endVal, intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > groupByList, Aspose::Cells::Systems::Double intervalNum)=0
	Sets manual field group by the PivotTable. More...

virtual void	SetManualGroupField (intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField, Aspose::Cells::Systems::Double startVal, Aspose::Cells::Systems::Double endVal, intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > groupByList, Aspose::Cells::Systems::Double intervalNum)=0
	Sets manual field group by the PivotTable. More...

virtual void	SetManualGroupField (Aspose::Cells::Systems::Int32 baseFieldIndex, intrusive_ptr< Aspose::Cells::Systems::DateTime > startVal, intrusive_ptr< Aspose::Cells::Systems::DateTime > endVal, intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > groupByList, Aspose::Cells::Systems::Int32 intervalNum)=0
	Sets manual field group by the PivotTable. More...

virtual void	SetManualGroupField (intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField, intrusive_ptr< Aspose::Cells::Systems::DateTime > startVal, intrusive_ptr< Aspose::Cells::Systems::DateTime > endVal, intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > groupByList, Aspose::Cells::Systems::Int32 intervalNum)=0
	Sets manual field group by the PivotTable. More...

virtual void	SetUngroup (Aspose::Cells::Systems::Int32 baseFieldIndex)=0
	Sets ungroup by the PivotTable More...

virtual void	SetUngroup (intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField)=0
	Sets ungroup by the PivotTable More...

virtual intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >	GetHorizontalBreaks ()=0
	get pivot table row index list of horizontal pagebreaks More...

virtual void	ShowInCompactForm ()=0
	Layouts the PivotTable in compact form. More...

virtual void	ShowInOutlineForm ()=0
	Layouts the PivotTable in outline form. More...

virtual void	ShowInTabularForm ()=0
	Layouts the PivotTable in tabular form. More...

virtual intrusive_ptr< Aspose::Cells::ICell >	GetICellByDisplayName (intrusive_ptr< Aspose::Cells::Systems::String > displayName)=0
	Gets the Cell object by the DisplayName of PivotField More...

virtual intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Pivot::IPivotTable * > >	GetIChildren ()=0
	Gets the Children Pivot Tables which use this PivotTable data as data source. More...

virtual void	add_ref ()

virtual int	release_ref ()

Detailed Description

Summary description for PivotTable.

Member Function Documentation

◆ add_ref()

virtual void Aspose::Cells::Pivot::IPivotTable::add_ref ( )

inlinevirtual

◆ AddCalculatedField() [1/2]

virtual void Aspose::Cells::Pivot::IPivotTable::AddCalculatedField	(	intrusive_ptr< Aspose::Cells::Systems::String >	name,
		intrusive_ptr< Aspose::Cells::Systems::String >	formula,
		bool	dragToDataArea
	)

pure virtual

Adds a calculated field to pivot field.

Parameters

name	The name of the calculated field
formula	The formula of the calculated field.
dragToDataArea	True,drag this field to data area immediately

◆ AddCalculatedField() [2/2]

virtual void Aspose::Cells::Pivot::IPivotTable::AddCalculatedField	(	intrusive_ptr< Aspose::Cells::Systems::String >	name,
		intrusive_ptr< Aspose::Cells::Systems::String >	formula
	)

pure virtual

Adds a calculated field to pivot field and drag it to data area.

Parameters

name	The name of the calculated field
formula	The formula of the calculated field.

◆ AddFieldToArea() [1/3]

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotTable::AddFieldToArea	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		intrusive_ptr< Aspose::Cells::Systems::String >	fieldName
	)

pure virtual

Adds the field to the specific area.

Parameters

fieldType	The fields area type.
fieldName	The name in the base fields.

Returns: The field position in the specific fields.If there is no field named as it, return -1.

AddFieldToArea(PivotFieldType,PivotField)

◆ AddFieldToArea() [2/3]

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotTable::AddFieldToArea	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		Aspose::Cells::Systems::Int32	baseFieldIndex
	)

pure virtual

Adds the field to the specific area.

Parameters

fieldType	The fields area type.
baseFieldIndex	The field index in the base fields.

Returns: The field position in the specific fields.

AddFieldToArea(PivotFieldType,PivotField)

◆ AddFieldToArea() [3/3]

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotTable::AddFieldToArea	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		intrusive_ptr< Aspose::Cells::Pivot::IPivotField >	pivotField
	)

pure virtual

Adds the field to the specific area.

Parameters

fieldType

the fields area type.It could be one of the following values:

PivotFieldType.Row

PivotFieldType.Column

PivotFieldType.Data

PivotFieldType.Page

pivotField the field in the base fields.

Returns: the field position in the specific fields.

◆ CalculateData()

virtual void Aspose::Cells::Pivot::IPivotTable::CalculateData ( )

pure virtual

Calculates pivottable's data to cells.

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

◆ CalculateRange()

virtual void Aspose::Cells::Pivot::IPivotTable::CalculateRange ( )

pure virtual

Calculates pivottable's range.

If this method is not been called,maybe the pivottable range is not corrected.

◆ ChangeDataSource()

virtual void Aspose::Cells::Pivot::IPivotTable::ChangeDataSource ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> source )

pure virtual

Set pivottable's source data. Sheet1!$A$1:$C$3

◆ ClearData()

virtual void Aspose::Cells::Pivot::IPivotTable::ClearData ( )

pure virtual

Clear PivotTable's data and formatting

If this method is not callled before you add or delete PivotField, Maybe the PivotTable data is not corrected

◆ CopyStyle()

virtual void Aspose::Cells::Pivot::IPivotTable::CopyStyle ( intrusive_ptr< Aspose::Cells::Pivot::IPivotTable > pivotTable )

pure virtual

Copies named style from another pivot table.

Parameters

pivotTable Source pivot table.

◆ Dispose()

virtual void Aspose::Cells::Pivot::IPivotTable::Dispose ( )

pure virtual

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

◆ Format()

virtual void Aspose::Cells::Pivot::IPivotTable::Format	(	Aspose::Cells::Systems::Int32	row,
		Aspose::Cells::Systems::Int32	column,
		intrusive_ptr< Aspose::Cells::IStyle >	style
	)

pure virtual

Format the cell in the pivottable area

Parameters

row	RowIndex of the cell
column	Column index of the cell
style	Style which is to format the cell

◆ FormatAll()

virtual void Aspose::Cells::Pivot::IPivotTable::FormatAll ( intrusive_ptr< Aspose::Cells::IStyle > style )

pure virtual

Format all the cell in the pivottable area

Parameters

style Style which is to format

◆ FormatRow()

virtual void Aspose::Cells::Pivot::IPivotTable::FormatRow	(	Aspose::Cells::Systems::Int32	row,
		intrusive_ptr< Aspose::Cells::IStyle >	style
	)

pure virtual

Format the row data in the pivottable area

Parameters

row	Row Index of the Row object
style	Style which is to format

◆ GetAltTextDescription()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetAltTextDescription ( )

pure virtual

Gets the description of the alt text

◆ GetAltTextTitle()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetAltTextTitle ( )

pure virtual

Gets the title of the alttext

◆ GetAutoFormatType()

virtual Aspose::Cells::Pivot::PivotTableAutoFormatType Aspose::Cells::Pivot::IPivotTable::GetAutoFormatType ( )

pure virtual

Gets the PivotTable auto format type.

PivotTableAutoFormatType

◆ GetColumnGrand()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetColumnGrand ( )

pure virtual

Indicates whether the PivotTable report shows grand totals for columns.

◆ GetColumnHeaderCaption()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetColumnHeaderCaption ( )

pure virtual

Gets the Column Header Caption of the PivotTable.

◆ GetCustomListSort()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetCustomListSort ( )

pure virtual

Indicates whether consider built-in custom list when sort data

◆ GetDataSource()

virtual intrusive_ptr<Aspose::Cells::Systems::Array1D<Aspose::Cells::Systems::String*> > Aspose::Cells::Pivot::IPivotTable::GetDataSource ( )

pure virtual

Gets and sets the data source of the pivot table.

◆ GetDisplayErrorString()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetDisplayErrorString ( )

pure virtual

Indicates whether the PivotTable report displays a custom string in cells that contain errors.

◆ GetDisplayImmediateItems()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetDisplayImmediateItems ( )

pure virtual

Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true.

◆ GetDisplayNullString()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetDisplayNullString ( )

pure virtual

Indicates whether the PivotTable report displays a custom string in cells that contain null values.

◆ GetEnableDataValueEditing()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetEnableDataValueEditing ( )

pure virtual

Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area

◆ GetEnableDrilldown()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetEnableDrilldown ( )

pure virtual

Gets whether drilldown is enabled.

◆ GetEnableFieldDialog()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetEnableFieldDialog ( )

pure virtual

Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.

◆ GetEnableFieldList()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetEnableFieldList ( )

pure virtual

Gets whether enable the field list for the PivotTable.

◆ GetEnableWizard()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetEnableWizard ( )

pure virtual

Indicates whether the PivotTable Wizard is available.

◆ GetErrorString()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetErrorString ( )

pure virtual

Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.

◆ GetFieldListSortAscending()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetFieldListSortAscending ( )

pure virtual

Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list.

◆ GetGrandTotalName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetGrandTotalName ( )

pure virtual

Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total".

◆ GetHorizontalBreaks()

virtual intrusive_ptr<Aspose::Cells::Systems::Collections::ArrayList> Aspose::Cells::Pivot::IPivotTable::GetHorizontalBreaks ( )

pure virtual

get pivot table row index list of horizontal pagebreaks

Returns

◆ GetIBaseFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIBaseFields ( )

pure virtual

Returns a PivotFields object that includes all fields in the PivotTable report

◆ GetICellByDisplayName()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::Pivot::IPivotTable::GetICellByDisplayName ( intrusive_ptr< Aspose::Cells::Systems::String > displayName )

pure virtual

Gets the Cell object by the DisplayName of PivotField

Parameters

displayName the DisplayName of PivotField

Returns: the Cell object

◆ GetIChildren()

virtual intrusive_ptr<Aspose::Cells::Systems::Array1D<Aspose::Cells::Pivot::IPivotTable*> > Aspose::Cells::Pivot::IPivotTable::GetIChildren ( )

pure virtual

Gets the Children Pivot Tables which use this PivotTable data as data source.

Returns: the PivotTable array object

◆ GetIColumnFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIColumnFields ( )

pure virtual

Returns a PivotFields object that are currently shown as column fields.

◆ GetIColumnRange()

virtual intrusive_ptr<Aspose::Cells::ICellArea> Aspose::Cells::Pivot::IPivotTable::GetIColumnRange ( )

pure virtual

Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only.

◆ GetIDataBodyRange()

virtual intrusive_ptr<Aspose::Cells::ICellArea> Aspose::Cells::Pivot::IPivotTable::GetIDataBodyRange ( )

pure virtual

Returns a CellArea object that represents the range that contains the data area in the list between the header row and the insert row. Read-only.

◆ GetIDataField()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotField> Aspose::Cells::Pivot::IPivotTable::GetIDataField ( )

pure virtual

Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area.

◆ GetIDataFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIDataFields ( )

pure virtual

Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area.

◆ GetIndent()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotTable::GetIndent ( )

pure virtual

Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.

◆ GetIPageFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIPageFields ( )

pure virtual

Returns a PivotFields object that are currently shown as page fields.

◆ GetIPivotFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIPivotFields ( Aspose::Cells::Pivot::PivotFieldType fieldType )

pure virtual

Gets the specific fields by the field type.

Parameters

fieldType the field type.

Returns: the specific fields

◆ GetIPivotFilters()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFilterCollection> Aspose::Cells::Pivot::IPivotTable::GetIPivotFilters ( )

pure virtual

Returns a PivotFilterCollection object.

◆ GetIPivotFormatConditions()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFormatConditionCollection> Aspose::Cells::Pivot::IPivotTable::GetIPivotFormatConditions ( )

pure virtual

Gets the Format Conditions of the pivot table.

◆ GetIRowFields()

virtual intrusive_ptr<Aspose::Cells::Pivot::IPivotFieldCollection> Aspose::Cells::Pivot::IPivotTable::GetIRowFields ( )

pure virtual

Returns a PivotFields object that are currently shown as row fields.

◆ GetIRowRange()

virtual intrusive_ptr<Aspose::Cells::ICellArea> Aspose::Cells::Pivot::IPivotTable::GetIRowRange ( )

pure virtual

Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only.

◆ GetITableRange1()

virtual intrusive_ptr<Aspose::Cells::ICellArea> Aspose::Cells::Pivot::IPivotTable::GetITableRange1 ( )

pure virtual

Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only.

◆ GetITableRange2()

virtual intrusive_ptr<Aspose::Cells::ICellArea> Aspose::Cells::Pivot::IPivotTable::GetITableRange2 ( )

pure virtual

Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only.

◆ GetItemPrintTitles()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetItemPrintTitles ( )

pure virtual

A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form.

◆ GetManualUpdate()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetManualUpdate ( )

pure virtual

Indicates whether the PivotTable report is recalculated only at the user's request.

◆ GetMergeLabels()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetMergeLabels ( )

pure virtual

Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.

◆ GetMissingItemsLimit()

virtual Aspose::Cells::Pivot::PivotMissingItemLimitType Aspose::Cells::Pivot::IPivotTable::GetMissingItemsLimit ( )

pure virtual

Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.

◆ GetName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetName ( )

pure virtual

Gets the name of the PivotTable

◆ GetNullString()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetNullString ( )

pure virtual

Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.

◆ GetPageFieldOrder()

virtual Aspose::Cells::PrintOrderType Aspose::Cells::Pivot::IPivotTable::GetPageFieldOrder ( )

pure virtual

Gets the order in which page fields are added to the PivotTable report's layout.

◆ GetPageFieldWrapCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotTable::GetPageFieldWrapCount ( )

pure virtual

Gets the number of page fields in each column or row in the PivotTable report.

◆ GetPivotTableStyleName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetPivotTableStyleName ( )

pure virtual

Gets and sets the pivottable style name.

◆ GetPivotTableStyleType()

virtual Aspose::Cells::Pivot::PivotTableStyleType Aspose::Cells::Pivot::IPivotTable::GetPivotTableStyleType ( )

pure virtual

Gets the built-in pivot table style.

◆ GetPreserveFormatting()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetPreserveFormatting ( )

pure virtual

Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.

◆ GetPrintDrill()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetPrintDrill ( )

pure virtual

Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable.

◆ GetPrintTitles()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetPrintTitles ( )

pure virtual

Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false.

◆ GetRefreshDataFlag()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetRefreshDataFlag ( )

pure virtual

Indicates whether Refresh Data or not.

◆ GetRefreshDataOnOpeningFile()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetRefreshDataOnOpeningFile ( )

pure virtual

Indicates whether Refresh Data when Opening File.

◆ GetRefreshDate()

virtual intrusive_ptr<Aspose::Cells::Systems::DateTime> Aspose::Cells::Pivot::IPivotTable::GetRefreshDate ( )

pure virtual

Gets the date when the PivotTable was last refreshed.

◆ GetRefreshedByWho()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetRefreshedByWho ( )

pure virtual

Gets the name of the user who last refreshed the PivotTable

◆ GetRowGrand()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetRowGrand ( )

pure virtual

Indicates whether the PivotTable report shows grand totals for rows.

◆ GetRowHeaderCaption()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetRowHeaderCaption ( )

pure virtual

Gets the Row Header Caption of the PivotTable.

◆ GetSaveData()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetSaveData ( )

pure virtual

Indicates whether data for the PivotTable report is saved with the workbook.

◆ GetShowDataTips()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowDataTips ( )

pure virtual

Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.

◆ GetShowDrill()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowDrill ( )

pure virtual

Gets whether expand/collapse buttons is shown.

◆ GetShowEmptyCol()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowEmptyCol ( )

pure virtual

Specifies a boolean value that indicates whether to include empty columns in the table

◆ GetShowEmptyRow()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowEmptyRow ( )

pure virtual

Specifies a boolean value that indicates whether to include empty rows in the table.

◆ GetShowMemberPropertyTips()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowMemberPropertyTips ( )

pure virtual

Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.

◆ GetShowPivotStyleColumnHeader()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowPivotStyleColumnHeader ( )

pure virtual

Indicates whether the column header in the pivot table should have the style applied.

◆ GetShowPivotStyleColumnStripes()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowPivotStyleColumnStripes ( )

pure virtual

Indicates whether column stripe formatting is applied.

◆ GetShowPivotStyleLastColumn()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowPivotStyleLastColumn ( )

pure virtual

Indicates whether column stripe formatting is applied.

◆ GetShowPivotStyleRowHeader()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowPivotStyleRowHeader ( )

pure virtual

Indicates whether the row header in the pivot table should have the style applied.

◆ GetShowPivotStyleRowStripes()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowPivotStyleRowStripes ( )

pure virtual

Indicates whether row stripe formatting is applied.

◆ GetShowRowHeaderCaption()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowRowHeaderCaption ( )

pure virtual

Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs

◆ GetShowValuesRow()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetShowValuesRow ( )

pure virtual

Specifies a boolean value that indicates whether show values row. show the values row

◆ GetSource()

virtual intrusive_ptr<Aspose::Cells::Systems::Array1D<Aspose::Cells::Systems::String*> > Aspose::Cells::Pivot::IPivotTable::GetSource ( )

pure virtual

Get pivottable's source data.

◆ GetSubtotalHiddenPageItems()

virtual bool Aspose::Cells::Pivot::IPivotTable::GetSubtotalHiddenPageItems ( )

pure virtual

Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False.

◆ GetTag()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Pivot::IPivotTable::GetTag ( )

pure virtual

Gets a string saved with the PivotTable report.

◆ HasBlankRows()

virtual bool Aspose::Cells::Pivot::IPivotTable::HasBlankRows ( )

pure virtual

Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows.

◆ IsAutoFormat()

virtual bool Aspose::Cells::Pivot::IPivotTable::IsAutoFormat ( )

pure virtual

Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007

◆ IsExcel2003Compatible()

virtual bool Aspose::Cells::Pivot::IPivotTable::IsExcel2003Compatible ( )

pure virtual

Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true.

◆ IsGridDropZones()

virtual bool Aspose::Cells::Pivot::IPivotTable::IsGridDropZones ( )

pure virtual

Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)

◆ IsMultipleFieldFilters()

virtual bool Aspose::Cells::Pivot::IPivotTable::IsMultipleFieldFilters ( )

pure virtual

Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.

◆ IsSelected()

virtual bool Aspose::Cells::Pivot::IPivotTable::IsSelected ( )

pure virtual

Indicates whether the PivotTable is selected.

◆ Move() [1/2]

virtual void Aspose::Cells::Pivot::IPivotTable::Move	(	Aspose::Cells::Systems::Int32	row,
		Aspose::Cells::Systems::Int32	column
	)

pure virtual

Moves the PivotTable to a different location in the worksheet.

Parameters

row	row index.
column	column index.

◆ Move() [2/2]

virtual void Aspose::Cells::Pivot::IPivotTable::Move ( intrusive_ptr< Aspose::Cells::Systems::String > destCellName )

pure virtual

Moves the PivotTable to a different location in the worksheet.

Parameters

destCellName the dest cell name.

◆ RefreshData()

virtual void Aspose::Cells::Pivot::IPivotTable::RefreshData ( )

pure virtual

Refreshes pivottable's data and setting from it's data source.

We will gather data from data source to a pivot cache ,then calcualte the data in the cache to the cells. This method is only used to gather all data to a pivot cache.

◆ release_ref()

virtual int Aspose::Cells::Pivot::IPivotTable::release_ref ( )

inlinevirtual

◆ RemoveField() [1/3]

virtual void Aspose::Cells::Pivot::IPivotTable::RemoveField	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		intrusive_ptr< Aspose::Cells::Systems::String >	fieldName
	)

pure virtual

Removes a field from specific field area

Parameters

fieldType	The fields area type.
fieldName	The name in the base fields.

RemoveField(PivotFieldType,PivotField)

◆ RemoveField() [2/3]

virtual void Aspose::Cells::Pivot::IPivotTable::RemoveField	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		Aspose::Cells::Systems::Int32	baseFieldIndex
	)

pure virtual

Removes a field from specific field area

Parameters

fieldType	The fields area type.
baseFieldIndex	The field index in the base fields.

RemoveField(PivotFieldType,PivotField)

◆ RemoveField() [3/3]

virtual void Aspose::Cells::Pivot::IPivotTable::RemoveField	(	Aspose::Cells::Pivot::PivotFieldType	fieldType,
		intrusive_ptr< Aspose::Cells::Pivot::IPivotField >	pivotField
	)

pure virtual

Remove field from specific field area

Parameters

fieldType

the fields area type.It could be one of the following values:

PivotFieldType.Row

PivotFieldType.Column

PivotFieldType.Data

PivotFieldType.Page

pivotField the field in the base fields.

◆ SetAltTextDescription()

virtual void Aspose::Cells::Pivot::IPivotTable::SetAltTextDescription ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Gets the description of the alt text

◆ SetAltTextTitle()

virtual void Aspose::Cells::Pivot::IPivotTable::SetAltTextTitle ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Gets the title of the alttext

◆ SetAutoFormat()

virtual void Aspose::Cells::Pivot::IPivotTable::SetAutoFormat ( bool value )

pure virtual

Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007

◆ SetAutoFormatType()

virtual void Aspose::Cells::Pivot::IPivotTable::SetAutoFormatType ( Aspose::Cells::Pivot::PivotTableAutoFormatType value )

pure virtual

Gets the PivotTable auto format type.

PivotTableAutoFormatType

◆ SetAutoGroupField() [1/2]

virtual void Aspose::Cells::Pivot::IPivotTable::SetAutoGroupField ( Aspose::Cells::Systems::Int32 baseFieldIndex )

pure virtual

Sets auto field group by the PivotTable.

Parameters

baseFieldIndex The row or column field index in the base fields

◆ SetAutoGroupField() [2/2]

virtual void Aspose::Cells::Pivot::IPivotTable::SetAutoGroupField ( intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField )

pure virtual

Sets auto field group by the PivotTable.

Parameters

pivotField The row or column field in the specific fields

◆ SetColumnGrand()

virtual void Aspose::Cells::Pivot::IPivotTable::SetColumnGrand ( bool value )

pure virtual

Indicates whether the PivotTable report shows grand totals for columns.

◆ SetColumnHeaderCaption()

virtual void Aspose::Cells::Pivot::IPivotTable::SetColumnHeaderCaption ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Sets the Column Header Caption of the PivotTable.

◆ SetCustomListSort()

virtual void Aspose::Cells::Pivot::IPivotTable::SetCustomListSort ( bool value )

pure virtual

Indicates whether consider built-in custom list when sort data

◆ SetDataSource()

virtual void Aspose::Cells::Pivot::IPivotTable::SetDataSource ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> value )

pure virtual

Sets and sets the data source of the pivot table.

◆ SetDisplayErrorString()

virtual void Aspose::Cells::Pivot::IPivotTable::SetDisplayErrorString ( bool value )

pure virtual

Indicates whether the PivotTable report displays a custom string in cells that contain errors.

◆ SetDisplayImmediateItems()

virtual void Aspose::Cells::Pivot::IPivotTable::SetDisplayImmediateItems ( bool value )

pure virtual

Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true.

◆ SetDisplayNullString()

virtual void Aspose::Cells::Pivot::IPivotTable::SetDisplayNullString ( bool value )

pure virtual

Indicates whether the PivotTable report displays a custom string in cells that contain null values.

◆ SetEnableDataValueEditing()

virtual void Aspose::Cells::Pivot::IPivotTable::SetEnableDataValueEditing ( bool value )

pure virtual

Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area

◆ SetEnableDrilldown()

virtual void Aspose::Cells::Pivot::IPivotTable::SetEnableDrilldown ( bool value )

pure virtual

Sets whether drilldown is enabled.

◆ SetEnableFieldDialog()

virtual void Aspose::Cells::Pivot::IPivotTable::SetEnableFieldDialog ( bool value )

pure virtual

Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.

◆ SetEnableFieldList()

virtual void Aspose::Cells::Pivot::IPivotTable::SetEnableFieldList ( bool value )

pure virtual

Gets whether enable the field list for the PivotTable.

◆ SetEnableWizard()

virtual void Aspose::Cells::Pivot::IPivotTable::SetEnableWizard ( bool value )

pure virtual

Indicates whether the PivotTable Wizard is available.

◆ SetErrorString()

virtual void Aspose::Cells::Pivot::IPivotTable::SetErrorString ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string.

◆ SetExcel2003Compatible()

virtual void Aspose::Cells::Pivot::IPivotTable::SetExcel2003Compatible ( bool value )

pure virtual

Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true.

◆ SetFieldListSortAscending()

virtual void Aspose::Cells::Pivot::IPivotTable::SetFieldListSortAscending ( bool value )

pure virtual

Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list.

◆ SetGrandTotalName()

virtual void Aspose::Cells::Pivot::IPivotTable::SetGrandTotalName ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total".

◆ SetGridDropZones()

virtual void Aspose::Cells::Pivot::IPivotTable::SetGridDropZones ( bool value )

pure virtual

Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid)

◆ SetHasBlankRows()

virtual void Aspose::Cells::Pivot::IPivotTable::SetHasBlankRows ( bool value )

pure virtual

Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows.

◆ SetIndent()

virtual void Aspose::Cells::Pivot::IPivotTable::SetIndent ( Aspose::Cells::Systems::Int32 value )

pure virtual

Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form.

◆ SetItemPrintTitles()

virtual void Aspose::Cells::Pivot::IPivotTable::SetItemPrintTitles ( bool value )

pure virtual

A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form.

◆ SetManualGroupField() [1/4]

virtual void Aspose::Cells::Pivot::IPivotTable::SetManualGroupField	(	Aspose::Cells::Systems::Int32	baseFieldIndex,
		Aspose::Cells::Systems::Double	startVal,
		Aspose::Cells::Systems::Double	endVal,
		intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >	groupByList,
		Aspose::Cells::Systems::Double	intervalNum
	)

pure virtual

Sets manual field group by the PivotTable.

Parameters

baseFieldIndex	The row or column field index in the base fields
startVal	Specifies the starting value for numeric grouping.
endVal	Specifies the ending value for numeric grouping.
groupByList	Specifies the grouping type list. Specified by PivotTableGroupType
intervalNum	Specifies the interval number group by numeric grouping.

◆ SetManualGroupField() [2/4]

virtual void Aspose::Cells::Pivot::IPivotTable::SetManualGroupField	(	intrusive_ptr< Aspose::Cells::Pivot::IPivotField >	pivotField,
		Aspose::Cells::Systems::Double	startVal,
		Aspose::Cells::Systems::Double	endVal,
		intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >	groupByList,
		Aspose::Cells::Systems::Double	intervalNum
	)

pure virtual

Sets manual field group by the PivotTable.

Parameters

pivotField	The row or column field in the base fields
startVal	Specifies the starting value for numeric grouping.
endVal	Specifies the ending value for numeric grouping.
groupByList	Specifies the grouping type list. Specified by PivotTableGroupType
intervalNum	Specifies the interval number group by numeric grouping.

◆ SetManualGroupField() [3/4]

virtual void Aspose::Cells::Pivot::IPivotTable::SetManualGroupField	(	Aspose::Cells::Systems::Int32	baseFieldIndex,
		intrusive_ptr< Aspose::Cells::Systems::DateTime >	startVal,
		intrusive_ptr< Aspose::Cells::Systems::DateTime >	endVal,
		intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >	groupByList,
		Aspose::Cells::Systems::Int32	intervalNum
	)

pure virtual

Sets manual field group by the PivotTable.

Parameters

baseFieldIndex	The row or column field index in the base fields
startVal	Specifies the starting value for date grouping.
endVal	Specifies the ending value for date grouping.
groupByList	Specifies the grouping type list. Specified by PivotTableGroupType
intervalNum	Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero

◆ SetManualGroupField() [4/4]

virtual void Aspose::Cells::Pivot::IPivotTable::SetManualGroupField	(	intrusive_ptr< Aspose::Cells::Pivot::IPivotField >	pivotField,
		intrusive_ptr< Aspose::Cells::Systems::DateTime >	startVal,
		intrusive_ptr< Aspose::Cells::Systems::DateTime >	endVal,
		intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >	groupByList,
		Aspose::Cells::Systems::Int32	intervalNum
	)

pure virtual

Sets manual field group by the PivotTable.

Parameters

pivotField	The row or column field in the base fields
startVal	Specifies the starting value for date grouping.
endVal	Specifies the ending value for date grouping.
groupByList	Specifies the grouping type list. Specified by PivotTableGroupType
intervalNum	Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero

◆ SetManualUpdate()

virtual void Aspose::Cells::Pivot::IPivotTable::SetManualUpdate ( bool value )

pure virtual

Indicates whether the PivotTable report is recalculated only at the user's request.

◆ SetMergeLabels()

virtual void Aspose::Cells::Pivot::IPivotTable::SetMergeLabels ( bool value )

pure virtual

Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.

◆ SetMissingItemsLimit()

virtual void Aspose::Cells::Pivot::IPivotTable::SetMissingItemsLimit ( Aspose::Cells::Pivot::PivotMissingItemLimitType value )

pure virtual

Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.

◆ SetMultipleFieldFilters()

virtual void Aspose::Cells::Pivot::IPivotTable::SetMultipleFieldFilters ( bool value )

pure virtual

Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.

◆ SetName()

virtual void Aspose::Cells::Pivot::IPivotTable::SetName ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Sets the name of the PivotTable

◆ SetNullString()

virtual void Aspose::Cells::Pivot::IPivotTable::SetNullString ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string.

◆ SetPageFieldOrder()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPageFieldOrder ( Aspose::Cells::PrintOrderType value )

pure virtual

Sets the order in which page fields are added to the PivotTable report's layout.

◆ SetPageFieldWrapCount()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPageFieldWrapCount ( Aspose::Cells::Systems::Int32 value )

pure virtual

Sets the number of page fields in each column or row in the PivotTable report.

◆ SetPivotTableStyleName()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPivotTableStyleName ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Sets the pivottable style name.

◆ SetPivotTableStyleType()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPivotTableStyleType ( Aspose::Cells::Pivot::PivotTableStyleType value )

pure virtual

Sets the built-in pivot table style.

◆ SetPreserveFormatting()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPreserveFormatting ( bool value )

pure virtual

Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated.

◆ SetPrintDrill()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPrintDrill ( bool value )

pure virtual

Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable.

◆ SetPrintTitles()

virtual void Aspose::Cells::Pivot::IPivotTable::SetPrintTitles ( bool value )

pure virtual

Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false.

◆ SetRefreshDataFlag()

virtual void Aspose::Cells::Pivot::IPivotTable::SetRefreshDataFlag ( bool value )

pure virtual

Indicates whether Refresh Data or not.

◆ SetRefreshDataOnOpeningFile()

virtual void Aspose::Cells::Pivot::IPivotTable::SetRefreshDataOnOpeningFile ( bool value )

pure virtual

Indicates whether Refresh Data when Opening File.

◆ SetRowGrand()

virtual void Aspose::Cells::Pivot::IPivotTable::SetRowGrand ( bool value )

pure virtual

Indicates whether the PivotTable report shows grand totals for rows.

◆ SetRowHeaderCaption()

virtual void Aspose::Cells::Pivot::IPivotTable::SetRowHeaderCaption ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Sets the Row Header Caption of the PivotTable.

◆ SetSaveData()

virtual void Aspose::Cells::Pivot::IPivotTable::SetSaveData ( bool value )

pure virtual

Indicates whether data for the PivotTable report is saved with the workbook.

◆ SetSelected()

virtual void Aspose::Cells::Pivot::IPivotTable::SetSelected ( bool value )

pure virtual

Indicates whether the PivotTable is selected.

◆ SetShowDataTips()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowDataTips ( bool value )

pure virtual

Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells.

◆ SetShowDrill()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowDrill ( bool value )

pure virtual

Sets whether expand/collapse buttons is shown.

◆ SetShowEmptyCol()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowEmptyCol ( bool value )

pure virtual

Specifies a boolean value that indicates whether to include empty columns in the table

◆ SetShowEmptyRow()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowEmptyRow ( bool value )

pure virtual

Specifies a boolean value that indicates whether to include empty rows in the table.

◆ SetShowMemberPropertyTips()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowMemberPropertyTips ( bool value )

pure virtual

Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips.

◆ SetShowPivotStyleColumnHeader()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowPivotStyleColumnHeader ( bool value )

pure virtual

Indicates whether the column header in the pivot table should have the style applied.

◆ SetShowPivotStyleColumnStripes()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowPivotStyleColumnStripes ( bool value )

pure virtual

Indicates whether column stripe formatting is applied.

◆ SetShowPivotStyleLastColumn()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowPivotStyleLastColumn ( bool value )

pure virtual

Indicates whether column stripe formatting is applied.

◆ SetShowPivotStyleRowHeader()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowPivotStyleRowHeader ( bool value )

pure virtual

Indicates whether the row header in the pivot table should have the style applied.

◆ SetShowPivotStyleRowStripes()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowPivotStyleRowStripes ( bool value )

pure virtual

Indicates whether row stripe formatting is applied.

◆ SetShowRowHeaderCaption()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowRowHeaderCaption ( bool value )

pure virtual

Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs

◆ SetShowValuesRow()

virtual void Aspose::Cells::Pivot::IPivotTable::SetShowValuesRow ( bool value )

pure virtual

Specifies a boolean value that indicates whether show values row. show the values row

◆ SetSubtotalHiddenPageItems()

virtual void Aspose::Cells::Pivot::IPivotTable::SetSubtotalHiddenPageItems ( bool value )

pure virtual

Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False.

◆ SetTag()

virtual void Aspose::Cells::Pivot::IPivotTable::SetTag ( intrusive_ptr< Aspose::Cells::Systems::String > value )

pure virtual

Sets a string saved with the PivotTable report.

◆ SetUngroup() [1/2]

virtual void Aspose::Cells::Pivot::IPivotTable::SetUngroup ( Aspose::Cells::Systems::Int32 baseFieldIndex )

pure virtual

Sets ungroup by the PivotTable

Parameters

baseFieldIndex The row or column field index in the base fields

◆ SetUngroup() [2/2]

virtual void Aspose::Cells::Pivot::IPivotTable::SetUngroup ( intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pivotField )

pure virtual

Sets ungroup by the PivotTable

Parameters

pivotField The row or column field in the base fields

◆ ShowInCompactForm()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowInCompactForm ( )

pure virtual

Layouts the PivotTable in compact form.

◆ ShowInOutlineForm()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowInOutlineForm ( )

pure virtual

Layouts the PivotTable in outline form.

◆ ShowInTabularForm()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowInTabularForm ( )

pure virtual

Layouts the PivotTable in tabular form.

◆ ShowReportFilterPage()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowReportFilterPage ( intrusive_ptr< Aspose::Cells::Pivot::IPivotField > pageField )

pure virtual

Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields.

Parameters

pageField The PivotField object

◆ ShowReportFilterPageByIndex()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowReportFilterPageByIndex ( Aspose::Cells::Systems::Int32 posIndex )

pure virtual

Show all the report filter pages according to the position index in the PageFields

Parameters

posIndex The position index in the PageFields

◆ ShowReportFilterPageByName()

virtual void Aspose::Cells::Pivot::IPivotTable::ShowReportFilterPageByName ( intrusive_ptr< Aspose::Cells::Systems::String > fieldName )

pure virtual

Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields.

Parameters

fieldName The name of PivotField

Public Member Functions

Detailed Description

Member Function Documentation

◆ add_ref()

◆ AddCalculatedField() [1/2]

◆ AddCalculatedField() [2/2]

◆ AddFieldToArea() [1/3]

◆ AddFieldToArea() [2/3]

◆ AddFieldToArea() [3/3]

◆ CalculateData()

◆ CalculateRange()

◆ ChangeDataSource()

◆ ClearData()

◆ CopyStyle()

◆ Dispose()

◆ Format()

◆ FormatAll()

◆ FormatRow()

◆ GetAltTextDescription()

◆ GetAltTextTitle()

◆ GetAutoFormatType()

◆ GetColumnGrand()

◆ GetColumnHeaderCaption()

◆ GetCustomListSort()

◆ GetDataSource()

◆ GetDisplayErrorString()

◆ GetDisplayImmediateItems()

◆ GetDisplayNullString()

◆ GetEnableDataValueEditing()

◆ GetEnableDrilldown()

◆ GetEnableFieldDialog()

◆ GetEnableFieldList()

◆ GetEnableWizard()

◆ GetErrorString()

◆ GetFieldListSortAscending()

◆ GetGrandTotalName()

◆ GetHorizontalBreaks()

◆ GetIBaseFields()

◆ GetICellByDisplayName()

◆ GetIChildren()

◆ GetIColumnFields()

◆ GetIColumnRange()

◆ GetIDataBodyRange()

◆ GetIDataField()

◆ GetIDataFields()

◆ GetIndent()

◆ GetIPageFields()

◆ GetIPivotFields()

◆ GetIPivotFilters()

◆ GetIPivotFormatConditions()

◆ GetIRowFields()

◆ GetIRowRange()

◆ GetITableRange1()

◆ GetITableRange2()

◆ GetItemPrintTitles()

◆ GetManualUpdate()

◆ GetMergeLabels()

◆ GetMissingItemsLimit()

◆ GetName()

◆ GetNullString()

◆ GetPageFieldOrder()

◆ GetPageFieldWrapCount()

◆ GetPivotTableStyleName()

◆ GetPivotTableStyleType()

◆ GetPreserveFormatting()

◆ GetPrintDrill()

◆ GetPrintTitles()

◆ GetRefreshDataFlag()

◆ GetRefreshDataOnOpeningFile()

◆ GetRefreshDate()

◆ GetRefreshedByWho()

◆ GetRowGrand()

◆ GetRowHeaderCaption()

◆ GetSaveData()

◆ GetShowDataTips()

◆ GetShowDrill()

◆ GetShowEmptyCol()

◆ GetShowEmptyRow()

◆ GetShowMemberPropertyTips()

◆ GetShowPivotStyleColumnHeader()