Description: When using the Autofilter pull-down menu to sort a column, the sort will fail if the spreadsheet contains vertically merged cells -- this is a separate issue documented in Bug 85807. The problem I am reporting is that LibreOffice reports this failure by popping up a focus-stealing modal error dialog *underneath* the Autofilter pull-down menu. This has two unfortunate consequences: 1) Depending on the placement of the pull-down menu, it can be impossible to read the error message. 2) At least on my windowing system (KDE Plasma), the modal dialog cannot be moved or resized, and steals focus not just within the LibreOffice Calc application but from all other windows. So it is basically impossible to use the computer for anything until the error dialog is dismissed, but it is not obvious how to do this as the dialog's "OK" button is hiding behind the Autofilter pull-down. You either need to blindly click on the unlabelled edges of the "OK" button or else press the Escape key. Steps to Reproduce: Also attached is a sample spreadsheet for triggering the bug. Use the following steps to reproduce: 1. Open the attached spreadsheet. 2. Activate the Autofilter pull-down menu in cell A1. 3. Select "Sort Ascending" or "Sort Descending". Actual Results: 4. The above-described focus-stealing modal error dialog pops up underneath the pull-down menu. Attached is a screenshot showing what the problematic behaviour looks like. Expected Results: 4. The modal error dialog should pop up *over* the pull-down menu, and it should not steal focus from other programs. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 6.3.0.4 Build ID: 30(Build:4) CPU threads: 12; OS: Linux 5.2; UI render: default; VCL: gtk3; Locale: en-GB (en_CA.UTF-8); UI-Language: en-US Calc: threaded I am running LibreOffice from openSUSE Tumbleweed (x86_64) packages. My windowing system is as follows: KDE Plasma Version: 5.16.4 KDE Frameworks Version: 5.61.0 Qt Version: 5.13.0
Created attachment 153666 [details] Screenshot showing bug
Created attachment 153667 [details] Sample spreadsheet for reproducing bug
Solving Bug 85807 would end up solving this issue as a side-effect.
I can confirm with Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) and Version: 6.4.0.0.alpha0+ Build ID: 2bed8af91fc2654b9ed2432f969d32d5741a529b CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
@Caolán, I thought you might be interested in this issue...
If we dismiss the menu before executing the sort, rather than after as it currently stands, the issue wouldn't arise
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/2d2b08eb1c63e1d12d2dd12abf97e34f56e921c6%5E%21 Resolves: tdf#127168 dismiss menu before executing sort It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
backport to 6-3 in gerrit
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/6aade14148e3d56706b074392ca3569b2a2a8376%5E%21 Resolves: tdf#127168 dismiss menu before executing sort It will be available in 6.3.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.