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