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 ConditionOperator

Description is used to specify the type of XSheetCondition. Developers Guide Spreadsheets - Conditional Formats

---

Values
NONE	no condition is specified.
EQUAL	value has to be equal to the specified value.
NOT_EQUAL	the value must not be equal to the specified value.
GREATER	the value has to be greater than the specified value.
GREATER_EQUAL	the value has to be greater than or equal to the specified value.
LESS	the value has to be less than the specified value.
LESS_EQUAL	the value has to be less than or equal to the specified value.
BETWEEN	the value has to be between the two specified values.
NOT_BETWEEN	the value has to be outside of the two specified values.
FORMULA	the specified formula has to give a non-zero result.

Values' Details

NONE NONE, Description no condition is specified.

EQUAL EQUAL, Description value has to be equal to the specified value.

NOT_EQUAL NOT_EQUAL, Description the value must not be equal to the specified value.

GREATER GREATER, Description the value has to be greater than the specified value.

GREATER_EQUAL GREATER_EQUAL, Description the value has to be greater than or equal to the specified value.

LESS LESS, Description the value has to be less than the specified value.

LESS_EQUAL LESS_EQUAL, Description the value has to be less than or equal to the specified value.

BETWEEN BETWEEN, Description the value has to be between the two specified values.

NOT_BETWEEN NOT_BETWEEN, Description the value has to be outside of the two specified values.

FORMULA FORMULA, Description the specified formula has to give a non-zero result.

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.