CopyOptions Class

CopyOptions class

Represents the copy options.


type CopyOptions struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription
NewCopyOptionsCopyOptions constructor.

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
GetKeepMacrosIndicates whether keeping macros;
SetKeepMacrosIndicates whether keeping macros;
GetExtendToAdjacentRangeIndicates whether extend ranges when copying the range to adjacent range.
SetExtendToAdjacentRangeIndicates whether extend ranges when copying the range to adjacent range.
GetCopyNamesIndicates whether copying the names.
SetCopyNamesIndicates whether copying the names.
GetCopyInvalidFormulasAsValuesIf the formula is not valid for the dest destination, only copy values.
SetCopyInvalidFormulasAsValuesIf the formula is not valid for the dest destination, only copy values.
GetColumnCharacterWidthIndicates whether copying column width in unit of characters.
SetColumnCharacterWidthIndicates whether copying column width in unit of characters.
GetReferToSheetWithSameNameIn 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 namein the same workbook, such as when those worksheets have been copied before this copy operation,then this property should be kept as true.
SetReferToSheetWithSameNameIn 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 namein the same workbook, such as when those worksheets have been copied before this copy operation,then this property should be kept as true.
GetReferToDestinationSheetWhen 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.
SetReferToDestinationSheetWhen 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.