Back to Devexpress

SheetAutoFilter.Apply(CellRange, Boolean) Method

officefileapi-devexpress-dot-spreadsheet-dot-sheetautofilter-dot-apply-x28-devexpress-dot-spreadsheet-dot-cellrange-system-dot-boolean-x29.md

latest2.1 KB
Original Source

SheetAutoFilter.Apply(CellRange, Boolean) Method

Enables the filtering functionality for the specified cell range.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void Apply(
    CellRange range,
    bool allowExpand
)
vb
Sub Apply(
    range As CellRange,
    allowExpand As Boolean
)

Parameters

NameTypeDescription
rangeCellRange

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.

See Also

SheetAutoFilter Interface

SheetAutoFilter Members

DevExpress.Spreadsheet Namespace