Aspose::Cells::Pivot::PivotItem class

PivotItem class

Represents a item in a PivotField report.

class PivotItem

Methods

MethodDescription
GetDateTimeValue()Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue.
GetDoubleValue()Gets the double value of the pivot item If the value is null or not number ,it will return 0.
GetFormula()Gets the formula of this calculated item. Only works when this item is calculated item.
GetIndex()Gets the index of the pivot item in cache field.
GetName()Gets the name of the pivot item.
GetPosition()Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
GetPositionInSameParentNode()Specifying the position index in the PivotItems under the same parent node.
GetStringValue()Gets the string value of the pivot item If the value is null, it will return “”.
GetValue()Gets the value of the pivot item.
IsCalculatedItem()Indicates whether this pivot item is a calculated formula item.
IsDetailHidden()Gets and sets whether the detail of this pivot item is hidden.
IsHidden()Gets and Sets whether the pivot item is hidden.
IsMissing()Indicates whether the item is removed from the data source.
IsNull() constChecks whether the implementation object is nullptr.
Move(int32_t count, bool isSameParent)Moves the item up or down.
explicit operator bool() constoperator bool()
operator=(const PivotItem& src)operator=
PivotItem(PivotItem_Impl* impl)Constructs from an implementation object.
PivotItem(const PivotItem& src)Copy constructor.
SetIndex(int32_t value)Gets the index of the pivot item in cache field.
SetIsDetailHidden(bool value)Gets and sets whether the detail of this pivot item is hidden.
SetIsHidden(bool value)Gets and Sets whether the pivot item is hidden.
SetName(const U16String& value)Gets the name of the pivot item.
SetName(const char16_t* value)Gets the name of the pivot item.
SetPosition(int32_t value)Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
SetPositionInSameParentNode(int32_t value)Specifying the position index in the PivotItems under the same parent node.
~PivotItem()Destructor.

Fields

FieldDescription
_implThe implementation object.

See Also