Language

The Free and Open Productivity Suite
Apache OpenOffice 4.1.8 released

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.