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(self, count, is_same_parent) | Moves the item up or down | 
| get_formula(self) | Gets the formula of this calculated item. Only works when this item is calculated item. | 
| get_string_value(self) | Gets the string value of the pivot item If the value is null, it will return "" | 
| get_double_value(self) | Gets the double value of the pivot item If the value is null or not number ,it will return 0 | 
| get_date_time_value(self) | 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