Enum CopyPasteType
Page Summary
CopyPasteType is an enumeration of possible special paste types.
To call an enum, you call its parent class, name, and property.
Properties include options like pasting values, formulas, formats, and more, with variations like excluding borders or pasting only specific elements.
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. |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-11 UTC.