com.aspose.cells

Classes

Interfaces

Constants

com.aspose.cells

Class PivotField

java.lang.Object
- com.aspose.cells.PivotField

public class PivotField extends java.lang.Object

Represents a field in a PivotTable report.

Property Getters/Setters Summary
`int`	`getAutoShowCount()`
`void`	`setAutoShowCount(intvalue)`
	Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
`int`	`getAutoShowField()`
`void`	`setAutoShowField(intvalue)`
	Represents auto show field index. -1 means PivotField itself. It should be the index of the data fields.
`int`	`getAutoSortField()`
`void`	`setAutoSortField(intvalue)`
	Represents auto sort field index. -1 means PivotField itself,others means the position of the data fields.
`int`	`getBaseFieldIndex()`
`void`	`setBaseFieldIndex(intvalue)`
	Represents the base field for a custom calculation.
`int`	`getBaseIndex()`
`void`	`setBaseIndex(intvalue)`
	Represents the PivotField index in the base PivotFields.
`int`	`getBaseItemIndex()`
`void`	`setBaseItemIndex(intvalue)`
	Represents the item in the base field for a custom calculation. Valid only for data fields.
`int`	`getBaseItemPosition()`
`void`	`setBaseItemPosition(intvalue)`
	Represents the item in the base field for a custom calculation. Valid only for data fields. Because PivotItemPosition.InnerCustom is only for read,if you need to set PivotItemPosition.InnerCustom, please set PivotField.BaseItemIndex attribute. The value of the property is PivotItemPosition integer constant.
`short`	`getCurrentPageItem()`
`void`	`setCurrentPageItem(shortvalue)`
	Represents the current page item showing for the page field (valid only for page fields).
`int`	`getDataDisplayFormat()`
`void`	`setDataDisplayFormat(intvalue)`
	Represents how to display the values contained in a data field. The value of the property is PivotFieldDataDisplayFormat integer constant.
`java.lang.String`	`getDisplayName()`
`void`	`setDisplayName(java.lang.Stringvalue)`
	Represents the PivotField display name.
`boolean`	`getDragToColumn()`
`void`	`setDragToColumn(booleanvalue)`
	Indicates whether the specified field can be dragged to the column position. The default value is true.
`boolean`	`getDragToData()`
`void`	`setDragToData(booleanvalue)`
	Indicates whether the specified field can be dragged to the data position. The default value is true.
`boolean`	`getDragToHide()`
`void`	`setDragToHide(booleanvalue)`
	Indicates whether the specified field can be dragged to the hide position. The default value is true.
`boolean`	`getDragToPage()`
`void`	`setDragToPage(booleanvalue)`
	Indicates whether the specified field can be dragged to the page position. The default value is true.
`boolean`	`getDragToRow()`
`void`	`setDragToRow(booleanvalue)`
	Indicates whether the specified field can be dragged to the row position. The default value is true.
`int`	`getFunction()`
`void`	`setFunction(intvalue)`
	Represents the function used to summarize the PivotTable data field. The value of the property is ConsolidationFunction integer constant.
`boolean`	`getInsertBlankRow()`
`void`	`setInsertBlankRow(booleanvalue)`
	Indicates whether inserting blank line after each item.
`boolean`	`isAscendShow()`
`void`	`setAscendShow(booleanvalue)`
	Indicates whether the specified PivotTable field is autoshown ascending.
`boolean`	`isAscendSort()`
`void`	`setAscendSort(booleanvalue)`
	Indicates whether the specified PivotTable field is autosorted ascending.
`boolean`	`isAutoShow()`
`void`	`setAutoShow(booleanvalue)`
	Indicates whether the specified PivotTable field is automatically shown,only valid for excel 2003.
`boolean`	`isAutoSort()`
`void`	`setAutoSort(booleanvalue)`
	Indicates whether the specified PivotTable field is automatically sorted.
`boolean`	`isAutoSubtotals()`
`void`	`setAutoSubtotals(booleanvalue)`
	Indicates whether the specified field shows automatic subtotals. Default is true.
`boolean`	`isCalculatedField()`
	Indicates whether the specified PivotTable field is calculated field.
`boolean`	`isIncludeNewItemsInFilter()`
`void`	`setIncludeNewItemsInFilter(booleanvalue)`
	indicates whether the field can include new items in manual filter The default value is false.
`boolean`	`isInsertPageBreaksBetweenItems()`
`void`	`setInsertPageBreaksBetweenItems(booleanvalue)`
	indicates whether the field can insert page breaks between items insert page break after each item The default value is false.
