Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XNamedRanges
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-::com::sun::star::container::XElementAccess
          |
          +-::com::sun::star::container::XNameAccess
             |
             +-XNamedRanges
Description provides access to the members in a collection of named ranges and to insert and remove them. See also NamedRanges See also NamedRange Developers Guide 8.3.3 Spreadsheet Documents - Working with Spreadsheet Documents - Navigating - Named Ranges

Methods' Summary
addNewByName | adds a new named range to the collection.
addNewFromTitles | creates named cell ranges from titles in a cell range.
removeByName | removes a named range from the collection.
outputList | writes a list of all named ranges into the document.

Methods' Details
addNewByName
void addNewByName( | [in] string [in] string [in] ::com::sun::star::table::CellAddress [in] long | aName, aContent, aPosition, nType );
Description adds a new named range to the collection. Parameter aName the new name of the named range. Parameter aContent the formula expression. A cell range address is one possible content of a named range. Parameter aPosition specifies the base address for relative cell references. Parameter nType a combination of flags that specify the type of a named range, as defined in NamedRangeFlag . This parameter will be zero for any common named range.
addNewFromTitles
void addNewFromTitles( | [in] ::com::sun::star::table::CellRangeAddress [in] Border | aSource, aBorder );
Description creates named cell ranges from titles in a cell range. 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 aBorder . The named ranges refer to single columns or rows in the inner part of the original range, excluding the labels. Example: The source range is A1:B3. The named ranges shall be created using row titles. This requires Border::TOP 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. Parameter aSource the cell range used to create the named ranges. Parameter aBorder specifies the location of the title cells.
removeByName
void removeByName( | [in] string | aName );
Description removes a named range from the collection.
outputList
void outputList( | [in] ::com::sun::star::table::CellAddress | aOutputPosition );
Description writes a list of all named ranges into the document. The first column of the list contains the names. The second column contains the contents of the named ranges. Parameter aOutputPosition specifies the top left cell of the output range.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.