2.2.30 CT_Hyperlink

  • Article

Referenced by: CT_Hyperlinks

A reference to a named object or range within the current workbook, or to an external resource.

Child Elements:

Target: An external resource. The element MAY<1> be a valid [RFC1738] URL.

Location: A named object or range which MUST exist within the current workbook and MUST be present when the Target element is omitted.

Tooltip: Descriptive text for the hyperlink. This element MUST be omitted when descriptive text is not present; in which case the value of Target or Location element specifies the hyperlink.

Attributes:

top: The first row (2) of the range to which the hyperlink information applies.

left: The first column (2) of the range to which the hyperlink information applies.

bottom: The last row (2) of the range to which the hyperlink information applies.

right: The last column (2) of the range to which the hyperlink information applies.

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

 <xs:complexType name="CT_Hyperlink">
   <xs:sequence>
     <xs:choice>
       <xs:element name="Target" type="ST_nonEmptyString"/>
       <xs:element name="Location" type="CT_Location"/>
     </xs:choice>
     <xs:element name="Tooltip" type="xs:string" minOccurs="0" maxOccurs="1"/>
   </xs:sequence>
   <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:complexType>

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