[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Tables
   [Expand]Charts and Graphics
   [Expand]Mail Merge
    Operation Restrictions
    Find and Replace
   [Collapse]Visual Elements
     Name Box
     Pop-Up Menus
      Format Cells Dialog
      Paste Special Dialog
      Edit Hyperlink Dialog
      Symbol Dialog
      Create Table Dialog
      Change Chart Type Dialog
      Find and Replace Dialog
      Encrypt Document Dialog
      Password Dialog
      Protect Workbook Dialog
      Protect Sheet Dialog
      User Permissions Dialog
      Insert Function Dialog
      Function Arguments Dialog
      Name Manager
      New Name Dialog
      Create Names from Selection Dialog
      Subtotal Dialog
      Data Validation Dialog
      Properties Dialog
      Page Setup Dialog
      Header and Footer Dialog
      Create PivotTable Dialog
      Move PivotTable Dialog
      Change PivotTable Data Source Dialog
      PivotTable Field List
      PivotTable Field Settings Dialog
      PivotTable Value Field Settings Dialog
      PivotTable Sort Dialog
      Insert Calculated Field Dialog
      Insert Calculated Item Dialog
      PivotTable Solve Order Dialog
      PivotTable Options Dialog
      New Formatting Rule Dialog
      Conditional Formatting Rules Manager
   [Expand]Keyboard Shortcuts
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Paste Special Dialog

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.

Is this topic helpful?​​​​​​​