Issue 65817 - Drop Down loses its source
Summary: Drop Down loses its source
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 69768 (view as issue list)
Depends on:
Blocks:
 
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 in: ---
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
Add an attachment (proposed patch, testcase, etc.)

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