Class FilterColumn

Namespace

Spire.Xls.Core.Spreadsheet.AutoFilter

Assembly

Spire.XLS.dll

public class FilterColumn : IAutoFilter

Inheritance

object

FilterColumn

Implements

IAutoFilter

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

FieldIndex

public int FieldIndex { get; set; }

Property Value

int

Filter

public object Filter { get; set; }

Property Value

object

FilterType

public FilterType FilterType { get; set; }

Property Value

FilterType

FirstCondition

public IAutoFilterCondition FirstCondition { get; }

Property Value

IAutoFilterCondition

HasFirstCondition

First condition used.

public bool HasFirstCondition { get; }

Property Value

bool

HasSecondCondition

Second condition used

public bool HasSecondCondition { get; }

Property Value

bool

IsAnd

Logical AND of FirstCondtion and SecondCondition.

public bool IsAnd { get; set; }

Property Value

bool

IsFiltered

public bool IsFiltered { get; }

Property Value

bool

IsSimple1

True if the first condition is a simple equality.

public bool IsSimple1 { get; set; }

Property Value

bool

IsSimple2

True if the second condition is a simple equality.

public bool IsSimple2 { get; set; }

Property Value

bool

IsTop10Items

Highest-valued 10 items displayed

public bool IsTop10Items { get; set; }

Property Value

bool

IsTop10Percent

Highest-valued 10 items displayed (percentage specified in condition)

public bool IsTop10Percent { get; set; }

Property Value

bool

SecondCondition

Second condition of autofilter.

public IAutoFilterCondition SecondCondition { get; }

Property Value

IAutoFilterCondition

ShowTopItem

public bool ShowTopItem { get; set; }

Property Value

bool

Top10Items

number of items display in Top10Items mode.

public int Top10Items { get; set; }

Property Value

int

Visibledropdown

Indicates whether the AutoFilter button for this column is visible.

public bool Visibledropdown { get; set; }

Property Value

bool