:: com :: sun :: star :: sheet ::
|
enum FilterOperator |
- Description
- specifies the type of a single condition in a filter descriptor.
|
Values |
EMPTY |
selects empty entries.
|
NOT_EMPTY |
selects non-empty entries.
|
EQUAL |
value has to be equal to the specified value.
|
NOT_EQUAL |
value must not be equal to the specified value.
|
GREATER |
value has to be greater than the specified value.
|
GREATER_EQUAL |
value has to be greater than or equal to the specified value.
|
LESS |
value has to be less than the specified value.
|
LESS_EQUAL |
value has to be less than or equal to the specified value.
|
TOP_VALUES |
selects a specified number of entries with the greatest values.
|
TOP_PERCENT |
selects a specified percentage of entries with the greatest values.
|
BOTTOM_VALUES |
selects a specified number of entries with the lowest values.
|
BOTTOM_PERCENT |
selects a specified percentage of entries with the lowest values.
|
Values' Details |
EMPTY
EMPTY,
- Description
- selects empty entries.
|
|
NOT_EMPTY
NOT_EMPTY,
- Description
- selects non-empty entries.
|
|
EQUAL
EQUAL,
- Description
- value has to be equal to the specified value.
|
|
NOT_EQUAL
NOT_EQUAL,
- Description
- value must not be equal to the specified value.
|
|
GREATER
GREATER,
- Description
- value has to be greater than the specified value.
|
|
GREATER_EQUAL
GREATER_EQUAL,
- Description
- value has to be greater than or equal to the specified value.
|
|
LESS
LESS,
- Description
- value has to be less than the specified value.
|
|
LESS_EQUAL
LESS_EQUAL,
- Description
- value has to be less than or equal to the specified value.
|
|
TOP_VALUES
TOP_VALUES,
- Description
- selects a specified number of entries with the greatest values.
|
|
TOP_PERCENT
TOP_PERCENT,
- Description
- selects a specified percentage of entries with the greatest values.
|
|
BOTTOM_VALUES
BOTTOM_VALUES,
- Description
- selects a specified number of entries with the lowest values.
|
|
BOTTOM_PERCENT
BOTTOM_PERCENT,
- Description
- selects a specified percentage of entries with the lowest values.
|
|
Top of Page
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.