Constructor Summary |
---|
PivotArea(table)
Presents the selected area of the PivotTable. |
Property Getters/Setters Summary | ||
---|---|---|
function | getAxisType() | |
function | setAxisType(value) | |
Gets and sets the region of the PivotTable to which this rule applies. The value of the property is PivotFieldType integer constant. | ||
function | getFilters() | |
Gets all filters for this PivotArea.
|
||
function | isColumnGrandIncluded() | |
function | setColumnGrandIncluded(value) | |
Indicates whether the column grand total is included. | ||
function | isOutline() | |
function | setOutline(value) | |
Indicates whether the rule refers to an area that is in outline mode. | ||
function | isRowGrandIncluded() | |
function | setRowGrandIncluded(value) | |
Indicates whether the row grand total is included. | ||
function | getOnlyData() | |
function | setOnlyData(value) | |
Indicates whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels. | ||
function | getOnlyLabel() | |
function | setOnlyLabel(value) | |
Indicates whether only the data labels for an item selection are selected. | ||
function | getRuleType() | |
function | setRuleType(value) | |
Gets and sets the type of selection rule. The value of the property is PivotAreaType integer constant. |
Method Summary | ||
---|---|---|
function | select(axisType, fieldPosition, selectionType) | |
Select the area with filters.
|
function PivotArea(table)
table: PivotTable
- function getFilters()
function getOnlyData() / function setOnlyData(value)
function getOnlyLabel() / function setOnlyLabel(value)
function isRowGrandIncluded() / function setRowGrandIncluded(value)
function isColumnGrandIncluded() / function setColumnGrandIncluded(value)
function getAxisType() / function setAxisType(value)
function getRuleType() / function setRuleType(value)
function isOutline() / function setOutline(value)
function select(axisType, fieldPosition, selectionType)
axisType: Number
- A fieldPosition: Number
- Position of the field within the axis to which this rule applies.selectionType: Number
- A