<tr> (References)

Represents the reference to a cell that depends on this topic. Each topic may have one or more cells dependencies.

For CUBE functions, each <tr> element contains a cell whose cube function call dependent on the connection in <main>@first.

Parent Elements

<tp>3.15.3)

Attributes

Description

<r> (Reference)

Specifies a reference to the cell location. The location is scoped to the sheet specified in s.

example:
<tr r="A6" s="1"/>

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

<s> (Sheet Id)

Specifies the sheet index.

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

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

<complexType name="CT_VolTopicRef">
	<attribute name="r" type="ST_CellRef" use="required"/>
	<attribute name="s" type="xsd:unsignedInt" use="required"/>
</complexType>