officefileapi-devexpress-dot-spreadsheet-dot-copiedrangepastingeventargs-2ace49d1.md
Gets or sets the part of copied data to be pasted into target range.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public PasteSpecial PasteSpecialFlags { get; set; }
Public Property PasteSpecialFlags As PasteSpecial
| Type | Description |
|---|---|
| PasteSpecial |
A PasteSpecial enumeration member.
|
Available values:
| Name | Description |
|---|---|
| Formulas |
Pastes cell constant values (for example, text, numbers, and so on) and formulas (but not their calculated values).
| | Values |
Pastes cell values only (including values calculated from formulas, but not formulas themselves).
| | NumberFormats |
Pastes cell number formats only.
| | Borders |
Pastes cell borders only.
| | Formats |
Pastes cell formatting only (font, background, alignment, number format, and borders).
| | Comments |
Pastes cell comments only.
| | ColumnWidths |
Applies column widths only.
| | DataValidations |
Pastes only data validation rules applied to copied cells.
| | Hyperlinks |
Pastes hyperlinks only (without display text).
| | All |
Pastes all cell data (formulas, values, and formatting) except column widths.
|
Use the PasteSpecialFlags property to specify which parts of the copied data (for example, value only, formatting information only, borders only, etc.) should be pasted into the destination cells.
See Also
CopiedRangePastingEventArgs Class