API Reference
LegacyXlsAutoFilterCriteria
Represents parsed legacy AutoFilter criteria for one filtered column.
Inheritance
- Object
- LegacyXlsAutoFilterCriteria
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Constructors
public LegacyXlsAutoFilterCriteria(UInt32 columnId, Boolean matchAll, IReadOnlyList<LegacyXlsAutoFilterCondition> conditions, LegacyXlsAutoFilterKind kind = Custom, Nullable<UInt16> top10Value = null, Boolean top10IsTop = true, Boolean top10IsPercent = false) #Creates parsed legacy AutoFilter criteria.
Parameters
- columnId System.UInt32
- matchAll System.Boolean
- conditions System.Collections.Generic.IReadOnlyList{OfficeIMO.Excel.LegacyXls.Model.LegacyXlsAutoFilterCondition}
- kind OfficeIMO.Excel.LegacyXls.Model.LegacyXlsAutoFilterKind = Custom
- top10Value System.Nullable{System.UInt16} = null
- top10IsTop System.Boolean = true
- top10IsPercent System.Boolean = false
Methods
public static LegacyXlsAutoFilterCriteria CreateBlanks(UInt32 columnId) #LegacyXlsAutoFilterCriteriaCreates parsed legacy blank AutoFilter criteria.
Parameters
- columnId System.UInt32
public static LegacyXlsAutoFilterCriteria CreateNonBlanks(UInt32 columnId) #LegacyXlsAutoFilterCriteriaCreates parsed legacy nonblank AutoFilter criteria.
Parameters
- columnId System.UInt32
public static LegacyXlsAutoFilterCriteria CreateTop10(UInt32 columnId, UInt16 value, Boolean isTop, Boolean isPercent) #LegacyXlsAutoFilterCriteriaCreates parsed legacy Top/Bottom AutoFilter criteria.
Parameters
- columnId System.UInt32
- value System.UInt16
- isTop System.Boolean
- isPercent System.Boolean
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public UInt32 ColumnId { get; } #Gets the zero-based column index within the AutoFilter range.
public Boolean MatchAll { get; } #Gets whether multiple conditions must all match.
public LegacyXlsAutoFilterJoinOperator JoinOperator { get; } #Gets the logical join used when this criteria has comparison conditions.
public IReadOnlyList<LegacyXlsAutoFilterCondition> Conditions { get; } #Gets the parsed filter conditions.
public LegacyXlsAutoFilterKind Kind { get; } #Gets the kind of AutoFilter criteria represented by this record.
public Boolean IsTop10 { get; } #Gets whether this criteria represents a Top/Bottom AutoFilter.
public Nullable<UInt16> Top10Value { get; } #Gets the Top/Bottom count or percentage value.
public Boolean Top10IsTop { get; } #Gets whether the Top/Bottom criteria keeps top values rather than bottom values.
public Boolean Top10IsPercent { get; } #Gets whether the Top/Bottom criteria value is a percentage rather than an item count.