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.
Created attachment 94167 [details] Other file with same problem
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.
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?
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. :)
(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
This is still borked on 4.3.0
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.