`boolean`	`isMultipleItemSelectionAllowed()`
`void`	`setMultipleItemSelectionAllowed(booleanvalue)`
	indicates whether the field can have multiple items selected in the page field The default value is false.
`boolean`	`isRepeatItemLabels()`
`void`	`setRepeatItemLabels(booleanvalue)`
	indicates whether the field can repeat items labels The default value is false.
`int`	`getItemCount()`
	Gets the base item count of this pivot field.
`java.lang.String[]`	`getItems()`
	Get all base items;
`java.lang.String`	`getName()`
	Represents the PivotField name.
`int`	`getNumber()`
`void`	`setNumber(intvalue)`
	Represents the built-in display format of numbers and dates.
`java.lang.String`	`getNumberFormat()`
`void`	`setNumberFormat(java.lang.Stringvalue)`
	Represents the custom display format of numbers and dates.
`java.lang.String[]`	`getOriginalItems()`
	Get the original base items;
`PivotItemCollection`	`getPivotItems()`
	Gets the pivot items of the pivot field
`int`	`getPosition()`
	Represents the PivotField index in the PivotFields.
`SxRng`	`getRange()`
	Gets the group range of the pivot field
`boolean`	`getShowAllItems()`
`void`	`setShowAllItems(booleanvalue)`
	Indicates whether all items in the PivotTable report are displayed, even if they don't contain summary data. show items with no data The default value is false.
`boolean`	`getShowCompact()`
`void`	`setShowCompact(booleanvalue)`

`boolean`	`getShowInOutlineForm()`
`void`	`setShowInOutlineForm(booleanvalue)`
	Indicates whether layout this field in outline form on the Pivot Table view
`boolean`	`getShowSubtotalAtTop()`
`void`	`setShowSubtotalAtTop(booleanvalue)`
	when ShowInOutlineForm is true, then display subtotals at the top of the list of items instead of at the bottom

Method Summary
`void`	`addCalculatedItem(java.lang.String name, java.lang.String formula)`
`void`	Add a calculated item to the pivot field.
`java.lang.String`	`getCalculatedFieldFormula()`
`java.lang.String`	Get the formula string of the specified calculated field .
`PivotFilter`	`getPivotFilterByType(int type)`
`PivotFilter`	Gets the pivot filter of the pivot field by type
`java.util.ArrayList`	`getPivotFilters()`
`java.util.ArrayList`	Gets the pivot filters of the pivot field
`boolean`	`getSubtotals(int subtotalType)`
`boolean`	Gets whether the specified field shows that subtotals.
`void`	`hideDetail(boolean isHiddenDetail)`
`void`	Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field.
`void`	`hideItem(int index, boolean isHidden)`
`void`	Sets whether the specific PivotItem in a data field is hidden.
`void`	`hideItem(java.lang.String itemValue, boolean isHidden)`
`void`	Sets whether the specific PivotItem in a data field is hidden.
`void`	`hideItemDetail(int index, boolean isHiddenDetail)`
`void`	Sets whether the specific PivotItem in a pivot field is hidden detail.
`void`	`initPivotItems()`
`void`	Init the pivot items of the pivot field
`boolean`	`isHiddenItem(int index)`
`boolean`	Indicates whether the specific PivotItem is hidden.
`boolean`	`isHiddenItemDetail(int index)`
`boolean`	Indicates whether the specific PivotItem is hidden detail.
`void`	`setSubtotals(int subtotalType, boolean shown)`
`void`	Sets whether the specified field shows that subtotals.

- Property Getters/Setters Detail
  - getPivotItems
```
public PivotItemCollection getPivotItems()
```
    Gets the pivot items of the pivot field
  - getRange
```
public SxRng getRange()
```
    Gets the group range of the pivot field
  - isCalculatedField
```
public boolean isCalculatedField()
```
    Indicates whether the specified PivotTable field is calculated field.
  - getBaseIndex/setBaseIndex
```
public int getBaseIndex() / public void setBaseIndex(int value)
```
    Represents the PivotField index in the base PivotFields.
  - getPosition
```
public int getPosition()
```
    Represents the PivotField index in the PivotFields.
  - getName
```
public java.lang.String getName()
```
    Represents the PivotField name.
  - getDisplayName/setDisplayName
```
public java.lang.String getDisplayName() / public void setDisplayName(java.lang.String value)
```
    Represents the PivotField display name.
  - isAutoSubtotals/setAutoSubtotals
