Share via

2.3.4 CT_NamedObject

  • Article

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 on which the named object resides.

Width: Specifies the width of the named object in pixels.

Height: Specifies the height of the named object in pixels.

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 on which the named object resides is displayed right-to-left. This attribute (2) MUST NOT be present if the sheet 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 on which the named object resides. This attribute (2) MUST be present and equal to true if the sheet 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.

IsPivot: Specifies whether this named object is a PivotTable or PivotChart. This attribute (2) MUST be present and equal to true if the named object is a PivotTable or PivotChart. This attribute (2) MUST NOT be present if the named object is not a PivotTable or PivotChart.

ImageId: Specifies the image id when the named object is a chart. This attribute MUST be present if Type is "Chart" and MUST NOT be present otherwise.

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="Width" type="ST_nonNegativeInteger" use="required"/>
   <xs:attribute name="Height" type="ST_nonNegativeInteger" 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:attribute name="IsPivot" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="ImageId" type="ST_nonEmptyString" use="optional"/>
 </xs:complexType>

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