CopiedRangePastingEventArgs.PasteSpecialFlags Property

Gets or sets the part of copied data to be pasted into target range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public PasteSpecial PasteSpecialFlags { get; set; }

VB.NET

Public Property PasteSpecialFlags As PasteSpecial

Property Value

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.

Remarks

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.