aspose.cells
Class PivotItem

function isHidden() / function setHidden(value)

Gets and Sets whether the pivot item is hidden.

function setPosition(value)

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

function setPositionInSameParentNode(value)

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

function getValue()

Gets the value of the pivot item

function getName()

Gets the name of the pivot item.

function getIndex() / function setIndex(value)

Gets the index of the pivot item in the pivot field

function hide(value)

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.

function move(count, isSameParent)

Moves the item up or down

Parameters:

count: Number - The number of moving up or down. Move the item up if this is less than zero; Move the item down if this is greater than zero.

isSameParent: boolean - Specifying whether moving operation is in the same parent node or not

function getStringValue()

Gets the string value of the pivot item If the value is null, it will return ""

function getDoubleValue()

Gets the double value of the pivot item If the value is null or not number ,it will return 0

function getDateTimeValue()

Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue