2.3.29 CT_Location

  • Article

Referenced by: CT_Hyperlink

A named object or range specifying the target location of a CT_Hyperlink element.

Attributes:

top: The first row to which the location information applies.

left: The first column (2) to which the location information applies.

bottom: The last row (2) to which the location information applies.

right: The last column (2) to which the location information applies.

SheetName: The name of the sheet on which the location resides.

Display: Specifies the reference to the target location. MUST be present if the location element does NOT refer to a named object.

Type: The type of named object to which the location information applies. This attribute (2) MUST be present if the location element refers to a named object and MUST NOT be present otherwise.

ObjectName: The named object to which this location element refers. This attribute (2) MUST be present if this location element refers to a named object 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_Location">
   <xs:attribute name="top" type="ST_excelRowNumber" use="required"/>
   <xs:attribute name="left" type="ST_excelColNumber" use="required"/>
   <xs:attribute name="bottom" type="ST_excelRowNumber" use="required"/>
   <xs:attribute name="right" type="ST_excelColNumber" use="required"/>
   <xs:attribute name="SheetName" type="ST_SheetName" use="required"/>
   <xs:attribute name="Display" type="ST_nonEmptyString" use="optional"/>
   <xs:attribute name="Type" type="ST_enmNamedObjectType" use="optional" default="InvalidNamedObjectType"/>
   <xs:attribute name="ObjectName" type="ST_ObjectName" use="optional"/>
 </xs:complexType>

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