TopicReferences class

Office 2013 and later

References. When the object is serialized out as xml, its qualified name is x:tr.

Inheritance hierarchy

Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

tr (References)

Represents the reference to a cell that depends on this topic. Each topic can 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 (§18.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 (§18.18.7).
s (Sheet Id)	Specifies the sheet index. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

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 (§18.18.7).

s (Sheet Id)

Specifies the sheet index.

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

[Note: The W3C XML Schema definition of this element’s content model (CT_VolTopicRef) is located in §A.2. end note]

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.