Export (0) Print
Expand All

CustomFilter class

Defines the CustomFilter Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:customFilter.


Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class CustomFilter : OpenXmlLeafElement

2.6.60 CT_CustomFilter

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_CustomFilters

This complex type specifies a custom filter criterion.


operator: An ST_FilterOperator ([ISO/IEC-29500-1] section 18.18.31) attribute that specifies the operator of the custom filter criterion.

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

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

<xsd:complexType name="CT_CustomFilter">

<xsd:attribute name="operator" type="x:ST_FilterOperator" default="equal" use="optional"/>

<xsd:attribute name="val" type="x:ST_Xstring"/>


See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

© 2014 Microsoft