Share via

2.6.209 CT_ColumnFilter

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2019/namedsheetviews

Referenced by: CT_NsvFilter

This complex type defines filter criteria that is used on a specific column as part of a named sheet view

Child Elements:

dxf: A CT_Dxf ([ISO/IEC29500-1:2016] section A.2).  If the filter element within this type includes a colorFilter ([ISO/IEC29500-1:2016] section 18.3.2.1) then this element MUST be present and MUST be used in place of the one referenced by the dxfId attribute on the colorFilter.  If the filter element within this type does NOT include a colorFilter ([ISO/IEC29500-1:2016] section 18.3.2.1) then this element MUST be omitted.

filter: A CT_FilterColumn ([ISO/IEC29500-1:2016] section A.2).  Defines the filter conditions to apply.

extLst: A CT_ExtensionList ([ISO/IEC29500-1:2016] section A.2) that specifies future extensibility for this element.

Attributes:

colId: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the zero-based index of the column that this filter is applied to.  When loading this element colId and id SHOULD be considered as described in section 2.3.8.2.

id: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of the column this filter is applied to.  When loading this element colId and id SHOULD be considered as described in section 2.3.8.2.

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

 <xsd:complexType name="CT_ColumnFilter">
   <xsd:sequence>
     <xsd:element name="dxf" type="x:CT_Dxf" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="filter" minOccurs="0" maxOccurs="unbounded" type="x:CT_FilterColumn"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attributeGroup ref="AG_ColumnId"/>
 </xsd:complexType>

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