Bug 75059 - FILTER: Drop down menu does not work
Summary: FILTER: Drop down menu does not work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Keywords: filter:xls
Depends on:
Blocks: Form-Controls XLS
  Show dependency treegraph
Reported: 2014-02-16 16:43 UTC by Vasco Alves
Modified: 2021-04-30 22:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

File with problem (219.50 KB, application/vnd.ms-excel)
2014-02-16 16:43 UTC, Vasco Alves
Other file with same problem (409.00 KB, application/vnd.ms-excel)
2014-02-16 16:44 UTC, Vasco Alves

Note You need to log in before you can comment on or make changes to this bug.
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
Comment 13 Roman Kuznetsov 2019-02-19 07:44:23 UTC
still repro in

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