Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

Apache Software Foundation

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.