aspose.cells

Class PivotItem

Represents a item in a PivotField report.

Property Getters/Setters Summary
functiongetIndex()
function
setIndex(value)
           Gets the index of the pivot item in cache field.
functionisFormula()
function
setFormula(value)
           Indicates whether this pivot item is a calculated formula item.
functionisHidden()
function
setHidden(value)
           Gets and Sets whether the pivot item is hidden.
functionisHideDetail()
function
           Gets and Sets whether the pivot item hides detail.
functionisMissing()
Indicates whether the item is removed from the data source.
functiongetName()
Gets the name of the pivot item.
functiongetPosition()
function
           Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
functiongetPositionInSameParentNode()
function
           Specifying the position index in the PivotItems under the same parent node.
functiongetValue()
Gets the value of the pivot item
 
Method Summary
functiongetDateTimeValue()
Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue
functiongetDoubleValue()
Gets the double value of the pivot item If the value is null or not number ,it will return 0
functiongetStringValue()
Gets the string value of the pivot item If the value is null, it will return ""
functionhide(value)
Sets whether the pivot item is hidden.
functionmove(count, isSameParent)
Moves the item up or down
 

    • Property Getters/Setters Detail

      • isHidden/setHidden : boolean 

        function isHidden() / function setHidden(value)
        
        Gets and Sets whether the pivot item is hidden.
      • getPosition/setPosition : Number 

        function getPosition() / function setPosition(value)
        
        Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
      • getPositionInSameParentNode/setPositionInSameParentNode : Number 

        function getPositionInSameParentNode() / function setPositionInSameParentNode(value)
        
        Specifying the position index in the PivotItems under the same parent node.
      • isHideDetail/setHideDetail : boolean 

        function isHideDetail() / function setHideDetail(value)
        
        Gets and Sets whether the pivot item hides detail.
      • isFormula/setFormula : boolean 

        function isFormula() / function setFormula(value)
        
        Indicates whether this pivot item is a calculated formula item.
      • isMissing : boolean 

        function isMissing()
        
        Indicates whether the item is removed from the data source. True means this value has benn removed from the data source.
      • getValue : Object 

        function getValue()
        
        Gets the value of the pivot item
      • getName : String 

        function getName()
        
        Gets the name of the pivot item.
      • getIndex/setIndex : Number 

        function getIndex() / function setIndex(value)
        
        Gets the index of the pivot item in cache field.
    • Method Detail

      • hide

        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.
      • move

        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
      • getStringValue

        function getStringValue()
        Gets the string value of the pivot item If the value is null, it will return ""
      • getDoubleValue

        function getDoubleValue()
        Gets the double value of the pivot item If the value is null or not number ,it will return 0
      • getDateTimeValue

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