ContextQMD
Back to Devexpress

WorksheetCopyOptions Properties

officefileapi-devexpress-dot-spreadsheet-dot-worksheetcopyoptions-dot-underscore-properties.md

latest1.5 KB
Original Source

WorksheetCopyOptions Properties

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

NameDescription
CopyDefinedNamesSpecifies which defined names should be copied in case they contain references to non-existent worksheets.
InvalidFormulaReplacementModeSpecifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook.
OverwriteProtectionOnLockedWorksheetSpecifies whether to apply cell protection options of the source worksheet to cells in the protected destination worksheet.
PasteOptionsSpecifies the part of data to paste from the copied worksheet into the target worksheet.
SheetMappingsAllows you to specify mappings between worksheet names in the source and destination workbooks.

See Also

WorksheetCopyOptions Class

WorksheetCopyOptions Members

DevExpress.Spreadsheet Namespace