Bug 75059

Summary: FILTER: Drop down menu does not work
Product: LibreOffice Reporter: Vasco Alves <vascofalves>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: miguelangelrv
Priority: medium Keywords: filter:xls
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=50716
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107742, 109072    
Attachments: File with problem
Other file with same problem

Description Vasco Alves 2014-02-16 16:43:20 UTC 
Created attachment 94166 [details]
File with problem

Sorry if this isn't the right keyword. 

1. Open attached file (found here: http://www.isdscotland.org/Health-Topics/General-Practice/Publications/data-tables.asp?id=1191#1191 ) 
2. Open sheet 2 (market TAB1). There should have been two working drop down menus allowing to change parameters displayed in table. Instead, when you click either menu, it appears empty, and you can't change anything.
Comment 1 Vasco Alves 2014-02-16 16:44:48 UTC 
Created attachment 94167 [details]
Other file with same problem
Comment 2 m_a_riosv 2014-02-18 23:19:45 UTC 
Hi Vasco, thanks for reporting.

I can reproduce the issue with all LibreOffice version, seems it is inherited from OOo.

The issue is that the source cell range for the List Box control it is not imported.

If you now what range must be, you can solve the issue.
Comment 3 Vasco Alves 2014-02-20 15:58:34 UTC 
I've never created a drop down menu like this, so I'm not sure what to look for. I have access to Excel 2010 at university. Can you tell me what you need me to look for?
Comment 4 m_a_riosv 2014-02-20 22:10:41 UTC 
I have not excel, but I can try to explain how to do in LibreOffice.
- Activate Menu/View/Toolbars/Form design.
- Click the second button to activate design mode.
- Select the drop down.
- Right click and select Control
- Select Data Tab.
- Enter in Source cell range, the range with data for select. Enter it by hand, no option for select with mouse, e.g. B12:B50
- Close control design window.
- Disable design button.
- Close the toolbar.
- I hope you have a list for select. :)
Comment 5 ign_christian 2014-07-29 07:08:52 UTC 
(In reply to comment #2)
> The issue is that the source cell range for the List Box control it is not
> imported.

Perhaps its because of Bug 50716 : Contents of the linked cell always returned to "Position of the selected entry" after filesave in XLS
Comment 6 Vasco Alves 2014-08-19 22:25:53 UTC 
This is still borked on 4.3.0
Comment 7 QA Administrators 2016-02-21 08:38:25 UTC Comment hidden (obsolete)
Comment 8 Vasco Alves 2016-02-22 08:56:15 UTC 
I can confirm the bug is still present, both in:
5.0.5 in Ubuntu 15.10 64bit and
5.1.0 in Windows 10 32 bit.
Comment 9 QA Administrators 2017-03-06 16:16:19 UTC Comment hidden (obsolete)
Comment 10 Vasco Alves 2017-05-01 09:27:42 UTC 
Can confirm bug is still present in version 5.3.2 on Ubuntu 17.04.
Comment 11 QA Administrators 2018-05-02 02:32:32 UTC Comment hidden (obsolete)
Comment 12 Vasco Alves 2018-05-17 18:26:46 UTC 
Bug still present in 6.0.4.2
Comment 13 Roman Kuznetsov 2019-02-19 07:44:23 UTC 
still repro in

Version: 6.3.0.0.alpha0+
Build ID: c57dc7d41bd62f933cffab6131edb7252606382d
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 14 QA Administrators 2021-02-19 04:23:08 UTC Comment hidden (obsolete)
Comment 15 Vasco Alves 2021-04-30 22:18:14 UTC 
Still broken
Comment 16 QA Administrators 2023-05-01 03:18:51 UTC Comment hidden (obsolete)
Comment 17 Vasco Alves 2023-05-16 10:25:45 UTC 
Bug is still present.

Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 4:7.5.3~rc2-0ubuntu0.23.04.1~lo1
Calc: threaded