CopyOptions class

CopyOptions class

Represents the copy options.

The CopyOptions type exposes the following members:


initCopyOptions constructor.


keep_macrosIndicates whether keeping macros;
extend_to_adjacent_rangeIndicates whether extend ranges when copying the range to adjacent range.
copy_namesIndicates whether copying the names.
copy_invalid_formulas_as_valuesIf the formula is not valid for the dest destination, only copy values.
column_character_widthIndicates whether copying column width in unit of characters.
refer_to_sheet_with_same_nameIn ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one,
the copied formulas should refer to source workbook.
However, for some situations user may need the copied formulas refer to worksheets with the same name
in the same workbook, such as when those worksheets have been copied before this copy operation,
then this property should be kept as true.
refer_to_destination_sheetWhen copying the range in the same file and the chart refers to the source sheet,
False means the copied chart’s data source will not be changed.
True means the copied chart’s data source refers to the destination sheet.

See Also