```
public boolean isAutoSubtotals() / public void setAutoSubtotals(boolean value)
```
    Indicates whether the specified field shows automatic subtotals. Default is true.
  - getDragToColumn/setDragToColumn
```
public boolean getDragToColumn() / public void setDragToColumn(boolean value)
```
    Indicates whether the specified field can be dragged to the column position. The default value is true.
  - getDragToHide/setDragToHide
```
public boolean getDragToHide() / public void setDragToHide(boolean value)
```
    Indicates whether the specified field can be dragged to the hide position. The default value is true.
  - getDragToRow/setDragToRow
```
public boolean getDragToRow() / public void setDragToRow(boolean value)
```
    Indicates whether the specified field can be dragged to the row position. The default value is true.
  - getDragToPage/setDragToPage
```
public boolean getDragToPage() / public void setDragToPage(boolean value)
```
    Indicates whether the specified field can be dragged to the page position. The default value is true.
  - getDragToData/setDragToData
```
public boolean getDragToData() / public void setDragToData(boolean value)
```
    Indicates whether the specified field can be dragged to the data position. The default value is true.
  - isMultipleItemSelectionAllowed/setMultipleItemSelectionAllowed
```
public boolean isMultipleItemSelectionAllowed() / public void setMultipleItemSelectionAllowed(boolean value)
```
    indicates whether the field can have multiple items selected in the page field The default value is false.
  - isRepeatItemLabels/setRepeatItemLabels
```
public boolean isRepeatItemLabels() / public void setRepeatItemLabels(boolean value)
```
    indicates whether the field can repeat items labels The default value is false.
  - isIncludeNewItemsInFilter/setIncludeNewItemsInFilter
```
public boolean isIncludeNewItemsInFilter() / public void setIncludeNewItemsInFilter(boolean value)
```
    indicates whether the field can include new items in manual filter The default value is false.
  - isInsertPageBreaksBetweenItems/setInsertPageBreaksBetweenItems
```
public boolean isInsertPageBreaksBetweenItems() / public void setInsertPageBreaksBetweenItems(boolean value)
```
    indicates whether the field can insert page breaks between items insert page break after each item The default value is false.
  - getShowAllItems/setShowAllItems
```
public boolean getShowAllItems() / public void setShowAllItems(boolean value)
```
    Indicates whether all items in the PivotTable report are displayed, even if they don't contain summary data. show items with no data The default value is false.
  - isAutoSort/setAutoSort
```
public boolean isAutoSort() / public void setAutoSort(boolean value)
```
    Indicates whether the specified PivotTable field is automatically sorted.
  - isAscendSort/setAscendSort
```
public boolean isAscendSort() / public void setAscendSort(boolean value)
```
    Indicates whether the specified PivotTable field is autosorted ascending.
  - getAutoSortField/setAutoSortField
```
public int getAutoSortField() / public void setAutoSortField(int value)
```
    Represents auto sort field index. -1 means PivotField itself,others means the position of the data fields.
  - isAutoShow/setAutoShow
```
public boolean isAutoShow() / public void setAutoShow(boolean value)
```
    Indicates whether the specified PivotTable field is automatically shown,only valid for excel 2003.
  - isAscendShow/setAscendShow
```
public boolean isAscendShow() / public void setAscendShow(boolean value)
```
    Indicates whether the specified PivotTable field is autoshown ascending.
  - getAutoShowCount/setAutoShowCount
```
public int getAutoShowCount() / public void setAutoShowCount(int value)
```
    Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
  - getAutoShowField/setAutoShowField
```
public int getAutoShowField() / public void setAutoShowField(int value)
```
    Represents auto show field index. -1 means PivotField itself. It should be the index of the data fields.
  - getFunction/setFunction
```
public int getFunction() / public void setFunction(int value)
```
    Represents the function used to summarize the PivotTable data field. The value of the property is ConsolidationFunction integer constant.
  - getDataDisplayFormat/setDataDisplayFormat
```
public int getDataDisplayFormat() / public void setDataDisplayFormat(int value)
```
    Represents how to display the values contained in a data field. The value of the property is PivotFieldDataDisplayFormat integer constant.
    PivotFieldDataDisplayFormat
  - getBaseFieldIndex/setBaseFieldIndex
```
public int getBaseFieldIndex() / public void setBaseFieldIndex(int value)
```
    Represents the base field for a custom calculation.
  - getBaseItemPosition/setBaseItemPosition
