<html> <head> <title>Enum ValidationType</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="ValidationType-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Values" class="navisub">Values</a></td> <td class="navisub"><a href="#ValueDetails" class="navisub">Values' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">enum ValidationType</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>used to specify which cell contents are treated as valid. </dd> </dl> </td> </tr> </table> <hr> <a name="Values"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Values</td> </tr> <tr> <td class="imsum_left"><a href="#ANY">ANY</a></td> <td class="imsum_right">any cell content is valid; no conditions are used. </td> </tr> <tr> <td class="imsum_left"><a href="#WHOLE">WHOLE</a></td> <td class="imsum_right">any whole number matching the specified condition is valid. </td> </tr> <tr> <td class="imsum_left"><a href="#DECIMAL">DECIMAL</a></td> <td class="imsum_right">any number matching the specified condition is valid. </td> </tr> <tr> <td class="imsum_left"><a href="#DATE">DATE</a></td> <td class="imsum_right">any date value matching the specified condition is valid. </td> </tr> <tr> <td class="imsum_left"><a href="#TIME">TIME</a></td> <td class="imsum_right">any time value matching the specified condition is valid. </td> </tr> <tr> <td class="imsum_left"><a href="#TEXT_LEN">TEXT_LEN</a></td> <td class="imsum_right">string is valid if its length matches the specified condition. </td> </tr> <tr> <td class="imsum_left"><a href="#LIST">LIST</a></td> <td class="imsum_right">Only strings from a specified list are valid. </td> </tr> <tr> <td class="imsum_left"><a href="#CUSTOM">CUSTOM</a></td> <td class="imsum_right">The specified formula detemines which contents are valid. </td> </tr> </table> <a name="ValueDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Values' Details</td> </tr> <tr> <td class="imdetail"><a name="ANY" class="membertitle">ANY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>ANY</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>any cell content is valid; no conditions are used. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="WHOLE" class="membertitle">WHOLE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>WHOLE</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>any whole number matching the specified condition is valid. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DECIMAL" class="membertitle">DECIMAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>DECIMAL</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>any number matching the specified condition is valid. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DATE" class="membertitle">DATE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>DATE</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>any date value matching the specified condition is valid. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TIME" class="membertitle">TIME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>TIME</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>any time value matching the specified condition is valid. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TEXT_LEN" class="membertitle">TEXT_LEN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>TEXT_LEN</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>string is valid if its length matches the specified condition. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LIST" class="membertitle">LIST</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>LIST</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>Only strings from a specified list are valid. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CUSTOM" class="membertitle">CUSTOM</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>CUSTOM</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>The specified formula detemines which contents are valid. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, 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.</p> </div> <!-- id="adc-idlref" --> </body> </html>