PasteType
PasteType enumeration
Represents the paste special type.
Values
| 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 | Only copies comments in the range. |
| Formats | 7 | Only copies formats in the range. |
| Formulas | 8 | Only copies formulas in the range. |
| FormulasAndNumberFormats | 9 | Only copies formulas and number formats in the range. |
| Validation | 10 | Only copies validations in the range. |
| Values | 11 | Only copies values in the range. |
| ValuesAndFormats | 12 | Only copies values and formats in the range. |
| ValuesAndNumberFormats | 13 | Only copies values and number formats in the range. |