Bug 136155

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