GrapeCity.Spreadsheet.PivotTables.IPivotItem

IPivotItem Interface

Represents an item in a IPivotTable field.

public interface IPivotItem

Public Interface IPivotItem

Name	Description
Caption	Gets a string value that represents the label text for the IPivotItem.
Field	Gets the parent field of the current pivot item.
Formula	Gets or sets a value that represents the object's formula in A1-style notation.
Index	Gets an integer value that represents the index number of the pivot item within the IPivotItems collection.
IsCalculated	`True` if the PivotTable item is a calculated item, `False` for otherwise.
LabelRange	Gets an IRange object that represents all the cells in the PivotTable report that contain the item.
ShowDetail	Gets or sets a value indicating whether the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline.
SourceName	Gets a string value that represents the specified object's name as it appears in the original source data for the specified IPivotTable report.
Visible	Gets a Boolean value that determines whether the IPivotItem is visible.

Name	Description
Delete()	Deletes the object.
DrillTo(string)	This method supports drilling to a specified IPivotField from a IPivotItem.