Share via

2.6.174 CT_RichTop10

  • Article

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

Referenced by: CT_RichFilterColumn

This complex type specifies a top N filter or bottom N filter. This complex type extends the base type CT_Top10 ([ISO/IEC29500-1:2016] section 18.3.2.10).

Attributes:

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

top: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether a top N filter or a bottom N filter is applied. True indicates a top N filter is applied. False indicates a bottom N filter is applied.

percent: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the top N filter or bottom N filter is based on a percentage of the total sum of values in the column or not. True indicates value filters by a percent value of the column. False indicates value filters by number of items.

val: A double ([XMLSCHEMA2/2] section 3.2.5) attribute that specifies the top or bottom value to use as the filter criteria.

filterVal: A double ([XMLSCHEMA2/2] section 3.2.5) attribute that specifies the actual cell value or rich value data in the range which is used to perform the comparison for this filter.

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

 <xsd:complexType name="CT_RichTop10">
   <xsd:complexContent>
     <xsd:extension base="x:CT_Top10">
       <xsd:attribute name="key" type="ST_RichFilterKey" use="optional"/>
     </xsd:extension>
   </xsd:complexContent>
 </xsd:complexType>

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