PivotItem

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

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

hide()

Sets whether the pivot item is hidden. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Pivot.PivotField.HideItem method. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

isFormula()

Indicates whether this pivot item is a calculated formula item.

isHidden()

Gets and Sets whether the pivot item is hidden.

isHideDetail()

Gets and Sets whether the pivot item hides detail.

isMissing()

Indicates whether the item is removed from the data source. True means this value has benn removed from the data source.

move(count, isSameParent)

Moves the item up or down

setFormula()

Indicates whether this pivot item is a calculated formula item.

setHidden()

Gets and Sets whether the pivot item is hidden.

setHideDetail()

Gets and Sets whether the pivot item hides detail.

setIndex()

Gets the index of the pivot item in cache field.

setPosition()

Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.

setPositionInSameParentNode()

Specifying the position index in the PivotItems under the same parent node.