https://bugs.documentfoundation.org/show_bug.cgi?id=158634
--- Comment #12 from Stéphane Guillou (stragu) <stephane.guil...@libreoffice.org> --- Created attachment 191782 --> https://bugs.documentfoundation.org/attachment.cgi?id=191782&action=edit modified sample ODS to compare with or without strings coming from a complex format code Hm I think there might actually be something to fix here. See the attached modified sample document: - column Q is similar to the original data: it uses a custom date format that displays "нет" in some cases. The AutoFilter does not use the date trees for such formatted dates. - column R has the same data, but using a standard date format. Dates use the date trees, _even though the column has mixed data_: there are some strings in there (e.g. "string" and "да", highlighted in orange) but that doesn't stop the AutoFilter from constructing date trees for date data, including the year even when it is not displayed, and keeping the text data as is at the bottom of the list. So I agree that there is a bug, and that e.g. cell Q5 should be handled just like cells Q4 or R5. Balázs, do you think the issue stems from the format code complexity and use of a condition? For reference, the format code is: [>0]DD.MMM.;[<0]"";"нет" -- You are receiving this mail because: You are the assignee for the bug.