SheetAutoFilter.Apply(CellRange, Boolean) Method

Enables the filtering functionality for the specified cell range.

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

void Apply(
    CellRange range,
    bool allowExpand
)

Sub Apply(
    range As CellRange,
    allowExpand As Boolean
)

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.

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.