https://bugs.documentfoundation.org/show_bug.cgi?id=133529
--- Comment #12 from Regina Henschel <[email protected]> --- The attribute in file markup for autofilter is "table:display-filter-buttons" (19.624 part3 ODF1.4). Its description refers to the labels of rows or columns. That means, if a database range has row labels, autofilter control fields should be attached to these label cells and thus filter out columns. But that is not implemented in LibreOffice. I think the expectation in this report is wrong. A database range can have only one orientation. All cells, that belong to the same record, can either be arranged in a row or a column. As Autofilter always filters records, it will be never possible to use it to filter out a field of the database. As Autofilter is only implemented in LibreOffice for the case, that the database has the cells of a record arranged in a row, it will always conflict with a database, that has the cells of a record arranged in a column. So if the user combines these, LibreOffice has to decide which orientation to use for the database and the current decision is to use that one expected by the autofilter. So the bug is, that the user is not warned about the conflict and the current error message about missing labels has no option to abort applying autofilters. And it remains the request, that the implementation of autofilter needs to be extended to work with a database range that has an orientation with row labels. If you want to filter records of a database range, that has the cells of a record arranged in columns and thus has row labels, do not work on the database range itself, but use the new FILTER function to extract the wanted part of the database range into a separate range of cells. -- You are receiving this mail because: You are the assignee for the bug.
