Bug 147096 - XLSX - Calc validity dropdown selection doesn't work, a range name is missing
Summary: XLSX - Calc validity dropdown selection doesn't work, a range name is missing
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-DataRange
  Show dependency treegraph
Reported: 2022-01-31 20:08 UTC by Mark Labrie
Modified: 2022-09-05 17:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

.xlsx works in office deritives, not in LibreOffice (84.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-01 18:50 UTC, Mark Labrie
range name changed (39.36 KB, image/png)
2022-08-01 21:40 UTC, raal
range name definition in excel (47.95 KB, image/png)
2022-08-01 21:41 UTC, raal

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Labrie 2022-01-31 20:08:16 UTC
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!

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
Comment 1 raal 2022-01-31 21:11:10 UTC
Please attach test file.
Comment 2 QA Administrators 2022-08-01 03:27:31 UTC Comment hidden (obsolete)
Comment 3 Mark Labrie 2022-08-01 18:50:23 UTC
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
Comment 4 raal 2022-08-01 21:40:22 UTC
Created attachment 181539 [details]
range name changed

The problem is in range name. I added range Table730 for the test and then it works.
Comment 5 raal 2022-08-01 21:41:38 UTC
Created attachment 181541 [details]
range name definition in excel
Comment 6 Mark Labrie 2022-08-01 21:52:49 UTC
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?
Comment 7 Roman Kuznetsov 2022-08-02 05:22:06 UTC
Confirm in

Version: (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