Issue 60108 - Allow duplication of range names (duplicated across sheets that also copy with the sheet)
Summary: Allow duplication of range names (duplicated across sheets that also copy wit...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 82501 (view as issue list)
Depends on:
Reported: 2006-01-06 04:46 UTC by tonytarrant
Modified: 2013-02-07 22:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tonytarrant 2006-01-06 04:46:45 UTC
The range naming feature where a name may only exist once in a spreadsheet file
appears to be very limiting.

Contrast this with MS Excel where the same name can exist for a workbook and for
any number of the sheets in that same workbook (although admittedly this feature
is not trivial to use because it is not always simple to set up).

There are many times in spreadsheet modelling when it is desirable to set up
part of a model on a sheet and then replicate that sheet to represent similar
parts of the model. For example consider a report that is produced for each
division in a company and also as a company total (a very common reporting
task). This can be modelled with a company report and divisional reports each on
their respective sheets, all of which are very similar. Adding a new division
typically requires replicating an existing divisional sheet and changing some
data which is very quick and easy. Calculations can refer to company wide
(global) data from the company sheet and divisional data on the respective
divisional sheet.

When range names do not apply at the sheet level it is impossible to build the
divisional model to take advantage of the range naming features. It can not use
names in formulae that refer to divisional data. Automation that needs
divisional data would appear to be similarly limited.

In my experience, modelling situations like this occur all the time so it would
be very desirable for Calc to be able to handle them.

Comment 1 lars 2006-01-06 12:54:50 UTC
according to
RFE_issues_by_QA.sxd I reassign this issue to requirements and set the status to 
Comment 2 frank 2008-01-10 10:31:50 UTC
*** Issue 82501 has been marked as a duplicate of this issue. ***