<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - "Ranges containing merged cells…" modal dialog underlays Autofilter pull-down"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127168">127168</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>"Ranges containing merged cells…" modal dialog underlays Autofilter pull-down
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>psychonaut@nothingisreal.com
</td>
</tr></table>
<p>
<div>
<pre>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 <a class="bz_bug_link
bz_status_NEW "
title="NEW - Remove merged cell restriction on sorting"
href="show_bug.cgi?id=85807">Bug 85807</a>. 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>