PivotItem class
PivotItem class
Represents a item in a PivotField report.
The PivotItem type exposes the following members:
Properties
Property | Description |
---|---|
is_hidden | Gets and Sets whether the pivot item is hidden. |
position | Specifying the position index in all the PivotItems,not the PivotItems under the same parent node. |
position_in_same_parent_node | Specifying the position index in the PivotItems under the same parent node. |
is_hide_detail | Gets and sets whether the pivot item hides detail. |
is_detail_hidden | Gets and sets whether the detail of this pivot item is hidden. |
is_calculated_item | Indicates whether this pivot item is a calculated formula item. |
is_formula | Indicates whether this pivot item is a calculated formula item. |
is_missing | Indicates whether the item is removed from the data source. |
value | Gets the value of the pivot item |
name | Gets the name of the pivot item. |
index | Gets the index of the pivot item in cache field. |
Methods
Method | Description |
---|---|
move | Moves the item up or down |
get_formula | Gets the formula of this calculated item. Only works when this item is calculated item. |
get_string_value | Gets the string value of the pivot item If the value is null, it will return "" |
get_double_value | Gets the double value of the pivot item If the value is null or not number ,it will return 0 |
get_date_time_value | Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue |
See Also
- module
aspose.cells.pivot