<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138704#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138704">bug 138704</a> from <a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> NISZ LibreOffice Team</a> <pre>Playing with this in Excel as well, I see: - In Excel you can either turn on/off the autofilter for the table or the new data outside of the table, if the selection of cells/rows/columns is inside or outside of the table. If you select a range that contains cells (rows/columns) in both the table and outside of it, the autofilter button is disabled. - In Calc if the selection is inside the table (Database Range), the autofilter affects only the table. * This is true if the selection is only partially inside the table like C2:D2 (Excel does not allow autofilter in this case, Calc shouldn't either). * If the selection is one cell and it's outside the table and not in Column D), then the autofilter is turned on / off for all columns. (this works as if there was no table, but should consider whether it's inside the table or outside and affect only the table or the columns outside of it) * If the selection is at least partially in Column D, it turns on/off the autofilter in the table. (wrong, autofilter should be disabled) * If the selection is at least two cells in columns E-F then the selected range has the autofilter turned on (this works correctly, same as if there was no table).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>