Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

service NamedRange
Description
represents a named range in a spreadsheet document.

In fact a named range is a named formula expression. A cell range address is one possible content of a named range.

See also
NamedRanges

Exported Interfaces - Summary
XNamedRange

provides access to the settings of the named range.

XCellRangeReferrer

provides access to the cell range object referred by this named range. (details)

Properties' Summary
[ readonly ] long
TokenIndex
[ OPTIONAL ]
returns the index used to refer to this name in token arrays.  
boolean
IsSharedFormula
[ OPTIONAL ]
Determines if this defined name represents a shared formula.  
Exported Interfaces - Details
XNamedRange
Description
provides access to the settings of the named range.
XCellRangeReferrer
Description
provides access to the cell range object referred by this named range.

This works only, if the named range contains a single cell range address.

Properties' Details
TokenIndex
[ readonly ] long TokenIndex;
Usage Restrictions
optional
Description
returns the index used to refer to this name in token arrays.

A token describing a defined name shall contain the op-code obtained from the FormulaMapGroupSpecialOffset::NAME offset and this index as data part.

Since
OOo 3.0
See also
FormulaToken, FormulaMapGroupSpecialOffset::NAME
IsSharedFormula
boolean IsSharedFormula;
Usage Restrictions
optional
Description
Determines if this defined name represents a shared formula.

This special property shall not be used externally. It is used by import and export filters for compatibility with spreadsheet documents containing shared formulas. Shared formulas are shared by several cells to save memory and to decrease file size.

A defined name with this property set will not appear in the user interface of Calc, and its name will not appear in cell formulas. A formula referring to this defined name will show the formula definition contained in the name instead.

Since
OOo 3.0

 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.