Share via

2.6.210 CT_NamedSheetView

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2019/namedsheetviews

Referenced by: CT_NamedSheetViews

This complex type specifies the properties of a named sheet view

Child Elements:

nsvFilter: A CT_NsvFilter element that specifies the sort and/or filter criteria to be applied to a specified AutoFilter

extLst: A CT_ExtensionList ([ISO/IEC29500-1:2016] section A.2) that specifies future extensibility for this element

Attributes:

name: A string ([XMLSCHEMA2/2] section 3.2.1) attribute that specifies the name of the named sheet view.  The value of this attribute MUST be unique among elements within a CT_NamedSheetViews (section 2.6.211)

The number of characters in the string MUST be greater than or equal to 1 and less than or equal to 127.  The string MUST conform to the following Augmented Backus-Naur Form (ABNF) ([RFC5234]) grammar:

string = name-character-special [*name-character name-character-special]
whitespace = %x09-%x0D / “ “
name-character-special = character ; MUST NOT be “;” or whitespace
; character = as defined by the production of Char in the [W3C-XML] section 2.2
name-character = name-character-special / “ “

Values beginning with “_xlnsv.” are reserved for future use.

id: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of this element.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_NamedSheetView">
   <xsd:sequence>
     <xsd:element name="nsvFilter" type="CT_NsvFilter" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="name" type="xsd:string" use="required"/>
   <xsd:attribute name="id" type="x:ST_Guid" use="required"/>
 </xsd:complexType>

See section 5.26 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).