Create a second copy of the current spreadsheet, optionally changing the
spreadsheet type and column names.
Spreadsheet Type
This controls the new type of the resulting spreadsheet. The spreadsheet on
duplication can be converted to a new type. So, for example a matrix
spreadsheet could be changed to a vector spreadsheet type.
Create Unique Column Names
If checked, the column names in the new spreadsheet will be created with
unique names so that they are different to the existing column names.
Only duplicate selected data
If checked, only the selected columns are used when creating the new
spreadsheet. This provides a simple way of forming a subset from the columns
of the current spreadsheet.
Set as Active Sheet
Sets the newly created spreadsheet to be the active spreadsheet.
See setting an active spreadsheet for more details.
Add to Book
This provides a list of books that the new
spreadsheet can be added to. The default book that spreadsheets are added to
can be specified using the
Spreadsheet Options - Books menu.
Action Buttons
OK
Create a duplaicte spreadsheet and close the dialog.