Issue 65817 - Drop Down loses its source
Drop Down loses its source
Status: CONFIRMED
Product: Calc
Classification: Application
Component: open-import
OOo 2.0.2
PC Windows XP
: P3 trivial with 1 vote (vote)
: ---
Assigned To: AOO issues mailing list
:
: 69768 (view as issue list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-05-27 22:03 UTC by parody
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation on: ---
Developer Difficulty: ---


Attachments
Three drop downs linked to the same cells in different ways. (15.00 KB, application/vnd.ms-excel)
2006-05-27 22:07 UTC, parody
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description parody 2006-05-27 22:03:02 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.
Comment 1 parody 2006-05-27 22:07:27 UTC
Created attachment 36756 [details]
Three drop downs linked to the same cells in different ways.
Comment 2 parody 2006-05-27 22:08:40 UTC
It doesn't allow a name to be the "Linked cell" either.  (The attached file 
shows that too.)
Comment 3 frank 2006-06-02 13:07:51 UTC
Hi,

as it has never worked, it's not a defect but an enhancement request. Re-flagged
and re-assigned to requirements.
Comment 4 frank 2006-09-22 11:20:45 UTC
*** Issue 69768 has been marked as a duplicate of this issue. ***