<html> <head> <title>Interface XCellRangeFormula</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="XCellRangeFormula-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">sheet</a> :: </p> </td> </tr> <tr> <td class="title">interface XCellRangeFormula</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>allows to get and set cell contents (values, text or formulas) for a cell range. </dd> <dd><p>The outer sequence represents the rows and the inner sequence the columns of the array.</p> </dd> <dt><b>Since </b></dt> <dd>OOo 1.1.2 </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="#getFormulaArray">getFormulaArray</a></td> <td class="imsum_right">gets an array from the contents of the cell range. </td> </tr> <tr> <td class="imsum_left"><a href="#setFormulaArray">setFormulaArray</a></td> <td class="imsum_right">fills the cell range with values from an array. </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="getFormulaArray" class="membertitle">getFormulaArray</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">sequence< sequence< string > ></td> </tr> <tr> <td valign="top"><b>getFormulaArray</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>gets an array from the contents of the cell range. </dd> <dd><p>Each element of the result contains the same string that would be returned by ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XCell.html">XCell</a>::<a href="../table/XCell.html#getFormula">getFormula()</a> for the corresponding cell.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="setFormulaArray" class="membertitle">setFormulaArray</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>setFormulaArray</b>(</td> <td valign="top">[in] sequence< sequence< string > ></td> <td valign="bottom"> aArray );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>fills the cell range with values from an array. </dd> <dd><p>The size of the array must be the same as the size of the cell range. Each element of the array is interpreted the same way as the argument to a ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XCell.html">XCell</a>::<a href="../table/XCell.html#setFormula">setFormula()</a> call for the corresponding cell.</p> </dd> <dt><b>Throws</b></dt> <dd>::com::sun::star::<a href="../uno/module-ix.html">uno</a>::<a href="../uno/RuntimeException.html">RuntimeException</a> If the size of the array is different from the current size. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
