<html> <head> <title>Interface XSheetCellRangeContainer</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="XSheetCellRangeContainer-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 XSheetCellRangeContainer</td> </tr> <tr> <td><dl> <dt><b>Base Interfaces</b></dt> <dd><pre style="font-family:monospace;"><strong>XSheetCellRangeContainer</strong> ┗ <a href="XSheetCellRanges.html">XSheetCellRanges</a> ┗ ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XIndexAccess.html">XIndexAccess</a> ┗ ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XElementAccess.html">XElementAccess</a> </pre></dd> <dd><a name/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="crosstitle"> <tr> <td class="imsum_left"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> <td class="imsum_right"><dl> <dt>(referenced interface's summary:)</dt> <dd>provides methods to access cell ranges in a collection via index and other helper methods. </dd> </dl> </td> </tr> </table> </dd> </dl> </td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to access cell ranges in a collection via index and to add and remove cell ranges. </dd> <dt><b>See also</b></dt> <dd><a href="SheetCellRanges.html">SheetCellRanges</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="#addRangeAddress">addRangeAddress</a></td> <td class="imsum_right">adds the given range to the collection of cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="#removeRangeAddress">removeRangeAddress</a></td> <td class="imsum_right">removes the given range from the collection of cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="#addRangeAddresses">addRangeAddresses</a></td> <td class="imsum_right">adds the given ranges to the collection of cell ranges. </td> </tr> <tr> <td class="imsum_left"><a href="#removeRangeAddresses">removeRangeAddresses</a></td> <td class="imsum_right">removes the given ranges from the collection of cell ranges. </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="addRangeAddress" class="membertitle">addRangeAddress</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>addRangeAddress</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a></td> <td valign="bottom"> aCellRangeAddress,</td> </tr> <tr> <td/><td valign="top">[in] boolean</td> <td valign="bottom"> bMergeRanges );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>adds the given range to the collection of cell ranges. </dd> <dt><b>Parameter aCellRangeAddress</b></dt> <dd>contains the address of the new range. </dd> <dt><b>Parameter bMergeRanges</b></dt> <dd>defines how the range should be added. To merge the ranges takes more time, but the memory usage is lower. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="removeRangeAddress" class="membertitle">removeRangeAddress</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>removeRangeAddress</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a></td> <td valign="bottom"> aCellRangeAddress )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/NoSuchElementException.html">NoSuchElementException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes the given range from the collection of cell ranges. </dd> <dt><b>Parameter aCellRangeAddress</b></dt> <dd>contains the address of the range to be removed. <p>The specified range must fit exactly to an element of the collection. The method does not try to shorten a range.</p> </dd> <dt><b>Throws</b></dt> <dd>::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/NoSuchElementException.html">NoSuchElementException</a> if the collection does not contain the specified range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="addRangeAddresses" class="membertitle">addRangeAddresses</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>addRangeAddresses</b>(</td> <td valign="top">[in] sequence< ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a> ></td> <td valign="bottom"> aCellRangeAddresses,</td> </tr> <tr> <td/><td valign="top">[in] boolean</td> <td valign="bottom"> bMergeRanges );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>adds the given ranges to the collection of cell ranges. </dd> <dt><b>Parameter aCellRangeAddresses</b></dt> <dd>contains a sequence of addresses of all new ranges. </dd> <dt><b>Parameter bMergeRanges</b></dt> <dd>defines how the ranges should be added. To merge the ranges takes more time, but the memory usage is lower. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="removeRangeAddresses" class="membertitle">removeRangeAddresses</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>removeRangeAddresses</b>(</td> <td valign="top">[in] sequence< ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a> ></td> <td valign="bottom"> aCellRangeAddresses )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/NoSuchElementException.html">NoSuchElementException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes the given ranges from the collection of cell ranges. </dd> <dt><b>Parameter aCellRangeAddresses</b></dt> <dd>contains a sequence of addresses of all ranges to be removed. <p>All specified ranges must fit exactly to elements of the collection. The method does not try to shorten ranges.</p> </dd> <dt><b>Throws</b></dt> <dd>::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/NoSuchElementException.html">NoSuchElementException</a> if the collection does not contain any of the specified ranges. </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>