Documentazione HotXLS

AutoFilterDateGrouping proprietà

Restituisce o sets whether classic XLS AutoFilter date filters use date grouping in the workbook window. Read/write Boolean

Sintassi

proprietà AutoFilterDateGrouping: Boolean;

Osservazioni

This proprietà controls the AutoFilter date-grouping flag saved in the BIFF WINDOW1 record. The default is True, matching Excel's grouped date filter behavior. Imposta it to False when a saved workbook should reopen with AutoFilter date grouping disabled. It does not create an AutoFilter range o change worksheet-level filter criteria

Esempio

This example disables grouped date filters for the saved workbook

Workbook.AutoFilterDateGrouping := False;