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