Skip to main content
All docs
V25.1
  • Row

    SheetAutoFilter.Apply(CellRange, Boolean) Method

    Enables the filtering functionality for the specified cell range.

    Namespace: DevExpress.Spreadsheet

    Assembly: DevExpress.Spreadsheet.v25.1.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