English:

The Free and Open Productivity Suite
New: Apache OpenOffice 4.1.1 released!

Developer's Guide

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

Logo ApacheCon Europe 2014

Apache Feather

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

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation. 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.