PivotItem
PivotItem class
Represents a item in a PivotField report.
Properties
| Name | Type | Description |
|---|---|---|
| IsHidden | boolean | Gets and Sets whether the pivot item is hidden. |
| Position | int | Specifying the position index in all the PivotItems,not the PivotItems under the same parent node. |
| PositionInSameParentNode | int | Specifying the position index in the PivotItems under the same parent node. |
| IsHideDetail | boolean | Gets and Sets whether the pivot item hides detail. |
| IsDetailHidden | boolean | |
| IsCalculatedItem | boolean | |
| IsFormula | boolean | Indicates whether this pivot item is a calculated formula item. |
| IsMissing | boolean | Indicates whether the item is removed from the data source. True means this value has benn removed from the data source. |
| Value | Object | Gets the value of the pivot item |
| Name | String | Gets the name of the pivot item. |
| Index | int | Gets the index of the pivot item in cache field. |
Methods
| Name | Description |
|---|---|
| hide | Sets whether the pivot item is hidden. |
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Pivot.PivotF | | move | Moves the item up or down | | getFormula | | | getStringValue | Gets the string value of the pivot item If the value is null, it will return "" | | getDoubleValue | Gets the double value of the pivot item If the value is null or not number ,it will return 0 | | getDateTimeValue | Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue |
PivotItem.IsHidden property
Gets and Sets whether the pivot item is hidden.
Type: boolean
PivotItem.Position property
Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
Type: int
PivotItem.PositionInSameParentNode property
Specifying the position index in the PivotItems under the same parent node.
Type: int
PivotItem.IsHideDetail property
Gets and Sets whether the pivot item hides detail.
Type: boolean
PivotItem.IsDetailHidden property
Type: boolean
PivotItem.IsCalculatedItem property
Type: boolean
PivotItem.IsFormula property
Indicates whether this pivot item is a calculated formula item.
Type: boolean
PivotItem.IsMissing property
Indicates whether the item is removed from the data source. True means this value has benn removed from the data source.
Type: boolean
PivotItem.Value property
Gets the value of the pivot item
Type: Object
PivotItem.Name property
Gets the name of the pivot item.
Type: String
PivotItem.Index property
Gets the index of the pivot item in cache field.
Type: int
hide(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(count, isSameParent)
Moves the item up or down
| 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 |
getFormula()
getStringValue()
Gets the string value of the pivot item If the value is null, it will return ""
getDoubleValue()
Gets the double value of the pivot item If the value is null or not number ,it will return 0
getDateTimeValue()
Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue