Description: In Calc some dropdown lists dont work. If a dropdown list is based on the dropdown selection of another field we get #REF! instead of the dropdown with the selections based on the choice of the previous field. This works in MS Office, WPS office and ONLYOFFICE but not in LibreOffice. Steps to Reproduce: 1.field on dropdown selection (example: selection "B") 2.next field click on dropdown arrow and instead of expected list get #REF! 3. Actual Results: second drop down field answers #REF! Expected Results: dropdown should show list of choices based on selection choice of prior field. Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: StartModule [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Please attach test file.
Dear Mark Labrie, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Created attachment 181536 [details] .xlsx works in office deritives, not in LibreOffice Column F is based on choice in Column D. Works in other office derivatives, but not in LibreOffice
Created attachment 181539 [details] range name changed The problem is in range name. I added range Table730 for the test and then it works.
Created attachment 181541 [details] range name definition in excel
Understand that there is an issue with the named range, however, why does it work, as is without any changes, in Excel AND in other office derivatives like ONLYOFFICE, WPS and Polaris office but not in LibreOffice?
Confirm in Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d75c5c1f61a174b3b333e9db6536ab15cc37d00b CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded
I can reproduce it in: Version: 7.4.0.2 (x64) / LibreOffice Community Build ID: 1512ce97d7ed39dce3121f7e15651fd8895f950e CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL Error is gone in: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4833c579ea4846c4fd73a1f8afdaca8e26f5295f CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL threaded