asposecells.api

Class PivotItem

Represents a item in a PivotField report.

Property Getters/Setters Summary
methodgetIndex()
method
setIndex(value)
           Gets the index of the pivot item in the pivot field
methodisHidden()
method
setHidden(value)
           Gets and Sets whether the pivot item is hidden.
methodisHideDetail()
method
           Gets and Sets whether the pivot item hides detail.
methodisMissing()
Indicates whether the item has a missing value.
methodgetName()
Gets the name of the pivot item.
voidsetPosition(value)
Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
voidsetPositionInSameParentNode(value)
Specifying the position index in the PivotItems under the same parent node.
methodgetValue()
Gets the value of the pivot item
 
Method Summary
methodgetDateTimeValue()
Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue
methodgetDoubleValue()
Gets the double value of the pivot item If the value is null or not number ,it will return 0
methodgetStringValue()
Gets the string value of the pivot item If the value is null, it will return ""
methodhide(value)
Sets whether the pivot item is hidden.
methodmove(count, isSameParent)
Moves the item up or down
 

    • Property Getters/Setters Detail

      • isHidden/setHidden : boolean 

        boolean isHidden() / setHidden(value)
        
        Gets and Sets whether the pivot item is hidden.
      • setPosition : int 

        setPosition(value)
        
        Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
      • setPositionInSameParentNode : int 

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

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

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

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

        String getName()
        
        Gets the name of the pivot item.
      • getIndex/setIndex : int 

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

      • hide

         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

         move(count, isSameParent)
        Moves the item up or down
        Parameters:
        count: int - 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

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

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

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