Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

constants group FilterOperator2
Description
specifies the type of a single condition in a filter descriptor.

This constants group extends the FilterOperator enum by additional filter operators.

Since
OOo 3.2

Constants
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.  
CONTAINS selects contains entries.  
DOES_NOT_CONTAIN selects does-not-contain entries.  
BEGINS_WITH selects begins-with entries.  
DOES_NOT_BEGIN_WITH selects does-not-begin-with entries.  
ENDS_WITH selects ends-with entries.  
DOES_NOT_END_WITH selects does-not-end-with entries.  
Constants' Details
EMPTY
const long EMPTY = 0;
Description
selects empty entries.
NOT_EMPTY
const long NOT_EMPTY = 1;
Description
selects non-empty entries.
EQUAL
const long EQUAL = 2;
Description
value has to be equal to the specified value.
NOT_EQUAL
const long NOT_EQUAL = 3;
Description
value must not be equal to the specified value.
GREATER
const long GREATER = 4;
Description
value has to be greater than the specified value.
GREATER_EQUAL
const long GREATER_EQUAL = 5;
Description
value has to be greater than or equal to the specified value.
LESS
const long LESS = 6;
Description
value has to be less than the specified value.
LESS_EQUAL
const long LESS_EQUAL = 7;
Description
value has to be less than or equal to the specified value.
TOP_VALUES
const long TOP_VALUES = 8;
Description
selects a specified number of entries with the greatest values.
TOP_PERCENT
const long TOP_PERCENT = 9;
Description
selects a specified percentage of entries with the greatest values.
BOTTOM_VALUES
const long BOTTOM_VALUES = 10;
Description
selects a specified number of entries with the lowest values.
BOTTOM_PERCENT
const long BOTTOM_PERCENT = 11;
Description
selects a specified percentage of entries with the lowest values.
CONTAINS
const long CONTAINS = 12;
Description
selects contains entries.
DOES_NOT_CONTAIN
const long DOES_NOT_CONTAIN = 13;
Description
selects does-not-contain entries.
BEGINS_WITH
const long BEGINS_WITH = 14;
Description
selects begins-with entries.
DOES_NOT_BEGIN_WITH
const long DOES_NOT_BEGIN_WITH = 15;
Description
selects does-not-begin-with entries.
ENDS_WITH
const long ENDS_WITH = 16;
Description
selects ends-with entries.
DOES_NOT_END_WITH
const long DOES_NOT_END_WITH = 17;
Description
selects does-not-end-with entries.
Top of Page

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.