[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

tp (Topic)

Represents dependency information for all topics within a volatile dependency type that share the same first string or argument.

For the RTD function, this collection will contain the remaining parameters of the function, and indicate the last known value and data type of that value.

Parent Elements

main3.15.1)

 

Child Elements

Subclause

stp (Strings in Subtopic)

§3.15.2

tr (References)

§3.15.4

v (Cell Value)

§3.3.1.93

 

Attributes

Description

t (Type)

Specifies the type of the cell value. This value corresponds to the type of data returned by the RTD or CUBE function.

 

In the following RTD example, the value "aaa: 4447" has a string data type.

 

[Example:

<tp t="s">
<v>aaa: 4447</v>
</tp>

end example]

 

For Cube functions, this attribute can be ignored when stp value is "1".

 

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

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

<complexType name="CT_VolTopic">

   <sequence>

   <element name="v" type="ST_Xstring" minOccurs="1" maxOccurs="1"/>

   <element name="stp" type="ST_Xstring" minOccurs="0" maxOccurs="unbounded"/>

   <element name="tr" type="CT_VolTopicRef" minOccurs="1" maxOccurs="unbounded"/>

   </sequence>

   <attribute name="t" type="ST_VolValueType" use="optional" default="n"/>

</complexType>