Class RowFilterSettings

RowFilterSettings class

Summary description for RowFilter.

[Obsolete("This class is obsolete; use  GridWorksheet.AddAutoFilter/FilterString for autofilter /custom filter settings")]
public class RowFilterSettings : IComparer, ISerializable

Properties

NameDescription
Criteria { get; set; }The filter criteria string.
EnableAutoFilter { get; set; }Enables auto filtering. The HeaderRow will display dropdown buttons to let user select the column’s value to be filtered.
EndColumn { get; set; }The end row number of the filter range. If this value is set to -1, the last row number of the sheet is used.
HeaderRow { get; set; }The header row number which will display filter dropdown buttons.
StartColumn { get; set; }The start row number of the filter range.

Methods

NameDescription
BuildAutoFilterCriteria()Builds criteria string from auto filter settings.
ClearFilter()Clears all filter settings and display all rows.
CustomFilter(int, ICustomFilter)Specifies a custom filter.
FilterRows()Filters rows using criteria string.

Remarks

NOTE: This class is now obsolete. This class will be removed after 6 months since Aug. 2014. you can use GridWorksheet AddAutoFilter/FilterString for autofilter /custom filter settings Aspose apologizes for any inconvenience you may have experienced.

See Also