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

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.

Methods

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.

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