Skip to main content
Row

CopiedRangePastingEventArgs.PasteSpecialFlags Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

public PasteSpecial PasteSpecialFlags { get; set; }

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.

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.

See Also