Bug 122084 - Autofilter menu disappears as I move the pointer if Display zoom set to 200% in Ubuntu Settings for HiDPI monitor
Summary: Autofilter menu disappears as I move the pointer if Display zoom set to 200% ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 122568 (view as bug list)
Depends on:
Blocks: HiDPI AutoFilter
  Show dependency treegraph
 
Reported: 2018-12-13 21:25 UTC by michael
Modified: 2023-06-04 23:32 UTC (History)
13 users (show)

See Also:
Crash report or crash signature:


Attachments
Has AutoFilter in Calc (7.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-12-13 21:31 UTC, michael
Details
Short video depicting the behaviour (166.10 KB, video/mp4)
2020-01-31 10:49 UTC, Kalin KOZHUHAROV
Details

Note You need to log in before you can comment on or make changes to this bug.
Description michael 2018-12-13 21:25:09 UTC
Description:
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

Actual Results:
Menu closes when mouse moves

Expected Results:
Menu should stay open


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Comment 1 michael 2018-12-13 21:31:06 UTC
Created attachment 147510 [details]
Has AutoFilter in Calc
Comment 2 Durgapriyanka 2018-12-14 16:48:31 UTC
Thank you for reporting the bug. I can not reproduce the bug in

Version: 6.1.3.2
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

Version: 6.3.0.0.alpha0+
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
Calc: threaded

Menu stays open and I'm able to select the filter options.
Comment 3 michael 2018-12-14 17:32:39 UTC
Might be a Linux version problem. Any ideas about how to debug?
Comment 4 michael 2018-12-14 17:49:40 UTC
OK, I found a work around.

Right click on the triangele icon and select "Selection List", then the menu stay open.
Comment 5 Roman Kuznetsov 2018-12-16 19:28:34 UTC Comment hidden (obsolete)
Comment 6 michael 2018-12-16 19:42:55 UTC
Ubuntu 18.04 (64 bit) new installation with latest updates. Installation from Ubuntu 18.04.1 bootable USB dongle. LO Version: 6.0.6.2.

Also present after adding PPA for LibreOffice fresh (http://ppa.launchpad.net/libreoffice/ppa/ubuntu). LO Version: 6.1.3.2

Seen on two different computers (desktop and laptop).
Comment 7 Roman Kuznetsov 2018-12-16 20:05:06 UTC Comment hidden (obsolete)
Comment 8 michael 2018-12-17 19:41:55 UTC
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.
Comment 9 simon 2019-01-13 09:20:44 UTC
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.
Comment 10 Buovjaga 2019-01-25 19:18:31 UTC
NEW per last comment.
Comment 11 Dave Deaven 2019-01-26 18:42:11 UTC
Reproduced on OpenSUSE Leap 42.3

libreoffice-calc            
Version        : 6.1.3.2-27.4 

libreoffice-base            
Version        : 6.1.3.2-27.4
Comment 12 Mohammad Alhashash 2019-02-11 06:15:12 UTC
Same issue on Fedora 29 x86-64 HiDPI (3840x2160).
Comment 13 swt 2019-02-20 00:25:20 UTC
*** Bug 122568 has been marked as a duplicate of this bug. ***
Comment 14 Stéphane Aulery 2019-05-13 12:32:53 UTC
From: Matijs van Zuijlen <matijs@matijs.net>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: libreoffice-gtk3: Filter drop-down in Calc closes too soon with Gtk3 rendering
Date: Tue, 07 Aug 2018 13:55:29 +0200

Package: libreoffice-gtk3
Version: 1:6.1.0~rc2-2
Severity: normal

Dear maintainer,

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.

Kind regards,
Matijs
Comment 15 Helder Guerreiro 2019-08-16 11:16:39 UTC
I'm able to reproduce this in LibreOffice 6.3.0.4 running Kubuntu 19.04. I do have HiDPI monitors.
Comment 16 Javier Acosta 2019-10-01 16:55:33 UTC
I can reproduce this on LibreOffice 6.3.0.4 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.
Comment 17 Roman Kuznetsov 2019-10-01 17:05:13 UTC
Don't change earlier version to later if there was confirming there
Comment 18 Kalin KOZHUHAROV 2020-01-31 10:49:02 UTC
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 6.3.4.2.0 30(Build:2)
(this comes from app-office/libreoffice-6.3.4.2 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.
Comment 19 Gene Wood 2020-04-20 16:40:51 UTC
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
libreoffice-calc 6.0.7-0ubuntu0.18.04.10

I'm on a HiDPI display with 200% scaling.

Really appreciate the workaround mentioned in Comment 4
Comment 20 b. 2020-05-17 17:49:43 UTC
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, 

very annoying, 

additional workarounds: 

- 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, 

tested with: 
Version: 7.0.0.0.alpha1
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
Calc: threaded
Comment 21 yngvix 2021-06-03 03:08:27 UTC
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?).
Comment 22 QA Administrators 2023-06-04 03:15:55 UTC Comment hidden (obsolete)
Comment 23 michael 2023-06-04 10:15:30 UTC
Seems to work now in: Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
Comment 24 simon 2023-06-04 23:32:43 UTC
Works for me now too. Details:

> Version: 7.3.7.2 / LibreOffice Community
> Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.2