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