<html> <head> <title>Constants' Group FunctionCategory</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="navimainnone">Use</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="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' 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">constants group FunctionCategory</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>used to specify the category of a spreadsheet function. </dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#DATABASE">DATABASE</a></td> <td class="imsum_right">specifies a database function. </td> </tr> <tr> <td class="imsum_left"><a href="#DATETIME">DATETIME</a></td> <td class="imsum_right">specifies a function that calculates with dates and/or times. </td> </tr> <tr> <td class="imsum_left"><a href="#FINANCIAL">FINANCIAL</a></td> <td class="imsum_right">specifies a financial function. </td> </tr> <tr> <td class="imsum_left"><a href="#INFORMATION">INFORMATION</a></td> <td class="imsum_right">specifies a function that returns information about the cell, the cell contents or the current formula. </td> </tr> <tr> <td class="imsum_left"><a href="#LOGICAL">LOGICAL</a></td> <td class="imsum_right">specifies a boolean function. </td> </tr> <tr> <td class="imsum_left"><a href="#MATHEMATICAL">MATHEMATICAL</a></td> <td class="imsum_right">specifies a common mathematical function </td> </tr> <tr> <td class="imsum_left"><a href="#MATRIX">MATRIX</a></td> <td class="imsum_right">specifies a matrix function. </td> </tr> <tr> <td class="imsum_left"><a href="#STATISTICAL">STATISTICAL</a></td> <td class="imsum_right">specifies a statistical function </td> </tr> <tr> <td class="imsum_left"><a href="#SPREADSHEET">SPREADSHEET</a></td> <td class="imsum_right">specifies a function that returns information using the spreadsheet contents or specific cell positions. </td> </tr> <tr> <td class="imsum_left"><a href="#TEXT">TEXT</a></td> <td class="imsum_right">specifies a text function. </td> </tr> <tr> <td class="imsum_left"><a href="#ADDIN">ADDIN</a></td> <td class="imsum_right">specifies a common add-in function. </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="DATABASE" class="membertitle">DATABASE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DATABASE</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a database function. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DATETIME" class="membertitle">DATETIME</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DATETIME</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a function that calculates with dates and/or times. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="FINANCIAL" class="membertitle">FINANCIAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>FINANCIAL</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a financial function. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="INFORMATION" class="membertitle">INFORMATION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>INFORMATION</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a function that returns information about the cell, the cell contents or the current formula. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LOGICAL" class="membertitle">LOGICAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>LOGICAL</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a boolean function. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MATHEMATICAL" class="membertitle">MATHEMATICAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MATHEMATICAL</b> = 6;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a common mathematical function </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MATRIX" class="membertitle">MATRIX</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MATRIX</b> = 7;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a matrix function. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="STATISTICAL" class="membertitle">STATISTICAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>STATISTICAL</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a statistical function </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SPREADSHEET" class="membertitle">SPREADSHEET</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SPREADSHEET</b> = 9;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a function that returns information using the spreadsheet contents or specific cell positions. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TEXT" class="membertitle">TEXT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>TEXT</b> = 10;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a text function. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ADDIN" class="membertitle">ADDIN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>ADDIN</b> = 11;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies a common add-in function. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <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>