Share via

2.7.38 ST_RichFilterKey

  • Article

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

Referenced by: CT_RichFilter, CT_RichDateGroupItem, CT_RichTop10, CT_CustomRichFilter, CT_DynamicRichFilter

This simple type extends ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) and specifies the rich value key for which the filter is defined. The length of this string MUST be less than or equal to 65,535 characters in length. This simple type MUST conform to one of the following grammars.

Grammar

Example

{ rich-value-key }

"RichFilterKey"

{ ["#" length-of-rich-value-key "#" rich-value-key] }

"#13#RichFilterKey"

  • The length-of-rich-value-key MUST be specified with integers and MUST match the count of the characters in the associated rich-value-key.

  • The rich-value-key MUST be less than or equal to 255 characters in length.

  • If rich-value-key begins with "#" then it MUST use the second grammar.

  • The second grammar can be repeated to specify nested rich value keys.

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

 <xsd:simpleType name="ST_RichFilterKey">
   <xsd:restriction base="x:ST_Xstring"/>
 </xsd:simpleType>

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