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