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
| 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 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["`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."]]],[]]
