Issue 82114 - Create multiple copies of a sheet and name them
Summary: Create multiple copies of a sheet and name them
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:
Keywords: oooqa
Depends on:
Reported: 2007-09-30 15:57 UTC by raindrops
Modified: 2013-12-27 12:37 UTC (History)
3 users (show)

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

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

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
As a workaround the macro "MultiPages" from
<> 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.


Comment 4 oc 2008-07-15 10:43:29 UTC
reassigning features and enhancements to user 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.