Class AF

This class contains constants used for autofilter parsing and serialization in Excel 2007 format.

Inheritance

System.Object

AF

Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public sealed class AF : Object

Constructors

AF()

Declaration

public AF()

Fields

AndCriteriaAttributeName

Name of the xml attribute that represents flag indicating whether the two criteria have an "and" relationship. '1' indicates "and", '0' indicates "or".

Declaration

public const string AndCriteriaAttributeName = "and"

Field Value

Type	Description
System.String

AutoFilterColumnTagName

Name of the xml tag that identifies a particular column in the AutoFilter range and specifies filter information that has been applied to this column

Declaration

public const string AutoFilterColumnTagName = "filterColumn"

Field Value

Type	Description
System.String

AutoFilterSettingsTagName

Name of the xml tag name that represents auto filter settings.

Declaration

public const string AutoFilterSettingsTagName = "autoFilter"

Field Value

Type	Description
System.String

AutoFilterTopTenTagName

Name of the xml tag that specifies the top N (percent or number of items) to filter by.

Declaration

public const string AutoFilterTopTenTagName = "top10"

Field Value

Type	Description
System.String

CellOrRangeReferenceAttributeName

Name of the xml attribute that represents reference to the cell range to which the AutoFilter is applied.

Declaration

public const string CellOrRangeReferenceAttributeName = "ref"

Field Value

Type	Description
System.String

CustomFilterCriteriaTagName

Name of the xml tag that represents custom filter criteria.

Declaration

public const string CustomFilterCriteriaTagName = "customFilter"

Field Value

Type	Description
System.String

CustomFiltersCriteriaTagName

Name of the xml tag that represents custom filters criteria.

Declaration

public const string CustomFiltersCriteriaTagName = "customFilters"

Field Value

Type	Description
System.String

FilterBlankAttributeName

Flag indicating whether to filter by blank.

Declaration

public const string FilterBlankAttributeName = "blank"

Field Value

Type	Description
System.String

FilterByPercentAttributeName

Name of the xml attribute that represents flag indicating whether or not to filter by percent value of the column.

Declaration

public const string FilterByPercentAttributeName = "percent"

Field Value

Type	Description
System.String

FilterColumnDataAttributeName

Name of the xml attribute that indicates the AutoFilter column to which this filter information applies.

Declaration

public const string FilterColumnDataAttributeName = "colId"

Field Value

Type	Description
System.String

FilterComparisonOperatorAttributeName

Name of the xml attribute name that represents operator used by the filter comparison.

Declaration

public const string FilterComparisonOperatorAttributeName = "operator"

Field Value

Type	Description
System.String

FilterCriteriaTagName

Name of the xml tag that groups filter criteria together.

Declaration

public const string FilterCriteriaTagName = "filters"

Field Value

Type	Description
System.String

FilterTagName

Name of the xml tag that expresses a filter criteria value.

Declaration

public const string FilterTagName = "filter"

Field Value

Type	Description
System.String

FilterValAttributeName

Name of the xml attribute that represents the actual cell value in the range which is used to perform the comparison for this filter.

Declaration

public const string FilterValAttributeName = "filterVal"

Field Value

Type	Description
System.String

FilterValueAttributeName

Name of the xml attribute that represents filter value used in the criteria.

Declaration

public const string FilterValueAttributeName = "val"

Field Value

Type	Description
System.String

OperatorEqual

Show results which are equal to criteria.

Declaration

public const string OperatorEqual = "equal"

Field Value

Type	Description
System.String

OperatorGreaterThan

Show results which are greater than criteria.

Declaration

public const string OperatorGreaterThan = "greaterThan"

Field Value

Type	Description
System.String

OperatorGreaterThanOrEqual

Show results which are greater than or equal to criteria.

Declaration

public const string OperatorGreaterThanOrEqual = "greaterThanOrEqual"

Field Value

Type	Description
System.String

OperatorLessThan

Show results which are less than criteria.

Declaration

public const string OperatorLessThan = "lessThan"

Field Value

Type	Description
System.String

OperatorLessThanOrEqual

Show results which are less than or equal to criteria.

Declaration

public const string OperatorLessThanOrEqual = "lessThanOrEqual"

Field Value

Type	Description
System.String

OperatorNotEqual

Show results which are not equal to criteria.

Declaration

public const string OperatorNotEqual = "notEqual"

Field Value

Type	Description
System.String

TopAttributeAttributeName

Name of the xml attribute that represents flag indicating whether or not to filter by top order.

Declaration

public const string TopAttributeAttributeName = "top"

Field Value

Type	Description
System.String

TopOrBottomValueAttributeName

Name of the xml attribute that represents top or bottom value to use as the filter criteria.

Declaration

public const string TopOrBottomValueAttributeName = "val"

Field Value

Type	Description
System.String