[Libreoffice-bugs] [Bug 138704] FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138704

--- Comment #6 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210714/f30bcaec/attachment-0001.htm>