```
public int getBaseItemPosition() / public void setBaseItemPosition(int value)
```
    Represents the item in the base field for a custom calculation. Valid only for data fields. Because PivotItemPosition.InnerCustom is only for read,if you need to set PivotItemPosition.InnerCustom, please set PivotField.BaseItemIndex attribute. The value of the property is PivotItemPosition integer constant.
    PivotItemPosition
  - getBaseItemIndex/setBaseItemIndex
```
public int getBaseItemIndex() / public void setBaseItemIndex(int value)
```
    Represents the item in the base field for a custom calculation. Valid only for data fields.
  - getCurrentPageItem/setCurrentPageItem
```
public short getCurrentPageItem() / public void setCurrentPageItem(short value)
```
    Represents the current page item showing for the page field (valid only for page fields).
  - getNumber/setNumber
```
public int getNumber() / public void setNumber(int value)
```
    Represents the built-in display format of numbers and dates.
  - getInsertBlankRow/setInsertBlankRow
```
public boolean getInsertBlankRow() / public void setInsertBlankRow(boolean value)
```
    Indicates whether inserting blank line after each item.
  - getShowSubtotalAtTop/setShowSubtotalAtTop
```
public boolean getShowSubtotalAtTop() / public void setShowSubtotalAtTop(boolean value)
```
    when ShowInOutlineForm is true, then display subtotals at the top of the list of items instead of at the bottom
  - getShowInOutlineForm/setShowInOutlineForm
```
public boolean getShowInOutlineForm() / public void setShowInOutlineForm(boolean value)
```
    Indicates whether layout this field in outline form on the Pivot Table view
  - getNumberFormat/setNumberFormat
```
public java.lang.String getNumberFormat() / public void setNumberFormat(java.lang.String value)
```
    Represents the custom display format of numbers and dates.
  - getItems
```
public java.lang.String[] getItems()
```
    Get all base items;
  - getOriginalItems
```
public java.lang.String[] getOriginalItems()
```
    Get the original base items;
  - getItemCount
```
public int getItemCount()
```
    Gets the base item count of this pivot field.
  - getShowCompact/setShowCompact
