Issue 65817 – Drop Down loses its source

Issue 65817 - Drop Down loses its source


Summary:	Drop Down loses its source

Status:	CONFIRMED

Product:	Calc
Classification:	Application
Component:	open-import
Version:	OOo 2.0.2
Hardware:	PC Windows XP

Importance:	P3 trivial with 1 vote (vote)
Target Milestone:	---
Assigned To:	AOO issues mailing list
QA Contact:

URL:
Keywords:

Duplicates:	69768 (view as issue list)
Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-05-27 22:03 UTC by parody
Modified:	2013-08-07 15:12 UTC (History)
CC List:	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
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. ***