Skip to main content
All docs
V25.1
  • Row

    PivotFilter.UseWholeDay Property

    Gets or sets whether the date filter should use whole days in its filtering criteria.

    Namespace: DevExpress.Spreadsheet

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

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

    bool UseWholeDay { get; set; }

    Property Value

    Type Description
    Boolean

    true, to use whole days in the date filter; otherwise,false.

    Remarks

    Enable the UseWholeDay property to ignore time values in date and time fields when using a date filter.

    Note

    The UseWholeDay property is always true when a PivotTable timeline is used to filter dates. If you change the property’s value to false in this case, the Spreadsheet throws an InvalidOperationException.

    See Also