Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

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 Software Foundation

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

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