PasteType enumeration

Represents the paste special type.

public enum PasteType


Name Value Description
All 0 Copies all data of the range.
Default 1 It works as “All” behavior of MS Excel.
AllExceptBorders 2 Copies all data of the range without the range.
DefaultExceptBorders 3 It works as “All except borders” behavior of MS Excel.
ColumnWidths 4 Only copies the widths of the range.
RowHeights 5 Only copies the heights of the range.
Comments 6
Formats 7
Formulas 8
FormulasAndNumberFormats 9
Validation 10
Values 11
ValuesAndFormats 12
ValuesAndNumberFormats 13

See Also