English:

The Free and Open Productivity Suite
Help us Help the World

Developer's Guide

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

Logo ApacheCon Europe 2014

Apache Feather

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.