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


Name Description
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.


Name Description
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.


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