PasteType enumeration

PasteType enumeration

Represents the paste special type.

The PasteType type exposes the following members:

Fields

FieldDescription
ALLCopies all data of the range.
DEFAULTIt works as “All” behavior of MS Excel.
ALL_EXCEPT_BORDERSCopies all data of the range without the range.
DEFAULT_EXCEPT_BORDERSIt works as “All except borders” behavior of MS Excel.
COLUMN_WIDTHSOnly copies the widths of the range.
ROW_HEIGHTSOnly copies the heights of the range.
COMMENTSOnly copies comments in the range.
FORMATSOnly copies formats in the range.
FORMULASOnly copies formulas in the range.
FORMULAS_AND_NUMBER_FORMATSOnly copies formulas and number formats in the range.
VALIDATIONOnly copies validations in the range.
VALUESOnly copies values in the range.
VALUES_AND_FORMATSOnly copies values and formats in the range.
VALUES_AND_NUMBER_FORMATSOnly copies values and number formats in the range.

See Also