[Libreoffice-bugs] [Bug 118625] AutoFilter dropdown is lost when range has no header and the first value is filtered out

[bugzilla-daemon at bugs.documentfoundation.org]

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

stragu <stephane.guillou at member.fsf.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|AutoFilter is lost when     |AutoFilter dropdown is lost
                   |selecting blank values with |when range has no header
                   |no header                   |and the first value is
                   |                            |filtered out
                 CC|                            |stephane.guillou at member.fsf
                   |                            |.org

--- Comment #9 from stragu <stephane.guillou at member.fsf.org> ---
Reproduced with:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2021-06-14_22:38:17
Calc: threaded

Changing title as it is not required to select a blank value to reproduce.

Steps:
1. Fill a range with numbers in a single column
2. Select said range
3. Data > AutoFilter
4. Answer "No" when asked about using the first line as a header
5. Click the AutoFilter dropdown, deselect the first value, click "OK"

Result: the AutoFilter dropdown disappears.

I'm wondering what would be a preferred solution:
- Always enforce headers for AutoFilter? or
- Move autofilter dropdown menu to the first visible cell in the AutoFilter
range? (Which means you end up with an AutoFilter dropdown menu that is
technically below the top of the range.)

-- 
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/20210617/ff4dec49/attachment.htm>