```
public boolean getShowCompact() / public void setShowCompact(boolean value)
```
setBaseIndex
public voidsetBaseIndex(intvalue)
Represents the PivotField index in the base PivotFields.
setDisplayName
public voidsetDisplayName(java.lang.Stringvalue)
Represents the PivotField display name.
setAutoSubtotals
public voidsetAutoSubtotals(booleanvalue)
Indicates whether the specified field shows automatic subtotals. Default is true.
setDragToColumn
public voidsetDragToColumn(booleanvalue)
Indicates whether the specified field can be dragged to the column position. The default value is true.
setDragToHide
public voidsetDragToHide(booleanvalue)
Indicates whether the specified field can be dragged to the hide position. The default value is true.
setDragToRow
public voidsetDragToRow(booleanvalue)
Indicates whether the specified field can be dragged to the row position. The default value is true.
setDragToPage
public voidsetDragToPage(booleanvalue)
Indicates whether the specified field can be dragged to the page position. The default value is true.
setDragToData
public voidsetDragToData(booleanvalue)
Indicates whether the specified field can be dragged to the data position. The default value is true.
setMultipleItemSelectionAllowed
public voidsetMultipleItemSelectionAllowed(booleanvalue)
indicates whether the field can have multiple items selected in the page field The default value is false.
setRepeatItemLabels
public voidsetRepeatItemLabels(booleanvalue)
indicates whether the field can repeat items labels The default value is false.
setIncludeNewItemsInFilter
public voidsetIncludeNewItemsInFilter(booleanvalue)
indicates whether the field can include new items in manual filter The default value is false.
setInsertPageBreaksBetweenItems
public voidsetInsertPageBreaksBetweenItems(booleanvalue)
indicates whether the field can insert page breaks between items insert page break after each item The default value is false.
setShowAllItems
public voidsetShowAllItems(booleanvalue)
Indicates whether all items in the PivotTable report are displayed, even if they don't contain summary data. show items with no data The default value is false.
setAutoSort
public voidsetAutoSort(booleanvalue)
Indicates whether the specified PivotTable field is automatically sorted.
setAscendSort
public voidsetAscendSort(booleanvalue)
Indicates whether the specified PivotTable field is autosorted ascending.
setAutoSortField
public voidsetAutoSortField(intvalue)
Represents auto sort field index. -1 means PivotField itself,others means the position of the data fields.
setAutoShow
public voidsetAutoShow(booleanvalue)
Indicates whether the specified PivotTable field is automatically shown,only valid for excel 2003.
setAscendShow
public voidsetAscendShow(booleanvalue)
Indicates whether the specified PivotTable field is autoshown ascending.
setAutoShowCount
public voidsetAutoShowCount(intvalue)
Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
setAutoShowField
public voidsetAutoShowField(intvalue)
Represents auto show field index. -1 means PivotField itself. It should be the index of the data fields.
setFunction
public voidsetFunction(intvalue)
Represents the function used to summarize the PivotTable data field. The value of the property is ConsolidationFunction integer constant.
setDataDisplayFormat
public voidsetDataDisplayFormat(intvalue)
Represents how to display the values contained in a data field. The value of the property is PivotFieldDataDisplayFormat integer constant.
PivotFieldDataDisplayFormat
setBaseFieldIndex
public voidsetBaseFieldIndex(intvalue)
Represents the base field for a custom calculation.
setBaseItemPosition
public voidsetBaseItemPosition(intvalue)
Represents the item in the base field for a custom calculation. Valid only for data fields. Because PivotItemPosition.InnerCustom is only for read,if you need to set PivotItemPosition.InnerCustom, please set PivotField.BaseItemIndex attribute. The value of the property is PivotItemPosition integer constant.
PivotItemPosition
setBaseItemIndex
public voidsetBaseItemIndex(intvalue)
Represents the item in the base field for a custom calculation. Valid only for data fields.
setCurrentPageItem
public voidsetCurrentPageItem(shortvalue)
Represents the current page item showing for the page field (valid only for page fields).
setNumber
public voidsetNumber(intvalue)
Represents the built-in display format of numbers and dates.
setInsertBlankRow
public voidsetInsertBlankRow(booleanvalue)
Indicates whether inserting blank line after each item.
setShowSubtotalAtTop
public voidsetShowSubtotalAtTop(booleanvalue)
when ShowInOutlineForm is true, then display subtotals at the top of the list of items instead of at the bottom
setShowInOutlineForm
public voidsetShowInOutlineForm(booleanvalue)
Indicates whether layout this field in outline form on the Pivot Table view
setNumberFormat
public voidsetNumberFormat(java.lang.Stringvalue)
Represents the custom display format of numbers and dates.
setShowCompact
public voidsetShowCompact(booleanvalue)
- Method Detail
  - getPivotFilterByType
```
public PivotFilter getPivotFilterByType(int type)
```
    Gets the pivot filter of the pivot field by type
    Parameters:
    type - A PivotFilterType value.
  - getPivotFilters
```
public java.util.ArrayList getPivotFilters()
```
    Gets the pivot filters of the pivot field
  - initPivotItems
```
public void initPivotItems()
```
    Init the pivot items of the pivot field
  - getCalculatedFieldFormula
```
public java.lang.String getCalculatedFieldFormula()
```
    Get the formula string of the specified calculated field .
  - setSubtotals
```
public void setSubtotals(int subtotalType, boolean shown)
```
    Sets whether the specified field shows that subtotals.
    PivotFieldSubtotalType
    Parameters:
    subtotalType - A PivotFieldSubtotalType value. subtotals type.
    shown - whether the specified field shows that subtotals.
  - getSubtotals
```
public boolean getSubtotals(int subtotalType)
```
    Gets whether the specified field shows that subtotals.
    Parameters:
    subtotalType - A PivotFieldSubtotalType value. subtotals type.
    Returns:
    whether the specified field shows that subtotals.
  - isHiddenItem
```
public boolean isHiddenItem(int index)
```
    Indicates whether the specific PivotItem is hidden.
    Parameters:
    index - the index of the pivotItem in the pivotField.
    Returns:
    whether the specific PivotItem is hidden
  - hideItem
```
public void hideItem(int index, boolean isHidden)
```
    Sets whether the specific PivotItem in a data field is hidden.
    Parameters:
    index - the index of the pivotItem in the pivotField.
    isHidden - whether the specific PivotItem is hidden
  - isHiddenItemDetail
```
public boolean isHiddenItemDetail(int index)
```
    Indicates whether the specific PivotItem is hidden detail.
    Parameters:
    index - the index of the pivotItem in the pivotField.
    Returns:
    whether the specific PivotItem is hidden detail
  - hideItemDetail
