<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">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 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 © 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>
