Issue 82114 - Create multiple copies of a sheet and name them
Summary: Create multiple copies of a sheet and name them
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.0 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-09-30 15:57 UTC by raindrops
Modified: 2013-12-27 12:37 UTC (History)
3 users (show)

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

Attachments
Sample shows where to add this control (31.14 KB, application/vnd.oasis.opendocument.text)
2007-09-30 15:58 UTC, raindrops 		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 raindrops 2007-09-30 15:57:43 UTC 
Sometimes, it is necessary to copy a sheet multiple times. 

For example, first create an empty template on a sheet, copy the sheet multiple
times and then fill individual data in each sheet.

But currently Calc does not have this facility.

It can either insert n new sheets, or insert a sheet from another file.
But it cannot insert n copies of a specified sheet.

See attached sample.

Please provide this facility.
Comment 1 raindrops 2007-09-30 15:58:19 UTC 
Created attachment 48616 [details]
Sample shows where to add this control
Comment 2 Rainer Bielefeld 2007-09-30 16:35:38 UTC 
@raindrops:
As a workaround the macro "MultiPages" from
<http://www.ooomacros.org/user.php#169339> might be useful for you?
Comment 3 raindrops 2007-10-01 04:57:28 UTC 
Yes. That is exactly what I wanted: The macro lets the user specify a naming
pattern for newly created worksheets.

Thanks!
Comment 4 oc 2008-07-15 10:43:29 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 5 Edwin Sharp 2013-12-27 12:37:39 UTC 
Macro in comment 2 (no longer available) should be incorporated into OpenOffice Macros Library and be mentioned in Help.