```
public void hideItemDetail(int index, boolean isHiddenDetail)
```
    Sets whether the specific PivotItem in a pivot field is hidden detail.
    Parameters:
    index - the index of the pivotItem in the pivotField.
    isHiddenDetail - whether the specific PivotItem is hidden
  - hideDetail
```
public void hideDetail(boolean isHiddenDetail)
```
    Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field.
    Parameters:
    isHiddenDetail - whether the PivotItems is hidden
  - hideItem
```
public void hideItem(java.lang.String itemValue, boolean isHidden)
```
    Sets whether the specific PivotItem in a data field is hidden.
    Parameters:
    itemValue - the value of the pivotItem in the pivotField.
    isHidden - whether the specific PivotItem is hidden
  - addCalculatedItem
```
public void addCalculatedItem(java.lang.String name, java.lang.String formula)
```
    Add a calculated item to the pivot field.
    Only supports to add calculated item to Row/Column field.
    Parameters:
    name - The item's name.
    formula - The item's formula

setDisplayName
public voidsetDisplayName(java.lang.Stringvalue)

setMultipleItemSelectionAllowed
public voidsetMultipleItemSelectionAllowed(booleanvalue)

setRepeatItemLabels
public voidsetRepeatItemLabels(booleanvalue)

setIncludeNewItemsInFilter
public voidsetIncludeNewItemsInFilter(booleanvalue)

setInsertPageBreaksBetweenItems
public voidsetInsertPageBreaksBetweenItems(booleanvalue)

setDataDisplayFormat
public voidsetDataDisplayFormat(intvalue)

setShowSubtotalAtTop
public voidsetShowSubtotalAtTop(booleanvalue)

setShowInOutlineForm
public voidsetShowInOutlineForm(booleanvalue)

setNumberFormat
public voidsetNumberFormat(java.lang.Stringvalue)

setBaseIndex
public voidsetBaseIndex(intvalue)

setAutoSubtotals
public voidsetAutoSubtotals(booleanvalue)

setDragToColumn
public voidsetDragToColumn(booleanvalue)

setDragToHide
public voidsetDragToHide(booleanvalue)

com.aspose.cells

Classes

Interfaces

Constants

Class PivotField

Property Getters/Setters Detail

getPivotItems

getRange

isCalculatedField

getBaseIndex/setBaseIndex

getPosition

getName

getDisplayName/setDisplayName

isAutoSubtotals/setAutoSubtotals

getDragToColumn/setDragToColumn

getDragToHide/setDragToHide

getDragToRow/setDragToRow

getDragToPage/setDragToPage

getDragToData/setDragToData

isMultipleItemSelectionAllowed/setMultipleItemSelectionAllowed

isRepeatItemLabels/setRepeatItemLabels

isIncludeNewItemsInFilter/setIncludeNewItemsInFilter

isInsertPageBreaksBetweenItems/setInsertPageBreaksBetweenItems

getShowAllItems/setShowAllItems

isAutoSort/setAutoSort

isAscendSort/setAscendSort

getAutoSortField/setAutoSortField

isAutoShow/setAutoShow

isAscendShow/setAscendShow

getAutoShowCount/setAutoShowCount

getAutoShowField/setAutoShowField

getFunction/setFunction

getDataDisplayFormat/setDataDisplayFormat

getBaseFieldIndex/setBaseFieldIndex

getBaseItemPosition/setBaseItemPosition

getBaseItemIndex/setBaseItemIndex

getCurrentPageItem/setCurrentPageItem

getNumber/setNumber

getInsertBlankRow/setInsertBlankRow

getShowSubtotalAtTop/setShowSubtotalAtTop

getShowInOutlineForm/setShowInOutlineForm

getNumberFormat/setNumberFormat

getItems

getOriginalItems

getItemCount

getShowCompact/setShowCompact

setBaseIndex

setDisplayName

setAutoSubtotals

setDragToColumn

setDragToHide

setDragToRow

setDragToPage

setDragToData

setMultipleItemSelectionAllowed

setRepeatItemLabels

setIncludeNewItemsInFilter

setInsertPageBreaksBetweenItems

setShowAllItems

setAutoSort

setAscendSort

setAutoSortField

setAutoShow

setAscendShow

setAutoShowCount

setAutoShowField

setFunction

setDataDisplayFormat

setBaseFieldIndex

setBaseItemPosition

setBaseItemIndex

setCurrentPageItem

setNumber

setInsertBlankRow

setShowSubtotalAtTop

setShowInOutlineForm

setNumberFormat

setShowCompact

Method Detail

getPivotFilterByType