2.7.1 Application Data For VtHyperlink
The following algorithm specifies how hyperlink properties ([MS-OSHARED] section 2.3.3.1.18) that are associated with a range of cells or shapes in a document construct their dwApp structure member (1) value.
If the hyperlink is associated with a shape [MS-ODRAW] section 2.2.31, the dwApp value MUST be 0xFFFFFFFF.
Otherwise the hyperlink MUST be associated with a range of cells on a sheet, and the dwApp value is computed as follows:
Set an unsigned 2-byte integer (wHLIndex) equal to the zero-based index of the HLink structure or HLinkTooltip structure in the sheet that the hyperlink is associated with.
Set an unsigned 2-byte integer (wWSIndex) equal to the zero-based index of the sheet in the document on which this range of cells that the hyperlink is associated with is defined.
The value of dwApp MUST be equal to the bitwise OR of wWSIndex shifted 16 bits to the high order and wHLIndex.
Example:
dwApp = (wWSIndex << 16) | wHLIndex;