GrapeCity.Documents.Excel.IPivotItem

Interface IPivotItem

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField.

public interface IPivotItem

Properties

Formula

Gets or sets the formula of calculated item.

string Formula { get; set; }

Property Value

string

Name

Gets or sets the name of the object (read or write).

string Name { get; set; }

Property Value

string

Position

Position of the item in its field if the item is currently showing. Read/write Integer.

int Position { get; set; }

Property Value

int

ShowDetail

True if the outline is expanded for the specified range (so that the detail of the column or row is visible). Read/write Object.

bool ShowDetail { get; set; }

Property Value

bool

SourceName

Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report (read-only).

string SourceName { get; }

Property Value

string

Visible

Determines whether the object is visible (read or write).

bool Visible { get; set; }

Property Value

bool