<html> <head> <title>Interface XNamedRanges</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="XNamedRanges-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Named_Ranges" class="navimain">Devguide</a></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 XNamedRanges</td> </tr> <tr> <td><dl> <dt><b>Base Interfaces</b></dt> <dd><pre style="font-family:monospace;"><strong>XNamedRanges</strong> ┗ ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</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">::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a></td> <td class="imsum_right"><dl> <dt>(referenced interface's summary:)</dt> <dd>is used to access named objects within a container. </dd> </dl> </td> </tr> </table> </dd> </dl> </td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the members in a collection of named ranges and to insert and remove them. </dd> <dt><b>See also</b></dt> <dd><a href="NamedRanges.html">NamedRanges</a>, <a href="NamedRange.html">NamedRange</a></dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Named_Ranges">Spreadsheets - Named Ranges</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="#addNewByName">addNewByName</a></td> <td class="imsum_right">adds a new named range to the collection. </td> </tr> <tr> <td class="imsum_left"><a href="#addNewFromTitles">addNewFromTitles</a></td> <td class="imsum_right">creates named cell ranges from titles in a cell range. </td> </tr> <tr> <td class="imsum_left"><a href="#removeByName">removeByName</a></td> <td class="imsum_right">removes a named range from the collection. </td> </tr> <tr> <td class="imsum_left"><a href="#outputList">outputList</a></td> <td class="imsum_right">writes a list of all named ranges into the document. </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="addNewByName" class="membertitle">addNewByName</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>addNewByName</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> aName,</td> </tr> <tr> <td/><td valign="top">[in] string</td> <td valign="bottom"> aContent,</td> </tr> <tr> <td/><td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aPosition,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nType );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>adds a new named range to the collection. </dd> <dt><b>Parameter aName</b></dt> <dd>the new name of the named range. </dd> <dt><b>Parameter aContent</b></dt> <dd>the formula expression. <p>A cell range address is one possible content of a named range.</p> </dd> <dt><b>Parameter aPosition</b></dt> <dd>specifies the base address for relative cell references. </dd> <dt><b>Parameter nType</b></dt> <dd>a combination of flags that specify the type of a named range, as defined in <a href="NamedRangeFlag.html">NamedRangeFlag</a>. <p>This parameter will be zero for any common named range.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="addNewFromTitles" class="membertitle">addNewFromTitles</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>addNewFromTitles</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"> aSource,</td> </tr> <tr> <td/><td valign="top">[in] <a href="Border.html">Border</a></td> <td valign="bottom"> aBorder );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>creates named cell ranges from titles in a cell range. </dd> <dd><p>The names for the named ranges are taken from title cells in the top or bottom row, or from the cells of the left or right column of the range (depending on the parameter <b>aBorder</b>. The named ranges refer to single columns or rows in the inner part of the original range, excluding the labels.</p> <p>Example: The source range is A1:B3. The named ranges shall be created using row titles. This requires <a href="Border.html">Border</a>::<a href="Border.html#TOP">TOP</a> for the second parameter. The method creates two named ranges. The name of the first is equal to the content of cell A1 and contains the range $Sheet.$A$2:$A$3 (excluding the title cell). The latter named range is named using cell B1 and contains the cell range address $Sheet.$B$2:$B$3.</p> </dd> <dt><b>Parameter aSource</b></dt> <dd>the cell range used to create the named ranges. </dd> <dt><b>Parameter aBorder</b></dt> <dd>specifies the location of the title cells. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="removeByName" class="membertitle">removeByName</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>removeByName</b>(</td> <td valign="top">[in] string</td> <td valign="bottom"> aName );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>removes a named range from the collection. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="outputList" class="membertitle">outputList</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>outputList</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aOutputPosition );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>writes a list of all named ranges into the document. </dd> <dd><p>The first column of the list contains the names. The second column contains the contents of the named ranges.</p> </dd> <dt><b>Parameter aOutputPosition</b></dt> <dd>specifies the top left cell of the output range. </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>