Enum 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.

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.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2023-09-28 UTC.