GrapeCity.Documents.Excel.PivotCellType

Enum PivotCellType

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the PivotTable entity the cell corresponds to.

public enum PivotCellType

Fields

BlankCell = 9

A structural blank cell in the PivotTable.

CustomSubtotal = 7

A cell in the row or column area that is a custom subtotal.

DataField = 4

A data field label (not the Data button).

DataPivotField = 8

The Data button.

GrandTotal = 3

A cell in a row or column area which is a grand total.

PageFieldItem = 6

The cell that shows the selected item of a Page field.

PivotField = 5

The button for a field (not the Data button).

PivotItem = 1

A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.

Subtotal = 2

A cell in the row or column area which is a subtotal.

Value = 0

Any cell in the data area (except a blank row).