[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

definedNames (Defined Names)

This element defines the collection of defined names for this workbook. Defined names are descriptive names to represent cells, ranges of cells, formulas, or constant values. Defined names can be used to represent a range on any worksheet.

[Example:

<definedNames>
<definedName name="NamedFormula"
comment="Comment text for defined name.">SUM(Sheet3!$B$2:$B$9)</definedName>
<definedName name="NamedRange">Sheet3!$A$1:$C$12</definedName>
<definedName name="NamedRangeFromExternalReference" localSheetId="2"
hidden="1">Sheet5!$A$1:$T$47</definedName>
</definedNames>

end example]

Parent Elements

workbook3.2.27)

 

Child Elements

Subclause

definedName (Defined Name)

§3.2.5

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_DefinedNames">

   <sequence>

   <element name="definedName" type="CT_DefinedName" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

</complexType>