CopyOptions
CopyOptions class
Represents the copy options.
Constructors
| Name | Description |
|---|---|
| CopyOptions | CopyOptions constructor. |
Properties
| Name | Type | Description |
|---|---|---|
| KeepMacros | boolean | Indicates whether keeping macros; Only for copying workbook. |
| ExtendToAdjacentRange | boolean | Indicates whether extend ranges when copying the range to adjacent range. If it’s true, only extends the range of the hy |
| CopyNames | boolean | Indicates whether copying the names. |
| CopyInvalidFormulasAsValues | boolean | If the formula is not valid for the dest destination, only copy values. |
| ColumnCharacterWidth | boolean | Indicates whether copying column width in unit of characters. |
| ReferToSheetWithSameName | boolean | In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied |
| ReferToDestinationSheet | boolean | When copying the range in the same file and the chart refers to the source sheet, False means the copied chart’s data so |
| UpdateInvalidReferencesToTargetSheet | boolean |
CopyOptions()
CopyOptions constructor.
CopyOptions.KeepMacros property
Indicates whether keeping macros; Only for copying workbook.
Type: boolean
CopyOptions.ExtendToAdjacentRange property
Indicates whether extend ranges when copying the range to adjacent range. If it’s true, only extends the range of the hyperlink,not adding a new hyperlink when copying hyperlinks to adjacent rows.
Type: boolean
CopyOptions.CopyNames property
Indicates whether copying the names.
Type: boolean
CopyOptions.CopyInvalidFormulasAsValues property
If the formula is not valid for the dest destination, only copy values.
Type: boolean
CopyOptions.ColumnCharacterWidth property
Indicates whether copying column width in unit of characters.
Type: boolean
CopyOptions.ReferToSheetWithSameName property
In 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. The default value is true.
Type: boolean
CopyOptions.ReferToDestinationSheet property
When 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. The default value is false, it works as MS Excel.
Type: boolean
CopyOptions.UpdateInvalidReferencesToTargetSheet property
Type: boolean