com.aspose.cells

com.aspose.cells

Class PivotItem

  • java.lang.Object
    • com.aspose.cells.PivotItem
public class PivotItem 
extends java.lang.Object

Represents a item in a PivotField report.

Property Getters/Setters Summary
intgetIndex()
void
setIndex(intvalue)
           Gets the index of the pivot item in the pivot field
booleanisHidden()
void
setHidden(booleanvalue)
           Gets and Sets whether the pivot item is hidden.
java.lang.StringgetName()
Gets the name of the pivot item.
voidsetPosition(int value)
Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
voidsetPositionInSameParentNode(int value)
Specifying the position index in the PivotItems under the same parent node.
java.lang.ObjectgetValue()
Gets the value of the pivot item
 
Method Summary
com.aspose.cells.DateTimegetDateTimeValue()
Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue
doublegetDoubleValue()
Gets the double value of the pivot item If the value is null or not number ,it will return 0
java.lang.StringgetStringValue()
Gets the string value of the pivot item If the value is null, it will return ""
voidhide(boolean value)
Sets whether the pivot item is hidden.
voidmove(int count, boolean isSameParent)
Moves the item up or down
 

    • Property Getters/Setters Detail

      • isHidden/setHidden

        public boolean isHidden() / public void setHidden(boolean value)
        Gets and Sets whether the pivot item is hidden.

      • setPosition

        public void setPosition(int value)
        Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.

      • setPositionInSameParentNode

        public void setPositionInSameParentNode(int value)
        Specifying the position index in the PivotItems under the same parent node.

      • getValue

        public java.lang.Object getValue()
        Gets the value of the pivot item

      • getName

        public java.lang.String getName()
        Gets the name of the pivot item.

      • getIndex/setIndex

        public int getIndex() / public void setIndex(int value)
        Gets the index of the pivot item in the pivot field

    setHidden

    public voidsetHidden(booleanvalue)
    Gets and Sets whether the pivot item is hidden.

    setIndex

    public voidsetIndex(intvalue)
    Gets the index of the pivot item in the pivot field

    • Method Detail

      • hide

        public void hide(boolean 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

        public void move(int count, boolean isSameParent)
        Moves the item up or down
        Parameters:
        count - 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 - Specifying whether moving operation is in the same parent node or not

      • getStringValue

        public java.lang.String getStringValue()
        Gets the string value of the pivot item If the value is null, it will return ""

      • getDoubleValue

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

      • getDateTimeValue

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