Returns or sets whether classic XLS AutoFilter date filters use date grouping in the workbook window. Read/write Boolean.
Syntax
property AutoFilterDateGrouping: Boolean;
Remarks
This property controls the AutoFilter date-grouping flag saved in the BIFF WINDOW1 record. The default is True, matching Excel's grouped date filter behavior. Set it to False when a saved workbook should reopen with AutoFilter date grouping disabled. It does not create an AutoFilter range or change worksheet-level filter criteria.
Example
This example disables grouped date filters for the saved workbook.
Workbook.AutoFilterDateGrouping := False;