Created attachment 202131 [details] How it looks in Excel and Calc This is related to bug 167764 The example file attachment 202128 [details] has two dropdown list boxes, and the input range for these is given as a named cell range (Days), and a named range (Weekends) specified by a trivial formula referring to the other named range (Days). When opened in Calc, the simple named range gets converted into a static cell range reference and works like in Excel. But the one given with a simple formula gets converted into A1, and it does not show the same set of elements. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61 CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded
Created attachment 202132 [details] Listbox Properties dialog, when trying to create something similar from scratch In Calc it is not supported to add a named range as form control Source cell range.
Created attachment 202133 [details] Simple reproducer made in Calc Selecting the control, right click -> Control Properties, Data tab, try to set "Days" in the "Source cell range" -> this is not allowed.