<html> <head> <title>Interface XCellRangesAccess</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="XCellRangesAccess-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"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Summary</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 XCellRangesAccess</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the cells or to sub-ranges of all sheets. </dd> <dt><b>See also</b></dt> <dd><a href="Spreadsheets.html">Spreadsheets</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="#getCellByPosition">getCellByPosition</a></td> <td class="imsum_right">Returns a single cell within the range. </td> </tr> <tr> <td class="imsum_left"><a href="#getCellRangeByPosition">getCellRangeByPosition</a></td> <td class="imsum_right">Returns a sub-range of cells within the range. </td> </tr> <tr> <td class="imsum_left"><a href="#getCellRangesByName">getCellRangesByName</a></td> <td class="imsum_right">Returns a sub-range of cells within the range. </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="getCellByPosition" class="membertitle">getCellByPosition</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">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XCell.html">XCell</a></td> </tr> <tr> <td valign="top"><b>getCellByPosition</b>(</td> <td valign="top">[in] long</td> <td valign="bottom"> nColumn,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nRow,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nSheet )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/IndexOutOfBoundsException.html">IndexOutOfBoundsException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>Returns a single cell within the range. </dd> <dt><b>Parameter nColumn</b></dt> <dd>is the column index of the cell inside the sheet. </dd> <dt><b>Parameter nRow</b></dt> <dd>is the row index of the cell inside the sheet. </dd> <dt><b>Parameter nSheet</b></dt> <dd>is the sheet index of the sheet inside the document. </dd> <dt><b>Returns</b></dt> <dd>the specified cell. </dd> <dt><b>Throws</b></dt> <dd>::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/IndexOutOfBoundsException.html">IndexOutOfBoundsException</a> if an index is outside the dimensions of this range. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/Cell.html">Cell</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getCellRangeByPosition" class="membertitle">getCellRangeByPosition</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">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XCellRange.html">XCellRange</a></td> </tr> <tr> <td valign="top"><b>getCellRangeByPosition</b>(</td> <td valign="top">[in] long</td> <td valign="bottom"> nLeft,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nTop,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nRight,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nBottom,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nSheet )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/IndexOutOfBoundsException.html">IndexOutOfBoundsException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>Returns a sub-range of cells within the range. </dd> <dt><b>Parameter nLeft</b></dt> <dd>is the column index of the first cell inside the range. </dd> <dt><b>Parameter nTop</b></dt> <dd>is the row index of the first cell inside the range. </dd> <dt><b>Parameter nRight</b></dt> <dd>is the column index of the last cell inside the range. </dd> <dt><b>Parameter nBottom</b></dt> <dd>is the row index of the last cell inside the range. </dd> <dt><b>Parameter nSheet</b></dt> <dd>is the sheet index of the sheet inside the document. </dd> <dt><b>Returns</b></dt> <dd>the specified cell range. </dd> <dt><b>Throws</b></dt> <dd>::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/IndexOutOfBoundsException.html">IndexOutOfBoundsException</a> if an index is outside the dimensions of this range. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRange.html">CellRange</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getCellRangesByName" class="membertitle">getCellRangesByName</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< ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XCellRange.html">XCellRange</a> ></td> </tr> <tr> <td valign="top"><b>getCellRangesByName</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> aRange )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../lang/module-ix.html">lang</a>::<a href="../lang/IllegalArgumentException.html">IllegalArgumentException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>Returns a sub-range of cells within the range. </dd> <dd><p>The sub-range is specified by its name. The format of the range name is dependent of the context of the table. In spreadsheets valid names may be "Sheet1.A1:C5" or "$Sheet1.$B$2" or even defined names for cell ranges such as "MySpecialCell".</p> </dd> <dt><b>Parameter aRange</b></dt> <dd>the name of the sub-range. </dd> <dt><b>Returns</b></dt> <dd>the specified cell ranges. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRange.html">CellRange</a></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>
distrib
>
Mandriva
>
2008.1
>
x86_64
>
media
>
main-testing
>
by-pkgid
>
2c50825dd66d0497b96a67f7fab2ee84
>
files
>
5824
