Share via

2.6.165 CT_RichFilter

  • Article

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

Referenced by: CT_RichFilters

This complex type specifies a filter criterion associated with rich values. Rows that contain a rich value within the filter range that have key value pair (KVP) with value val and key key will not be hidden by this filter criterion. Rows that do not contain such a rich value will be hidden.

Attributes:

key: An ST_RichFilterKey (section 2.7.38) attribute that specifies the rich value key for which the filters is defined.

val: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the value to be used as a filter criterion. The length of this value MUST be less than 65536 characters.

blank: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the filter criterion includes blank values.

nodata: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the filter includes values that do not have the specified rich value key.

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

 <xsd:complexType name="CT_RichFilter">
   <xsd:attribute name="key" type="ST_RichFilterKey" use="optional"/>
   <xsd:attribute name="val" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="blank" type="xsd:boolean" use="optional"/>
   <xsd:attribute name="nodata" type="xsd:boolean" use="optional"/>
 </xsd:complexType>

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