Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SheetAutoFilter.Apply(CellRange, Boolean) Method

Enables the filtering functionality for the specified cell range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

void Apply(
    CellRange range,
    bool allowExpand
)

#Parameters

Name Type Description
range CellRange

A CellRange object that is the cell range to which the filter is applied.

allowExpand Boolean

true, to expand the filtered range downwards to include data in affected columns; otherwise, false.

#Remarks

Once the filter is activated, a drop-down arrow appears on the right side of each column header. End-users can click the arrow of the required column and select the filter type they wish to apply.

SpreadsheetControl_ApplyFilter

This Apply method override allows you to specify whether the filtered range should expand downwards to include data in affected columns. To do that, set the allowExpand parameter to true. With the false passed as the method allowExpand parameter, filtering is enabled only for the cell range specified by the range parameter of the method.

See Also