Aspose::Cells::Pivot::IPivotPageFields Class Referenceabstract

Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields. More...

Inherits Object.

Public Member Functions

virtual void AddPageField (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> pageItems)=0
 Adds a page field. More...
 
virtual Aspose::Cells::Systems::Int32 GetPageFieldCount ()=0
 Gets the number of page fields. More...
 
virtual void AddIdentify (Aspose::Cells::Systems::Int32 rangeIndex, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >> pageItemIndex)=0
 Sets which item label in each page field to use to identify the data range. The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first. More...
 

Detailed Description

Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.

Member Function Documentation

◆ AddIdentify()

virtual void Aspose::Cells::Pivot::IPivotPageFields::AddIdentify ( Aspose::Cells::Systems::Int32  rangeIndex,
intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >>  pageItemIndex 
)
pure virtual

Sets which item label in each page field to use to identify the data range. The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first.

Parameters
rangeIndexThe consolidation data range index.
pageItemIndexThe page item index in the each page field. pageItemIndex[2] = 1 means the second item in the third field to use to identify this range. pageItemIndex[1] = -1 means no item in the second field to use to identify this range and MS will auto create "blank" item in the second field to identify this range.

◆ AddPageField()

virtual void Aspose::Cells::Pivot::IPivotPageFields::AddPageField ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>>  pageItems)
pure virtual

Adds a page field.

Parameters
pageItemsPage field item label

◆ GetPageFieldCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Pivot::IPivotPageFields::GetPageFieldCount ( )
pure virtual

Gets the number of page fields.