<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 - "Sort" Dialogue Box Too Large for Long Sort Keys"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136155">136155</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>"Sort" Dialogue Box Too Large for Long Sort Keys
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 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>minor
</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>michael.debellevue@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When the sort menu is opened, libreoffice calc will attempt to use column
headers to fill "sort key" dialogue box menu options. These menu options do
not permit wrapping or truncating text. Hence, if the column headers are too
large, then the "sort" dialogue box will be made too large to fit the user's
screen. The user is not able to resize this box, rendering sorting impossible
unless the user shortens the column header.
To be fair, excessively long column headers are probably bad practice. I
noticed this behavior when manipulating a sheet created by a google form, which
had the survey questions for column headers, and hence the column headers were
rather long. So it was something that I encountered in what I would consider
to be a "normal use" activity.
I observed this problem on the latest stable release 6.4.6 at the time of this
writing, I attempted to resolve this issue by doing a clean install of the
latest version (7.0.0 at the time of this writing), and this did not resolve
the bug. Hence, I do not believe that this is related to my user
configuration, nor that it is specific to any version of Libreoffice.
Steps to Reproduce:
1. Create a spreadsheet such that the "sort" option autofills the sort key with
a cell entry. I don't understand how the sort option decides when to do this,
but I accomplished this by creating a rectangular table of numbers with text
entries on the top row.
2. Make one of the column headers be a very long single line.
3. Select the column in question, so that "sort" will use that column's header
as its initial guess for the sort key.
4. Hit "sort" or select it from the "data" menu.
Actual Results:
Sort dialogue box has width set to the width of the column header, irrespective
of user monitor size.
Expected Results:
Window should be capped at the monitor size, or should be resizable to allow
the user to still see the entire dialogue box. Long cell entries for sort keys
should wrap
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes</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>