[Libreoffice-bugs] [Bug 136155] New: "Sort" Dialogue Box Too Large for Long Sort Keys

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136155

            Bug ID: 136155
           Summary: "Sort" Dialogue Box Too Large for Long Sort Keys
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: michael.debellevue at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200826/5bc8af5e/attachment-0001.htm>