[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

tp3.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"/>

end example]

 

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>