Issue 65817

Summary: Drop Down loses its source
Product: Calc Reporter: parody <parody>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: daniel.rentz, eva-email, issues
Version: OOo 2.0.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Three drop downs linked to the same cells in different ways. none

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. ***