Enum CopyPasteType

AI-generated Key Takeaways

• CopyPasteType is used to specify the content pasted from the clipboard in Google Apps Script.

• It's an enumeration within the SpreadsheetApp class, called using SpreadsheetApp.CopyPasteType.PROPERTY.

• Options include pasting values, formulas, formats, validations, or combinations thereof, as well as only pasting column widths or conditional formatting.

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

Property	Type	Description
PASTE_NORMAL	Enum	Paste values, formulas, formats and merges.
PASTE_NO_BORDERS	Enum	Paste values, formulas, formats and merges but without borders.
PASTE_FORMAT	Enum	Paste the format only.
PASTE_FORMULA	Enum	Paste the formulas only.
PASTE_DATA_VALIDATION	Enum	Paste the data validation only.
PASTE_VALUES	Enum	Paste the values ONLY without formats, formulas or merges.
PASTE_CONDITIONAL_FORMATTING	Enum	Paste the color rules only.
PASTE_COLUMN_WIDTHS	Enum	Paste the column widths only.