When I apply AutoFilter in Calc, as I move the pointer to select something inside the AutoFilter menu, the menu disappears. If I press again the AutoFilter triangle icon, the menu appears again, but as I move the cursor, it disappears.
(copy of "https://ask.libreoffice.org/en/question/175192/autofilter-menu-disappears-as-i-move-the-pointer/")
Steps to Reproduce:
1. make 2 colums with header, add data
2. Select header row
3. Click AutoFilter icon
4. Click the AutoFilter triangle icon and try to select a filter
Menu closes when mouse moves
Menu should stay open
User Profile Reset: No
OpenGL enabled: Yes
Created attachment 147510 [details]
Has AutoFilter in Calc
Thank you for reporting the bug. I can not reproduce the bug in
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 2; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: group threaded
Also, not reproducible in
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Menu stays open and I'm able to select the filter options.
Might be a Linux version problem. Any ideas about how to debug?
OK, I found a work around.
Right click on the triangele icon and select "Selection List", then the menu stay open.
michael, it may be distributiv related problem. What Linux distro do you use and where did you install LibreOffice from (repo of your distro or site of TDF)?
Ubuntu 18.04 (64 bit) new installation with latest updates. Installation from Ubuntu 18.04.1 bootable USB dongle. LO Version: 126.96.36.199.
Also present after adding PPA for LibreOffice fresh (http://ppa.launchpad.net/libreoffice/ppa/ubuntu). LO Version: 188.8.131.52
Seen on two different computers (desktop and laptop).
(In reply to michael from comment #6)
> Ubuntu 18.04 (64 bit) new installation with latest updates. Installation
> from Ubuntu 18.04.1 bootable USB dongle. LO Version: 184.108.40.206.
> Also present after adding PPA for LibreOffice fresh
> (http://ppa.launchpad.net/libreoffice/ppa/ubuntu). LO Version: 220.127.116.11
> Seen on two different computers (desktop and laptop).
PLease try delete your LibreOffice, download LibreOffice from download.libreoffice.org and install it. Then try repeat your problem
OK, found the root cause: Display zoom set to 200% in Ubuntu Settings under Decvice -> Displays. This due to HiDPI monitors.
How can this be corrected? All others with modern HiDPI screens will meet this also.
I have same issue; my system:
- Linux Mint 19.1 Tessa (based on Ubuntu 18.04.1)
- LibreOffice 6.0.7
- Monitor: Samsung 28", res: 3840 x 2160
Issue appears on Autofilter dropdowns mentioned in bug description, but it also appears for the dropdowns used for filtering Pivot Tables via arrows in the table headings. The workaround for Autofilter dropdowns doesn't work for Pivot tables, making this issue more serious.
NEW per last comment.
Reproduced on OpenSUSE Leap 42.3
Version : 18.104.22.168-27.4
Version : 22.214.171.124-27.4
Same issue on Fedora 29 x86-64 HiDPI (3840x2160).
*** Bug 122568 has been marked as a duplicate of this bug. ***
From: Matijs van Zuijlen <firstname.lastname@example.org>
To: Debian Bug Tracking System <email@example.com>
Subject: libreoffice-gtk3: Filter drop-down in Calc closes too soon with Gtk3 rendering
Date: Tue, 07 Aug 2018 13:55:29 +0200
When I have a document with autofilters in Calc, and I click on the
button with the little inverted triangle that makes the filter drop-down
appear, then as soon as I move my mouse down to actually interact with
the drop-down, the drop-down disappears.
If I click low enough on the button, the drop-down appears underneath my
mouse cursor and I can interact with the filter.
If I remove libreoffice-gtk3, a different drop-down appears and the
problem does not occur.
If instead of libreoffice-gtk3 I install libreoffice-gtk2, the problem
also does not occur.
I'm able to reproduce this in LibreOffice 126.96.36.199 running Kubuntu 19.04. I do have HiDPI monitors.
I can reproduce this on LibreOffice 188.8.131.52 running on KDE Neon 5.16 with a HiDPI touchscreen. For what its worth, the autofilter menu doesn't disappear if the pointer is moved to the menu via touch event after activating the triangle button.
Don't change earlier version to later if there was confirming there
Created attachment 157555 [details]
Short video depicting the behaviour
I have been seeing this for many years, but being just occasional office user, never bothered to report it. I found this bug, so pretty sure I am seeing the same. And I have been using 4K monitors for many years.
Affected version: LibreOffice 184.108.40.206.0 30(Build:2)
(this comes from app-office/libreoffice-220.127.116.11 on Gentoo linux with x11-libs/gtk+-3.24.13)
I confirm that `SAL_USE_VCLPLUGIN=gen libreoffice` works without issues, I'll make it a permanent solution for the time being.
I've also been seeing this bug for a few years (one of the bugs that forces me to use Google Spreadsheet, even for just manipulating a local file). I can reproduce this on
Ubuntu 18.04.4 LTS
I'm on a HiDPI display with 200% scaling.
Really appreciate the workaround mentioned in Comment 4
me too, debian / kali hidpi (4k) screen, fresh 7.0 alpha, screen scaling 200%,
win ver. on similar machine with 225% font scaling unaffected,
i suspect a small gap between dropdown button and menu representation,
- press <tab> while pointer still on the button, that somehow changes the focus and keeps the menu open,
- a fast move down with the mouse (touchpad in my case) mostly 'catches' the menu and keeps it open,
- start typing something, the initial focus is in the search field of the menu, menu will be kept open,
'minor' as sufficient workarounds available,
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: de-DE (en_US.UTF-8); UI: en-US
Tormented by this bug as well. Xubuntu 20.04, 4k screen, 200% scaling.
Just updating you: none of the solutions mentioned above work for me.
Uninstalling libreoffice-gtk3 makes UI tiny and unusable.
Clicking low enough doesn't work.
>- press <tab> while pointer still on the button, that somehow changes the focus and keeps the menu open,
Doesn't work. Menu disappears.
>- a fast move down with the mouse (touchpad in my case) mostly 'catches' the menu and keeps it open,
Doesn't work. Menu disappears.
>- start typing something, the initial focus is in the search field of the menu, menu will be kept open,
Occasionally works, most often doesn't.
>'minor' as sufficient workarounds available,
They are not available (anymore?).