Package | Description |
---|---|
com.gembox.spreadsheet |
Contains classes and enums that constitute GemBox.Spreadsheet object model.
|
com.gembox.spreadsheet.pivottables |
Contains types that constitute model of Pivot Tables.
|
com.gembox.spreadsheet.tables |
Contains types that constitute model of Tables.
|
Modifier and Type | Method and Description |
---|---|
AutoFilter |
AutoFilter.byColor(int columnIndex,
ExcelFillPattern fillPattern)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.byColor(int columnIndex,
SpreadsheetColor fontColor)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.byCustom(int columnIndex,
FilterOperator operator,
Object value)
Sets a
CustomFilter to a column with the specified index (relative to the Range ). |
AutoFilter |
AutoFilter.byCustom(int columnIndex,
FilterOperator operator,
Object value,
boolean and,
FilterOperator operator2,
Object value2)
Sets a
CustomFilter to a column with the specified index (relative to the Range ). |
AutoFilter |
AutoFilter.byDynamic(int columnIndex,
DynamicFilterType dynamicFilterType)
Sets a
DynamicFilter to a column with the specified index (relative to the Range ). |
AutoFilter |
AutoFilter.byIcon(int columnIndex,
SpreadsheetIcon icon)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.byPredicate(int columnIndex,
Predicate<ExcelCell> match)
Sets a custom filter method to a column with the specified index (relative to the
Range ). |
AutoFilter |
AutoFilter.byTop10(int columnIndex,
boolean top,
boolean percent,
double value)
Sets a
Top10Filter to a column with the specified index (relative to the Range ). |
AutoFilter |
AutoFilter.byValues(int columnIndex,
Iterable values)
Sets a
ValuesFilter to a column with the specified index (relative to the Range ). |
AutoFilter |
AutoFilter.byValues(int columnIndex,
Object... values)
Sets a
ValuesFilter to a column with the specified index (relative to the Range ). |
static AutoFilter |
AutoFilter.create(CellRange range)
Deprecated.
This method is internal and should not be used.
|
static AutoFilter |
AutoFilter.create(ExcelWorksheet destination,
AutoFilter source)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
CellRange.filter()
Gets the
AutoFilter active on the parent worksheet (ExcelWorksheet.getFilter() ) if active range is equal to this CellRange ; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet. |
AutoFilter |
CellRange.filter(boolean active)
Gets the
AutoFilter active on the parent worksheet (ExcelWorksheet.getFilter() ) if active range is equal to this CellRange and parameter active is true ; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet if parameter active is true . |
AutoFilter |
FilterColumnCollection.getFilter()
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
ExcelWorksheet.getFilter()
Gets the active
AutoFilter . |
AutoFilter |
AutoFilter.sortBy(int columnIndex)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
boolean descending)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
boolean descending,
Iterable<String> customList)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
boolean descending,
String... customList)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
Comparator<ExcelCell> comparison)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
ExcelFillPattern fillPattern)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
ExcelFillPattern fillPattern,
boolean descending)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
Iterable<String> customList)
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
SpreadsheetColor fontColor)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
SpreadsheetColor fontColor,
boolean descending)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
SpreadsheetIcon icon)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
SpreadsheetIcon icon,
boolean descending)
Deprecated.
This method is internal and should not be used.
|
AutoFilter |
AutoFilter.sortBy(int columnIndex,
String... customList)
|
Modifier and Type | Method and Description |
---|---|
static AutoFilter |
AutoFilter.create(ExcelWorksheet destination,
AutoFilter source)
Deprecated.
This method is internal and should not be used.
|
void |
ExcelWorksheet.setFilter(AutoFilter value)
Gets the active
AutoFilter . |
Modifier and Type | Method and Description |
---|---|
AutoFilter |
PivotFilter.getAutoFilter()
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
void |
PivotFilter.setAutoFilter(AutoFilter autoFilter)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
AutoFilter |
Table.getFilter()
Gets the table filter.
|
Modifier and Type | Method and Description |
---|---|
void |
Table.updateFilter(AutoFilter value)
Deprecated.
This method is internal and should not be used.
|
© GemBox d.o.o. — All rights reserved.