Enum CopyPasteType

CopyPasteType

An enumeration of possible special paste types.

To call an enum, you call its parent class, name, and property. For example, SpreadsheetApp.CopyPasteType.PASTE_NORMAL.

Properties

PropertyTypeDescription
PASTE_NORMALEnumPaste values, formulas, formats and merges.
PASTE_NO_BORDERSEnumPaste values, formulas, formats and merges but without borders.
PASTE_FORMATEnumPaste the format only.
PASTE_FORMULAEnumPaste the formulas only.
PASTE_DATA_VALIDATIONEnumPaste the data validation only.
PASTE_VALUESEnumPaste the values ONLY without formats, formulas or merges.
PASTE_CONDITIONAL_FORMATTINGEnumPaste the color rules only.
PASTE_COLUMN_WIDTHSEnumPaste the column widths only.