Class AF
This class contains constants used for autofilter parsing and serialization in Excel 2007 format.
Inheritance
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.NET.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 |
---|
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 |
---|
System.String |
AutoFilterSettingsTagName
Name of the xml tag name that represents auto filter settings.
Declaration
public const string AutoFilterSettingsTagName = "autoFilter"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
CustomFilterCriteriaTagName
Name of the xml tag that represents custom filter criteria.
Declaration
public const string CustomFilterCriteriaTagName = "customFilter"
Field Value
Type |
---|
System.String |
CustomFiltersCriteriaTagName
Name of the xml tag that represents custom filters criteria.
Declaration
public const string CustomFiltersCriteriaTagName = "customFilters"
Field Value
Type |
---|
System.String |
FilterBlankAttributeName
Flag indicating whether to filter by blank.
Declaration
public const string FilterBlankAttributeName = "blank"
Field Value
Type |
---|
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 |
---|
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 |
---|
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 |
---|
System.String |
FilterCriteriaTagName
Name of the xml tag that groups filter criteria together.
Declaration
public const string FilterCriteriaTagName = "filters"
Field Value
Type |
---|
System.String |
FilterTagName
Name of the xml tag that expresses a filter criteria value.
Declaration
public const string FilterTagName = "filter"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
OperatorEqual
Show results which are equal to criteria.
Declaration
public const string OperatorEqual = "equal"
Field Value
Type |
---|
System.String |
OperatorGreaterThan
Show results which are greater than criteria.
Declaration
public const string OperatorGreaterThan = "greaterThan"
Field Value
Type |
---|
System.String |
OperatorGreaterThanOrEqual
Show results which are greater than or equal to criteria.
Declaration
public const string OperatorGreaterThanOrEqual = "greaterThanOrEqual"
Field Value
Type |
---|
System.String |
OperatorLessThan
Show results which are less than criteria.
Declaration
public const string OperatorLessThan = "lessThan"
Field Value
Type |
---|
System.String |
OperatorLessThanOrEqual
Show results which are less than or equal to criteria.
Declaration
public const string OperatorLessThanOrEqual = "lessThanOrEqual"
Field Value
Type |
---|
System.String |
OperatorNotEqual
Show results which are not equal to criteria.
Declaration
public const string OperatorNotEqual = "notEqual"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |