2.2.4 CT_NamedObject

Referenced by: CT_NamedObjects

A named object.

Attributes:

Name: The name of the named object. MUST be unique across the list of named objects in the workbook.

Type: The type of the named object.

SheetName: The name of the sheet (1) on which the named object resides.

DisplayRightToLeft: Specifies whether this named object is displayed in right-to-left format. This attribute (2) MUST be present and equal to true if the sheet (1) on which the named object resides is displayed right-to-left. This attribute (2) MUST NOT be present if the sheet (1) on which the named object resides is displayed left-to-right.

LastNonEmptyRow: When present, MUST be the last row (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

LastNonEmptyColumn: When present, MUST be the last column (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

CurrentFirstRow: When present, MUST be the first row (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

FirstVisibleRow: When present, MUST be the first visible row (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

LastVisibleRow: When present, MUST be the last visible row (2)  of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

CurrentFirstColumn: When present, MUST be the first column (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

FirstVisibleColumn: When present, MUST be the first visible column (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

LastVisibleColumn: When present, MUST be the last visible column (2) of the named object. This attribute (2) MUST be present if Type is "PivotTable", "Table", or "NamedRange". This attribute (2) MUST NOT be present if Type is "Chart".

DisplayOutlines: Specifies whether outlines are displayed on the sheet (1) on which the named object resides. This attribute (2) MUST be present and equal to true if the sheet (1) on which the named object resides displays outlines. This attribute (2) MUST NOT be present if the sheet (1) on which the named object resides does not display outlines.

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

 <xs:complexType name="CT_NamedObject">
   <xs:attribute name="Name" type="ST_ObjectName" use="required"/>
   <xs:attribute name="Type" type="ST_enmNamedObjectType" use="required"/>
   <xs:attribute name="SheetName" type="ST_SheetName" use="required"/>
   <xs:attribute name="DisplayRightToLeft" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="LastNonEmptyRow" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="LastNonEmptyColumn" type="ST_excelColNumber1Based" use="optional"/>
   <xs:attribute name="CurrentFirstRow" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="FirstVisibleRow" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="LastVisibleRow" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="CurrentFirstColumn" type="ST_excelColNumber1Based" use="optional"/>
   <xs:attribute name="FirstVisibleColumn" type="ST_excelColNumber1Based" use="optional"/>
   <xs:attribute name="LastVisibleColumn" type="ST_excelColNumber1Based" use="optional"/>
   <xs:attribute name="DisplayOutlines" type="xs:boolean" default="false" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).