Class ExcelCustomFilterColumn

Represents a custom filter column

Inheritance

System.Object

XmlHelper

ExcelFilterColumn

ExcelCustomFilterColumn

Inherited Members

ExcelFilterColumn.GetFilterValue(String)

ExcelFilterColumn.Position

ExcelFilterColumn.HiddenButton

ExcelFilterColumn.ShowButton

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelCustomFilterColumn : ExcelFilterColumn

Properties

And

Flag indicating whether the two criteria have an "and" relationship. true indicates "and", false indicates "or".

Declaration

public bool And { get; set; }

Property Value

Type	Description
System.Boolean

Filters

The filters to apply

Declaration

public ExcelFilterCollection<ExcelFilterCustomItem> Filters { get; set; }

Property Value

Type	Description
ExcelFilterCollection<ExcelFilterCustomItem>

IsNumericFilter

If true filter is numeric otherwise it's textual. If this property is not set, the value is set from the first value in column of the filtered range

Declaration

public bool IsNumericFilter { get; set; }

Property Value

Type	Description
System.Boolean