https://bugs.documentfoundation.org/show_bug.cgi?id=167765
Bug ID: 167765
Summary: FILEOPEN XLSX Dropdown form control input range does
not support named range given with formula
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 133999
Created attachment 202131
--> https://bugs.documentfoundation.org/attachment.cgi?id=202131&action=edit
How it looks in Excel and Calc
This is related to bug 167764
The example file attachment 202128 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
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=133999
[Bug 133999] [META] XLSX (OOXML) Form Controls related issues
--
You are receiving this mail because:
You are the assignee for the bug.
