Class PivotItem
Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)
Represents a item in a PivotField report.
public class PivotItemInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Properties
Index
Gets the index of the pivot item in cache field.
public int Index { get; set; }Property Value
IsCalculatedItem
Indicates whether this pivot item is a calculated formula item.
public bool IsCalculatedItem { get; }Property Value
IsDetailHidden
Gets and sets whether the detail of this pivot item is hidden.
public bool IsDetailHidden { get; set; }Property Value
IsHidden
Gets and Sets whether the pivot item is hidden.
public bool IsHidden { get; set; }Property Value
IsMissing
Indicates whether the item is removed from the data source.
public bool IsMissing { get; }Property Value
Remarks
True means this value has benn removed from the data source.
Name
Gets the name of the pivot item.
public string Name { get; set; }Property Value
Position
Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
public int Position { get; set; }Property Value
PositionInSameParentNode
Specifying the position index in the PivotItems under the same parent node.
public int PositionInSameParentNode { get; set; }Property Value
Value
Gets the value of the pivot item
public object Value { get; }Property Value
Methods
GetDateTimeValue()
Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue
public DateTime GetDateTimeValue()Returns
GetDoubleValue()
Gets the double value of the pivot item If the value is null or not number ,it will return 0
public double GetDoubleValue()Returns
GetFormula()
Gets the formula of this calculated item. Only works when this item is calculated item.
public string GetFormula()Returns
GetStringValue()
Gets the string value of the pivot item If the value is null, it will return ""
public string GetStringValue()Returns
Move(int, bool)
Moves the item up or down
public void Move(int count, bool isSameParent)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 bool
Specifying whether moving operation is in the same parent node or not