NamedRange element
Defines a single named range within this workbook.
Usage
<NamedRange
Name="xsd:string"
RefersTo="xsd:string"
Hidden="See attribute definition. c:PasteRefersTo="[external type]"
/>
Element Information
Element type
|
Anonymous |
Namespace
|
urn:schemas-microsoft-com:office:spreadsheet |
Schema name
|
XML Spreadsheet 2002 |
Elements and Attributes
Parent Elements
Element |
Description |
Names |
Defines the collection of named ranges within a workbook. |
Names |
Defines a collection of named ranges within a workbook or worksheet. |
Child Elements
None.
Attributes
Attribute |
Type |
Required |
Description |
Possible Values |
Name |
xsd:string |
required |
Specifies the name of a named range. |
See external namespace. |
RefersTo |
xsd:string |
optional |
Specifies the range to which the name applies. |
See external namespace. |
Hidden |
None |
optional |
Specifies whether an element is visible. The Hidden attribute can be applied to the NamedRange, Column, and Row elements. |
n/a |
c:PasteRefersTo |
external ref |
optional |
See external namespace. |
See external namespace. |
Definition
<xsd:element name="NamedRange" minOccurs="0" maxOccurs="unbounded" >
<xsd:complexType>
<xsd:attribute form="qualified" name="Name" type="xsd:string" use="required">
</xsd:attribute>
<xsd:attribute form="qualified" name="RefersTo" type="xsd:string" use="optional">
</xsd:attribute>
<xsd:attribute ref="Hidden" default="0" />
<xsd:attribute ref="c:PasteRefersTo" use="optional" />
</xsd:complexType>
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved.
Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp