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