Paste Special Dialog
- 2 minutes to read
The Paste Special dialog allows end-users to specify additional paste options after cutting or copying data to the Clipboard.
An end-user can specify the format of the pasted data using one of the following options available in the Paste Special dialog:
| Option | Description |
|---|---|
| All | Pastes all cell content and formatting. |
| Formulas | Pastes formulas as entered in the Formula Bar. Note that the relative cell references within the formula will be adjusted automatically to reflect the new location. |
| Values | Pastes cell values only (including the formula results, but not the formulas themselves). |
| Formats | Pastes cell formatting only. |
| Comments | Pastes only the comments added to cells. |
| All except borders | Pastes cell content and formatting without cell borders. |
| Column widths | Applies the column widths of the copied cells to another range of columns. |
| Formulas and number formats | Pastes only the formulas and number formatting options from the copied cells. |
| Values and number formats | Pastes only the values and number formatting options from the copied cells. |
| Skip blanks | Pastes the values of all cells except for empty cells. |
To provide end-users with the capability to invoke the Paste Special dialog, add the Clipboard Ribbon page group to the SpreadsheetControl. For an example on how to create a Ribbon UI, refer to the Getting Started topic.
To programmatically specify the part of the data to be pasted in the target cells, use the CellRange.CopyFrom method, which accepts a value of the PasteSpecial enumeration as a parameter. For details, refer to the How to: Copy Cell Data Only, Cell Style Only, or Cell Data with Style and How to: Copy a Row or Column examples.