Issue 15604 - Named ranges conflicts
Summary: Named ranges conflicts
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2003-06-13 19:32 UTC by fmcantu
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
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 fmcantu 2003-06-13 19:32:24 UTC 
When a sheet is copied to another file, all the named ranges are copied too,
even if those ranges aren't present in the sheet being copied (i.e. it copies
all the named ranges in the worksheet). Making it easy to have duplicated named
ranges, which in turn result to not being able to open the new file again.
I see two suitable steps:

1- Copy only named references which actually make reference to the sheet being
copied.

2- Inform the user of the existance of duplication in named references after
copying (if any), and give the option to choose which one will be used or to
append a suffix to the new named ranges that are duplicated.
Comment 1 oc 2003-06-25 10:32:58 UTC 
Hi Bettina,
please have a look
Comment 2 bettina.haberer 2003-12-04 18:26:53 UTC 
Summary: When a sheet is copied to another file, all the named ranges
are copied too, even if those ranges aren't present in the sheet being
copied (i.e. it copies all the named ranges in the worksheet). Making
it easy to have duplicated named ranges, which in turn result to not
being able to open the new file again. Proposed are
1. Copy only named references which actually make reference to the
sheet being copied.

2. Inform the user of the existance of duplication in named references
after copying (if any), and give the option to choose which one will
be used or to append a suffix to the new named ranges that are duplicated.
Comment 3 bettina.haberer 2010-05-21 14:44:05 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".