<html> <head> <title>Service TableValidation</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="TableValidation-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Other_Table_Operations#Data_Validation" class="navimain">Devguide</a></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">Included Services</td> <td class="navisub"><a href="#ExportedInterfaces" class="navisub">Exported Interfaces</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' 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">service TableValidation</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>represents the data validation settings for a cell or cell range. </dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Other_Table_Operations#Data_Validation">Spreadsheets - Other Table Operations - Data Validation</a></dd> </dl> </td> </tr> </table> <hr> <a name="ExportedInterfaces"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces</td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>provides information about and access to the properties from an implementation. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCondition.html">XSheetCondition</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>provides methods to access the settings of a condition in a conditional format or data validation. </dd> </dl> </td> </tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left"><a href="ValidationType.html">ValidationType</a><br> <a href="#Type">Type</a></td> <td class="imsum_right">specifies the type of validation. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#ShowInputMessage">ShowInputMessage</a></td> <td class="imsum_right">specifies if an input message is shown when the cursor is in a cell with these validation settings. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#InputTitle">InputTitle</a></td> <td class="imsum_right">specifies the title of the window showing the input message. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#InputMessage">InputMessage</a></td> <td class="imsum_right">specifies the text of the input message. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#ShowErrorMessage">ShowErrorMessage</a></td> <td class="imsum_right">specifies if an error message is displayed when invalid data is entered. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#ErrorTitle">ErrorTitle</a></td> <td class="imsum_right">specifies the title of the window showing the error message. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#ErrorMessage">ErrorMessage</a></td> <td class="imsum_right">specifies the text of the error message. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IgnoreBlankCells">IgnoreBlankCells</a></td> <td class="imsum_right">specifies if blank cells should be allowed. </td> </tr> <tr> <td class="imsum_left"><a href="ValidationAlertStyle.html">ValidationAlertStyle</a><br> <a href="#ErrorAlertStyle">ErrorAlertStyle</a></td> <td class="imsum_right">specifies the style of the error message. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#ShowList">ShowList</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies if the list of possible values should be shown on the cell and how. See also <a href="TableValidationVisibility.html">TableValidationVisibility</a> </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="Type" class="membertitle">Type</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><a href="ValidationType.html">ValidationType</a> <b>Type</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the type of validation. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ShowInputMessage" class="membertitle">ShowInputMessage</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>ShowInputMessage</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies if an input message is shown when the cursor is in a cell with these validation settings. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="InputTitle" class="membertitle">InputTitle</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>InputTitle</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the title of the window showing the input message. </dd> <dd><p>This is only used if <a href="TableValidation.html">TableValidation</a>::<a href="TableValidation.html#ShowInputMessage">ShowInputMessage</a> is set to <b>true</b>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="InputMessage" class="membertitle">InputMessage</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>InputMessage</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the text of the input message. </dd> <dd><p>This is only used if <a href="TableValidation.html">TableValidation</a>::<a href="TableValidation.html#ShowInputMessage">ShowInputMessage</a> is set to <b>true</b>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ShowErrorMessage" class="membertitle">ShowErrorMessage</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>ShowErrorMessage</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies if an error message is displayed when invalid data is entered. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ErrorTitle" class="membertitle">ErrorTitle</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>ErrorTitle</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the title of the window showing the error message. </dd> <dd><p>This is only used if <a href="TableValidation.html">TableValidation</a>::<a href="TableValidation.html#ShowErrorMessage">ShowErrorMessage</a> is set to <b>true</b>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ErrorMessage" class="membertitle">ErrorMessage</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>ErrorMessage</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the text of the error message. </dd> <dd><p>This is only used if <a href="TableValidation.html">TableValidation</a>::<a href="TableValidation.html#ShowErrorMessage">ShowErrorMessage</a> is set to <b>true</b>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IgnoreBlankCells" class="membertitle">IgnoreBlankCells</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IgnoreBlankCells</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies if blank cells should be allowed. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ErrorAlertStyle" class="membertitle">ErrorAlertStyle</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><a href="ValidationAlertStyle.html">ValidationAlertStyle</a> <b>ErrorAlertStyle</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the style of the error message. </dd> <dd><p>This is used only if <a href="TableValidation.html">TableValidation</a>::<a href="TableValidation.html#ShowErrorMessage">ShowErrorMessage</a> is set to <b>true</b>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ShowList" class="membertitle">ShowList</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>ShowList</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies if the list of possible values should be shown on the cell and how. See also <a href="TableValidationVisibility.html">TableValidationVisibility</a> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>