Bug 98144 - list validation menus sometimes too small
Summary: list validation menus sometimes too small
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 126807 (view as bug list)
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2016-02-24 17:20 UTC by Stéphane Aulery
Modified: 2023-05-07 16:18 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
File showing a list too small (8.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-24 17:21 UTC, Stéphane Aulery
Details
Screenshot of the file showing a list too small (170.72 KB, image/png)
2016-02-24 17:21 UTC, Stéphane Aulery
Details
screenshot (113.45 KB, image/png)
2023-05-07 16:17 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Aulery 2016-02-24 17:20:25 UTC
If I activate validation for a cell where accepted values are from a
list, the menu showing the list values is as wide as the cell itself.

There are cases, however, where this is not reasonable, and the
width should be the one of the widest list item.

In fact, when I set a cell to contain text that is longer than the
cell's width, either because the text spills over the cell on the right,
or because of text wrapping in the cell, then the text in the dropdown
menu becomes truncated and unreadable.

I do not observe this problem in Gnumeric, which, apparently, makes the
menu as wide as the widest entry in the list.
Comment 1 Stéphane Aulery 2016-02-24 17:21:00 UTC
Created attachment 122955 [details]
File showing a list too small
Comment 2 Stéphane Aulery 2016-02-24 17:21:23 UTC
Created attachment 122956 [details]
Screenshot of the file showing a list too small
Comment 3 raal 2016-02-29 20:49:33 UTC
Valid enhancement
Comment 4 Xisco Faulí 2019-09-20 11:04:03 UTC
Hi Caolán, I thought you might be interested in this issue...
If the column is too narrow, the dropdownlist isn't displayed.
Could it be possible to have a min width ?
Comment 5 Xisco Faulí 2019-09-20 11:04:28 UTC
*** Bug 126807 has been marked as a duplicate of this bug. ***
Comment 6 BogdanB 2023-05-07 16:17:24 UTC
Created attachment 187128 [details]
screenshot

In 7.6alpha, the elements from the list can be seen better than in your screenshot, and the columns is kept as it was set up.

See screenshot.

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6c042848b688f64b3c56d65dd9dc5fe85412660a
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded