Bug 129861 - Drop down menu not working correctly in LibreOffice.
Summary: Drop down menu not working correctly in LibreOffice.
Status: RESOLVED DUPLICATE of bug 100374
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
Reported: 2020-01-07 14:33 UTC by dgbates2@gmail.com
Modified: 2023-02-01 22:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

the test file. (2.02 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-01-07 14:34 UTC, dgbates2@gmail.com

Note You need to log in before you can comment on or make changes to this bug.
Description dgbates2@gmail.com 2020-01-07 14:33:10 UTC
A drop down menu which causes subsequent calculation fields to alter didn't work correctly in LibreOffice SpreadSheet 'Calc?'.

Steps to Reproduce:
1.Open Spreadsheet.
2.Select drop down menu
3.Wait for the correct calculation, nothing happens.

Actual Results:
Fields also disappear from the drop down menu.

Expected Results:
Selection appears and can be selected

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 dgbates2@gmail.com 2020-01-07 14:34:56 UTC
Created attachment 156990 [details]
the test file.

go to the Climate Data sheet.
Try the drop down menu for the climate data sets.
The "Wales" cell doesn't get listed and can't be selected.
Comment 2 Roman Kuznetsov 2020-01-08 12:51:53 UTC
repro in

Версия: (x64)
ID сборки: a64200df03143b798afd1ec74a12ab50359878ed
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

form controls just don't work

but in

Версия: (x64)
ID сборки: 035c7717c135c66c0ec025500b73ae9c13b7c586
Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: по умолчанию; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

form control allows select country but linked second drop-down list shows wrong info. Possibly another problem
Comment 3 QA Administrators 2022-06-16 03:44:39 UTC Comment hidden (obsolete, spam)
Comment 4 Gabor Kelemen (allotropia) 2023-02-01 22:20:37 UTC
This is the same import problem as bug 100374: the List boxes Properties -> Data -> Contents of the linked cell setting is  "The selected entry" but it should be "Position of the selected entry".
Manually changing this setting fixes the problem.

*** This bug has been marked as a duplicate of bug 100374 ***