<hyperlink> (Hyperlink)

A single hyperlink

Parent Elements

<hyperlinks>3.3.1.45)

Attributes

Description

<display> (Display String)

Display string, if different from string in string table. This is a property on the hyperlink object, but does not need to appear in the spreadsheet application UI.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<id> (Relationship Id)

Namespace: .../officeDocument/2006/relationships

Relationship Id in this sheet's relationships part, expressing the target location of the resource.

The possible values for this attribute are defined by the ST_RelationshipId simple type (§7.8.2.1).

<location> (Location)

Location within target. If target is a workbook (or this workbook) this shall refer to a sheet and cell or a defined name. Can also be an HTML anchor if target is HTML file.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<ref> (Reference)

Cell location of hyperlink on worksheet.

The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64).

<tooltip> (Tool Tip)

This is additional text to help the user understand more about the hyperlink. This can be displayed as hover text when the mouse is over the link, for example.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Hyperlink">
	<attribute name="ref" type="ST_Ref" use="required"/>
	<attribute ref="r:id" use="optional"/>
	<attribute name="location" type="ST_Xstring" use="optional"/>
	<attribute name="tooltip" type="ST_Xstring" use="optional"/>
	<attribute name="display" type="ST_Xstring" use="optional"/>
</complexType>