<html> <head> <title>Interface XCell</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="XCell-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="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Details</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">table</a> :: </p> </td> </tr> <tr> <td class="title">interface XCell</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to access the contents of a cell in a table. </dd> <dt><b>See also</b></dt> <dd><a href="Cell.html">Cell</a></dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#getFormula">getFormula</a></td> <td class="imsum_right">returns the formula string of a cell. </td> </tr> <tr> <td class="imsum_left"><a href="#setFormula">setFormula</a></td> <td class="imsum_right">sets a formula into the cell. </td> </tr> <tr> <td class="imsum_left"><a href="#getValue">getValue</a></td> <td class="imsum_right">returns the floating point value of the cell. </td> </tr> <tr> <td class="imsum_left"><a href="#setValue">setValue</a></td> <td class="imsum_right">sets a floating point value into the cell. </td> </tr> <tr> <td class="imsum_left"><a href="#getType">getType</a></td> <td class="imsum_right">returns the type of the cell. </td> </tr> <tr> <td class="imsum_left"><a href="#getError">getError</a></td> <td class="imsum_right">returns the error value of the cell. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="getFormula" class="membertitle">getFormula</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">string</td> </tr> <tr> <td valign="top"><b>getFormula</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the formula string of a cell. </dd> <dd><p>Even if the cell does not contain a formula, an assignment of this attribute's value to another cell's formula attribute would create the same cell content. This is because this attribute contains the original text value of a string cell. The value of a <em>value cell</em> will be formatted using the number format's default format or the formula string, including "=", of a formula cell.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="setFormula" class="membertitle">setFormula</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>setFormula</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> aFormula );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>sets a formula into the cell. </dd> <dd><p>When assigned, the string will be interpreted and a value, text or formula cell is created, depending on the text and the number format.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getValue" class="membertitle">getValue</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">double</td> </tr> <tr> <td valign="top"><b>getValue</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the floating point value of the cell. </dd> <dd><p>For a <em>value cell</em> the value is returnd, for a <em>string cell</em> zero is returned and for a <em>formula cell</em> the result value of a formula is returned.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="setValue" class="membertitle">setValue</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>setValue</b>(</td> <td valign="top">[in] double</td> <td valign="bottom"> nValue );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>sets a floating point value into the cell. </dd> <dd><p>After a call to this method the type of the cell is <a href="CellContentType.html">CellContentType</a>::<a href="CellContentType.html#VALUE">VALUE</a>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getType" class="membertitle">getType</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="CellContentType.html">CellContentType</a></td> </tr> <tr> <td valign="top"><b>getType</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the type of the cell. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getError" class="membertitle">getError</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">long</td> </tr> <tr> <td valign="top"><b>getError</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the error value of the cell. </dd> <dd><P>If the cell does not contain a formula, the error is always zero.</p> </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>