[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IPivotCell

Interface IPivotCell

Namespace
GrapeCity.Documents.Excel
Assembly
GcDocs.Excel.dll

Represents a cell in a PivotTable report.

public interface IPivotCell

Properties

ColumnItems

Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.

IPivotItemList ColumnItems { get; }

Property Value

IPivotItemList

CustomSubtotalFunction

Returns the custom subtotal function field setting of a PivotCell object.

ConsolidationFunction CustomSubtotalFunction { get; }

Property Value

ConsolidationFunction

DataField

Returns a PivotField object that corresponds to the selected data field.

IPivotField DataField { get; }

Property Value

IPivotField

PivotCellType

Returns a constant that identifies the PivotTable entity the cell corresponds to.

PivotCellType PivotCellType { get; }

Property Value

PivotCellType

PivotColumnLine

Returns the PivotLine on a column for a specific PivotCell object.

IPivotLine PivotColumnLine { get; }

Property Value

IPivotLine

PivotField

Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.

IPivotField PivotField { get; }

Property Value

IPivotField

PivotItem

Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.

IPivotItem PivotItem { get; }

Property Value

IPivotItem

PivotRowLine

Returns the PivotLine on a row for a specific PivotCell object.

IPivotLine PivotRowLine { get; }

Property Value

IPivotLine

PivotTable

Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report.

IPivotTable PivotTable { get; }

Property Value

IPivotTable

Range

Returns a Range object that represents the range the specified PivotCell applies to.

IRange Range { get; }

Property Value

IRange

RowItems

Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.

IPivotItemList RowItems { get; }

Property Value

IPivotItemList