Content for OpenOffice.org version 3.3.
:: com :: sun :: star :: sheet ::
|
| enum ValidationType |
- Description
- used to specify which cell contents are treated as valid.
|
| Values |
| ANY |
any cell content is valid; no conditions are used.
|
| WHOLE |
any whole number matching the specified condition is valid.
|
| DECIMAL |
any number matching the specified condition is valid.
|
| DATE |
any date value matching the specified condition is valid.
|
| TIME |
any time value matching the specified condition is valid.
|
| TEXT_LEN |
string is valid if its length matches the specified condition.
|
| LIST |
Only strings from a specified list are valid.
|
| CUSTOM |
The specified formula detemines which contents are valid.
|
| Values' Details |
ANY
ANY,
- Description
- any cell content is valid; no conditions are used.
|
|
WHOLE
WHOLE,
- Description
- any whole number matching the specified condition is valid.
|
|
DECIMAL
DECIMAL,
- Description
- any number matching the specified condition is valid.
|
|
DATE
DATE,
- Description
- any date value matching the specified condition is valid.
|
|
TIME
TIME,
- Description
- any time value matching the specified condition is valid.
|
|
TEXT_LEN
TEXT_LEN,
- Description
- string is valid if its length matches the specified condition.
|
|
LIST
LIST,
- Description
- Only strings from a specified list are valid.
|
|
CUSTOM
CUSTOM,
- Description
- The specified formula detemines which contents are valid.
|
|
Top of Page
Copyright © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.