Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

Overview

Module

Use

Devguide

Index

Values

Values' Details

---

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

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.