2.6.175 CT_RichValue

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2017/richdata

Referenced by: CT_RichValueData

This complex type specifies rich value data information for a single rich value.

Child Elements:

fb: A CT_RichValueFallback element that specifies the rich value fallback.

v: A CT_Value element that specifies a value contained in the rich value as part of a key value pair (KVP). The rich value key and data type is determined by matching the index of the CT_Value with the index of the CT_Key (section 2.6.163) in the CT_RichValueStructure (section 2.6.180) identified by the s attribute.

Certain data types indicate that the value represents an index as described in the table below.

Value

Meaning

"a"

The CT_Value identifies a CT_Array specified in section 2.6.157. This is a zero-based index.

"r"

The CT_Value identifies a CT_RichValue specified in this section. This is a zero-based index. This index MUST reference a CT_RichValue that comes before the current CT_RichValue in the list specified in CT_RichValueData (section 2.6.177).

"spb"

The CT_Value identifies a CT_SupportingPropertyBag specified in section 2.6.188. This is a zero-based index.

Attributes:

s: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the identifier to the CT_RichValueStructure (section 2.6.180). This is a zero-based index.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_RichValue">
   <xsd:sequence>
     <xsd:element name="fb" minOccurs="0" maxOccurs="1" type="CT_RichValueFallback"/>
     <xsd:element name="v" minOccurs="1" maxOccurs="unbounded" type="CT_Value"/>
   </xsd:sequence>
   <xsd:attribute name="s" type="xsd:unsignedInt" use="required"/>
 </xsd:complexType>

See section 5.21 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).