PasteType

PasteType enumeration

Represents the paste special type.

Values

NameValueDescription
All0Copies all data of the range.
Default1It works as “All” behavior of MS Excel.
AllExceptBorders2Copies all data of the range without the range.
DefaultExceptBorders3It works as “All except borders” behavior of MS Excel.
ColumnWidths4Only copies the widths of the range.
RowHeights5Only copies the heights of the range.
Comments6
Formats7
Formulas8
FormulasAndNumberFormats9
Validation10
Values11
ValuesAndFormats12
ValuesAndNumberFormats13