CopyPasteProperties.CopyPasteType

All

Copies all currently supported types, except for row height and column width. Note: The behavior of All may change in the future as additional features are added to the CopyPaste method.

AllPlusRowHeightAndColumnWidth

Copies all currently supported types, including row height and column width. Note: If you call CopyPaste multiple times on the same worksheet, using this setting may have undesired results.

FormulasAndFormatting

Copy formulas and cell and number formatting.

None

Copies nothing. You must then set the behavior of CopyPaste by setting individual properties on the CopyPasteProperties object before calling the CopyPaste method.

ValuesAndFormatting

Copy cell values and cell and number formatting.

ValuesFormulasAndFormatting

Copy cell values, formulas, and cell and number formatting.

ValuesOnly

Copy only cell values.