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: 2023-07-28 15:36 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