Spire.XLS API

FilterColumn Class

Represents a column used in automatic filtering.

Inheritance Hierarchy

System Object
Spire.Xls.Core.Spreadsheet.AutoFilter FilterColumn

Namespace: Spire.Xls.Core.Spreadsheet.AutoFilter
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public class FilterColumn : IAutoFilter

Public Class FilterColumn
	Implements IAutoFilter

public ref class FilterColumn : IAutoFilter

type FilterColumn =
class
interface IAutoFilter
end

The FilterColumn type exposes the following members.

Properties

	Name	Description
	FieldIndex	Gets or sets the index of the field.
	Filter	Gets or sets the filter applied to data.
	FilterType	Gets or sets the type of filter.
	FirstCondition	First condition of autofilter.
	HasFirstCondition	First condition used.
	HasSecondCondition	Second condition used
	IsAnd	Logical AND of FirstCondtion and SecondCondition.
	IsFiltered	False indicates that this autofilter was not used; otherwise True.
	IsSimple1	True if the first condition is a simple equality.
	IsSimple2	True if the second condition is a simple equality.
	IsTop10Items	Highest-valued 10 items displayed
	IsTop10Percent	Highest-valued 10 items displayed (percentage specified in condition)
	SecondCondition	Second condition of autofilter.
	ShowTopItem	Gets or sets a value indicating whether the top item should be shown based on the filter.
	Top10Items	number of items display in Top10Items mode.
	Visibledropdown	Indicates whether the AutoFilter button for this column is visible.

Methods

	Name	Description
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)