Issue 15604

Summary: Named ranges conflicts
Product: Calc Reporter: fmcantu <fmcantu>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 1.1 Beta2Keywords: rfe_eval_ok
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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