Bug 148596 - Selection List can appear very wide, depending on longest string in column - odd looking
Summary: Selection List can appear very wide, depending on longest string in column - ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2022-04-14 16:51 UTC by Cor Nouws
Modified: 2025-07-28 03:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
screen shot shoeing the bug (30.16 KB, image/png)
2022-04-14 16:53 UTC, Cor Nouws
Details
test file exposing the bug (10.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-04-14 16:53 UTC, Cor Nouws
Details
Screenshot (25.25 KB, image/png)
2022-04-14 19:27 UTC, m_a_riosv
Details
situation in 740_alpha0 (432.86 KB, image/png)
2022-04-15 07:22 UTC, Cor Nouws
Details
Screenshot (24.40 KB, image/png)
2022-04-15 08:34 UTC, m_a_riosv
Details
Screenshot (24.40 KB, image/png)
2022-04-18 17:54 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2022-04-14 16:51:46 UTC
The width of a Selection List (Alt+Down) is determined by the longest string in the column.
Logic as such, but if there is one cell with a (verry) long string, it looks odd.

And if the user is not realizing what causes this (as happened me, since I didn't know the length of all strings of the past year+ ;) ) he calls the service desk.

Quite sure that this comes from bug 133160

I'll attach an image and a test file to show & help.
Comment 1 Cor Nouws 2022-04-14 16:53:16 UTC
Created attachment 179567 [details]
screen shot shoeing the bug
Comment 2 Cor Nouws 2022-04-14 16:53:49 UTC
Created attachment 179568 [details]
test file exposing the bug
Comment 3 m_a_riosv 2022-04-14 19:27:37 UTC
Created attachment 179569 [details]
Screenshot

Hi Cor, acceptable for me, with:.
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

With 7.0 it has the column wide.
With 7.1 the same look than with 7.2
Comment 4 Cor Nouws 2022-04-14 21:33:15 UTC
Hi Miguel,

Ah.. thanks for checking - and sorry that I missed this :) !
Comment 5 Cor Nouws 2022-04-15 07:22:02 UTC
Created attachment 179576 [details]
situation in 740_alpha0
Comment 6 Cor Nouws 2022-04-15 07:23:14 UTC
looking at Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 2816f498505bab01bc0f17ef0962ece663c607c9
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: nl-NL (en_US.UTF-8); UI: nl-NL
Calc: threaded

this is really not good.

See attachment.cgi?id=179576
Comment 7 m_a_riosv 2022-04-15 08:34:46 UTC
Created attachment 179580 [details]
Screenshot

Looks fine for me, with or without skya.
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: a98971ac975e19efa2336b608506eefa85ce2485
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded

Maybe only Linux.
Comment 8 Aron Budea 2022-04-18 01:03:42 UTC
Actually, Cor meant the selection list that can be brought up with Alt + ⬇ (down arrow).

The change is from this commit:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=d387de2bbd23887c4340fa5fcd64eb5e5ed3cd58

author		Caolán McNamara <caolanm@redhat.com>	2021-02-10 19:52:52 +0000
committer	Adolfo Jayme Barrientos <fitojb@ubuntu.com>	2021-02-11 17:41:53 +0100

tdf#140006 don't limit dropdown width to 300pixels
Comment 9 m_a_riosv 2022-04-18 17:54:46 UTC
Created attachment 179646 [details]
Screenshot

With Alt + ⬇ (down arrow), looks fine.
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: f8e11c6480ff0005715b989a6d4e2e10a3816cf6
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded
Comment 10 Aron Budea 2022-04-19 03:23:08 UTC
Please see attachment 179567 [details], and press those buttons on one of the non-filter cells.
Comment 11 m_a_riosv 2022-04-19 20:33:32 UTC
(In reply to Aron Budea from comment #10)
> Please see attachment 179567 [details], and press those buttons on one of
> the non-filter cells.

Reproducible now With Alt + ⬇ (down arrow), down to the title column cell with the filter button.
 Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: f8e11c6480ff0005715b989a6d4e2e10a3816cf6
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded
Version: 7.3.3.1 (x64) / LibreOffice Community
Version: 7.2.7.0.0+ (x64) / LibreOffice Community
Version: 7.1.8.1 (x64) / LibreOffice Community
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); Interfaz: es-ES Calc: CL

Not in
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Comment 12 QA Administrators 2025-07-28 03:10:06 UTC
Dear Cor Nouws,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug