Package | Description |
---|---|
com.gembox.spreadsheet.pivottables |
Contains types that constitute model of Pivot Tables.
|
Modifier and Type | Method and Description |
---|---|
PivotField |
PivotAreaFieldCollection.add(int fieldIndex)
Adds the
PivotField to this area collection. |
PivotField |
PivotAreaFieldCollection.add(PivotField pivotField)
Adds the
PivotField to this area collection. |
PivotField |
PivotAreaFieldCollection.add(String fieldName)
Adds the
PivotField to this area collection. |
PivotField |
PivotFieldCollection.addCalculated(String fieldName,
String formula)
Adds a calculated
PivotField to the end of the collection of PivotTable fields. |
static PivotField |
PivotField.create(PivotTable pivotTable,
com.gembox.spreadsheet.internal.pivottables.PivotCacheField cacheField)
Deprecated.
This method is internal and should not be used.
|
static PivotField |
PivotField.create(PivotTable pivotTable,
com.gembox.spreadsheet.internal.pivottables.PivotCacheField cacheField,
com.gembox.spreadsheet.internal.pivottables.PivotFieldType fieldType)
Deprecated.
This method is internal and should not be used.
|
static PivotField |
PivotField.create(PivotTable pivotTable,
PivotField source)
Deprecated.
This method is internal and should not be used.
|
PivotField |
PivotFieldBaseCollection.get(int index)
Gets the
PivotField at the specified index. |
PivotField |
PivotFieldBaseCollection.get(String fieldName)
Gets the
PivotField with the specified name. |
PivotField |
PivotField.getBaseField()
Gets the base field used for a custom calculation.
|
PivotField |
PivotTableSortOptions.getDataField()
Gets a data field that is used to sort the pivot field.
|
PivotField |
PivotTable.getDataPivotField()
Gets a
PivotField object that represents all the data fields in this PivotTable . |
PivotField |
PivotFilter.getField()
Gets the pivot field that this pivot filter applies to.
|
PivotField |
PivotFilter.getMeasureField()
Gets the pivot field containing summary values being filtered.
|
PivotField |
PivotItemCollection.getPivotField()
Deprecated.
This method is internal and should not be used.
|
PivotField |
PivotItem.getPivotField()
Gets the parent
PivotField . |
PivotField |
PivotTable.moveField(PivotField pivotField,
com.gembox.spreadsheet.internal.pivottables.PivotAreaType toAreaType)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
Iterator<PivotField> |
PivotFieldBaseCollection.iterator()
Returns an iterator for the collection.
|
Modifier and Type | Method and Description |
---|---|
PivotField |
PivotAreaFieldCollection.add(PivotField pivotField)
Adds the
PivotField to this area collection. |
void |
PivotFieldBaseCollection.addInternal(int index,
PivotField item)
Deprecated.
This method is internal and should not be used.
|
void |
PivotFieldBaseCollection.addInternal(PivotField item)
Deprecated.
This method is internal and should not be used.
|
PivotTableFilter |
PivotTableFilter.byCustom(PivotField field,
FilterOperator operator,
Object value)
Sets a
CustomFilter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byCustom(PivotField field,
FilterOperator operator,
Object value,
boolean and,
FilterOperator operator2,
Object value2)
Sets a
CustomFilter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byCustom(PivotField field,
PivotField measureField,
FilterOperator operator,
Object value)
Sets a
CustomFilter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byCustom(PivotField field,
PivotField measureField,
FilterOperator operator,
Object value,
boolean and,
FilterOperator operator2,
Object value2)
Sets a
CustomFilter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byDynamic(PivotField field,
DynamicFilterType dynamicFilterType)
Sets a
DynamicFilterType to a pivot field. |
PivotTableFilter |
PivotTableFilter.byDynamic(PivotField field,
PivotField measureField,
DynamicFilterType dynamicFilterType)
Sets a
DynamicFilterType to a pivot field. |
PivotTableFilter |
PivotTableFilter.byTop10(PivotField field,
boolean top,
boolean percent,
double value)
Sets a
Top10Filter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byTop10(PivotField field,
PivotField measureField,
boolean top,
boolean percent,
double value)
Sets a
Top10Filter to a pivot field. |
PivotTableFilter |
PivotTableFilter.byValues(PivotField field,
Iterable values)
Deprecated.
This method is internal and should not be used.
|
PivotTableFilter |
PivotTableFilter.byValues(PivotField field,
Object... values)
Deprecated.
This method is internal and should not be used.
|
PivotTableFilter |
PivotTableFilter.byValues(PivotField field,
PivotField measureField,
Iterable values)
Deprecated.
This method is internal and should not be used.
|
PivotTableFilter |
PivotTableFilter.byValues(PivotField field,
PivotField measureField,
Object... values)
Deprecated.
This method is internal and should not be used.
|
boolean |
PivotFieldBaseCollection.contains(PivotField item)
Determines whether the
PivotField is contained in the collection. |
boolean |
PivotTable.containsPivotField(PivotField pivotField)
Deprecated.
This method is internal and should not be used.
|
static PivotTableSortOptions |
PivotTableSortOptions.create(boolean descending,
PivotField dataField,
List<PivotItem> pivotItems)
Deprecated.
This method is internal and should not be used.
|
static PivotFilter |
PivotFilter.create(PivotField field)
Deprecated.
This method is internal and should not be used.
|
static PivotItem |
PivotItem.create(PivotField pivotField,
com.gembox.spreadsheet.internal.pivottables.PivotCacheItem cacheItem)
Deprecated.
This method is internal and should not be used.
|
static PivotItem |
PivotItem.create(PivotField pivotField,
PivotItem source)
Deprecated.
This method is internal and should not be used.
|
static PivotField |
PivotField.create(PivotTable pivotTable,
PivotField source)
Deprecated.
This method is internal and should not be used.
|
PivotFilter |
PivotFilterCollection.get(PivotField field)
Gets the
PivotFilter for the specified pivot field. |
int |
PivotFieldBaseCollection.indexOf(PivotField item)
Searches for the specified
PivotField and returns the zero-based index of the first occurrence within the entire collection. |
PivotField |
PivotTable.moveField(PivotField pivotField,
com.gembox.spreadsheet.internal.pivottables.PivotAreaType toAreaType)
Deprecated.
This method is internal and should not be used.
|
void |
PivotAreaFieldCollection.remove(PivotField pivotField)
Removes
PivotField from this area collection. |
void |
PivotTable.removeField(PivotField pivotField,
com.gembox.spreadsheet.internal.pivottables.PivotAreaType fromAreaType)
Deprecated.
This method is internal and should not be used.
|
void |
PivotFieldBaseCollection.removeInternal(PivotField item)
Deprecated.
This method is internal and should not be used.
|
void |
PivotField.setBaseField(PivotField field)
Sets the base field used for a custom calculation.
|
void |
PivotFilter.setMeasureField(PivotField field)
Sets the pivot field containing summary values being filtered.
|
void |
PivotField.sort(boolean descending,
PivotField sortByDataField,
PivotItem... sortByPivotItems)
Sorts this pivot field by the data field.
|
© GemBox d.o.o. — All rights reserved.