To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60108 Issue #:|60108 Summary:|Allow duplication of range names (duplicated across |sheets that also copy with the sheet) Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|FEATURE Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|tonytarrant
------- Additional comments from [EMAIL PROTECTED] Thu Jan 5 20:46:45 -0800 2006 ------- 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. TT. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
