WorksheetCopyOptions Members

Allows you to define copy options when you copy data from one worksheet to another.

Constructors

Name	Description
WorksheetCopyOptions()	Initializes a new WorksheetCopyOptions class instance.

Properties

Name	Description
CopyDefinedNames	Specifies which defined names should be copied in case they contain references to non-existent worksheets.
InvalidFormulaReplacementMode	Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook.
OverwriteProtectionOnLockedWorksheet	Specifies whether to apply cell protection options of the source worksheet to cells in the protected destination worksheet.
PasteOptions	Specifies the part of data to paste from the copied worksheet into the target worksheet.
SheetMappings	Allows you to specify mappings between worksheet names in the source and destination workbooks.

Methods

Name	Description
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()	Serves as the default hash function. Inherited from Object.
GetType()	Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString()	Returns a string that represents the current object. Inherited from Object.

See Also

WorksheetCopyOptions Class

DevExpress.Spreadsheet Namespace