PivotItem

Inheritance: java.lang.Object

public class PivotItem

Represents a item in a PivotField report.

Methods

Method	Description
equals(Object arg0)
getClass()
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
getFormula()	Gets the formula of this calculated item.
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
hashCode()
hide(boolean value)	Sets whether the pivot item is hidden.
isCalculatedItem()	Indicates whether this pivot item is a calculated formula item.
isDetailHidden()	Gets whether the detail of this pivot item is hidden.
isFormula()	Indicates whether this pivot item is a calculated formula item.
isHidden()	Gets whether the pivot item is hidden.
isHideDetail()	Gets whether the pivot item hides detail.
isMissing()	Indicates whether the item is removed from the data source.
move(int count, boolean isSameParent)	Moves the item up or down
notify()
notifyAll()
setDetailHidden(boolean value)	Sets whether the detail of this pivot item is hidden.
setFormula(boolean value)	Indicates whether this pivot item is a calculated formula item.
setHidden(boolean value)	Sets whether the pivot item is hidden.
setHideDetail(boolean value)	Sets whether the pivot item hides detail.
setIndex(int value)	Gets the index of the pivot item in cache field.
setName(String value)	Gets the name of the pivot item.
setPosition(int value)	Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
setPositionInSameParentNode(int value)	Specifying the position index in the PivotItems under the same parent node.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

Parameter	Type	Description
arg0	java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getDateTimeValue()

public DateTime getDateTimeValue()

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

Returns: DateTime

getDoubleValue()

public double getDoubleValue()

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

Returns: double

getFormula()

public String getFormula()

Gets the formula of this calculated item. Only works when this item is calculated item.

Returns: java.lang.String -

getIndex()

public int getIndex()

Gets the index of the pivot item in cache field.

Returns: int

getName()

public String getName()

Gets the name of the pivot item.

Returns: java.lang.String

getPosition()

public int getPosition()

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

Returns: int

getPositionInSameParentNode()

public int getPositionInSameParentNode()

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

Returns: int

getStringValue()

public String getStringValue()

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

Returns: java.lang.String

getValue()

public Object getValue()

Gets the value of the pivot item

Returns: java.lang.Object

hashCode()

public native int hashCode()

Returns: int

hide(boolean value)

public void hide(boolean value)

Sets whether the pivot item is hidden.

Remarks

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.

Parameters:

Parameter	Type	Description
value	boolean

isCalculatedItem()

public boolean isCalculatedItem()

Indicates whether this pivot item is a calculated formula item.

Returns: boolean

isDetailHidden()

public boolean isDetailHidden()

Gets whether the detail of this pivot item is hidden.

Returns: boolean

isFormula()

public boolean isFormula()

Indicates whether this pivot item is a calculated formula item.

Remarks

NOTE: This property is now obsolete. Instead, please use PivotItem.IsCalculatedItem property instead. This property will be removed 12 months later since November 2024. Aspose apologizes for any inconvenience you may have experienced.

Returns: boolean

isHidden()

public boolean isHidden()

Gets whether the pivot item is hidden.

Returns: boolean

isHideDetail()

public boolean isHideDetail()

Gets whether the pivot item hides detail.

Remarks

NOTE: This property is now obsolete. Instead, please use PivotItem.IsDetailHidden property instead. This property will be removed 12 months later since November 2024. Aspose apologizes for any inconvenience you may have experienced.

Returns: boolean

isMissing()

public boolean isMissing()

Indicates whether the item is removed from the data source.

Remarks

True means this value has benn removed from the data source.

Returns: boolean

move(int count, boolean isSameParent)

public void move(int count, boolean isSameParent)

Moves the item up or down

Parameters:

Parameter	Type	Description
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

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setDetailHidden(boolean value)

public void setDetailHidden(boolean value)

Sets whether the detail of this pivot item is hidden.

Parameters:

Parameter	Type	Description
value	boolean

setFormula(boolean value)

public void setFormula(boolean value)

Indicates whether this pivot item is a calculated formula item.

Remarks

NOTE: This property is now obsolete. Instead, please use PivotItem.IsCalculatedItem property instead. This property will be removed 12 months later since November 2024. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	boolean

setHidden(boolean value)

public void setHidden(boolean value)

Sets whether the pivot item is hidden.

Parameters:

Parameter	Type	Description
value	boolean

setHideDetail(boolean value)

public void setHideDetail(boolean value)

Sets whether the pivot item hides detail.

Remarks

NOTE: This property is now obsolete. Instead, please use PivotItem.IsDetailHidden property instead. This property will be removed 12 months later since November 2024. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	boolean

setIndex(int value)

public void setIndex(int value)

Gets the index of the pivot item in cache field.

Parameters:

Parameter	Type	Description
value	int

setName(String value)

public void setName(String value)

Gets the name of the pivot item.

Parameters:

Parameter	Type	Description
value	java.lang.String

setPosition(int value)

public void setPosition(int value)

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

Parameters:

Parameter	Type	Description
value	int

setPositionInSameParentNode(int value)

public void setPositionInSameParentNode(int value)

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

Parameters:

Parameter	Type	Description
value	int

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

Parameter	Type	Description
arg0	long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

Parameter	Type	Description
arg0	long
arg1	int