Class CopyOptions
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Represents the copy options.
public class CopyOptionsInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
CopyOptions()
CopyOptions constructor.
public CopyOptions()Properties
ColumnCharacterWidth
Indicates whether copying column width in unit of characters.
public bool ColumnCharacterWidth { get; set; }Property Value
CopyInvalidFormulasAsValues
If the formula is not valid for the dest destination, only copy values.
public bool CopyInvalidFormulasAsValues { get; set; }Property Value
CopyNames
Indicates whether copying the names.
public bool CopyNames { get; set; }Property Value
ExtendToAdjacentRange
Indicates whether extend ranges when copying the range to adjacent range.
public bool ExtendToAdjacentRange { get; set; }Property Value
Remarks
If it’s true, only extends the range of the hyperlink,not adding a new hyperlink when copying hyperlinks to adjacent rows.
KeepMacros
Indicates whether keeping macros;
public bool KeepMacros { get; set; }Property Value
Remarks
Only for copying workbook.
ReferToDestinationSheet
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.
public bool ReferToDestinationSheet { get; set; }Property Value
Remarks
The default value is false, it works as MS Excel.
ReferToSheetWithSameName
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.
public bool ReferToSheetWithSameName { get; set; }Property Value
Remarks
The default value is true.