Created attachment 198179 [details] Open the table and try the behavior of the fields with AutoFilter Open the attached database. There is only one table. Open the table for input data. Set cursor in a field and try AutoFilter. If setting filter it won't work for fields with Time or DateTime. All other fields will work well. There seems to be no possibility to filter times by this tool. Also defining a filter by DefaultFilter won't get a filtered result.
Confirm with Version: 25.2.0.0.beta1+ (X86_64) / LibreOffice Community Build ID: a49bea44b7989afd850e9a4a56c2c8a0d1a1ff37 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version: 6.4.0.0.alpha1+
In my own test in LO 24.2.7.2 (x86-64) (german version) in a table don´t Autofilter works in time (e.g. 07:10:00) But for datetime (30.12.99 00:00) works fine.
(In reply to Pit Zaclade from comment #2) > In my own test in LO 24.2.7.2 (x86-64) (german version) in a table don´t > Autofilter works in time (e.g. 07:10:00) > But for datetime (30.12.99 00:00) works fine. Please test the attached database file. It is Firebird database. Might be there is a difference to HSQLDB, because DateTime-formats are different there.
Created attachment 198182 [details] Same with HSQLDB: Only time values couldn't be filtered Seems there are differences between filtering of timestamp between HSQLDB and Firebird. Firebird won't be filtered by AutoFilter, HSQLDB will be filtered.