Apache OpenOffice (AOO) Bugzilla – Issue 65817
Drop Down loses its source
Last modified: 2013-08-07 15:12:27 UTC
When you import an Excel document containing a Drop Down menu ("List Box" in OOo) whose source is a named range, it comes in without a source in OpenOffice. The problem seems to be that OpenOffice doesn't allow a name to be the "Source cell range" of a form control, which is why it can't import them. Unfortunately, I can't figure out where that would go in this bug system. Sorry.
Created attachment 36756 [details] Three drop downs linked to the same cells in different ways.
It doesn't allow a name to be the "Linked cell" either. (The attached file shows that too.)
Hi, as it has never worked, it's not a defect but an enhancement request. Re-flagged and re-assigned to requirements.
*** Issue 69768 has been marked as a duplicate of this issue. ***