GrapeCity.Documents.Excel.PasteOption.PasteType

PasteType Property

PasteType

Gets or sets the paste type that is applied during a range copy operation.

Use this property with Copy(IRange, PasteOption) to inspect or reuse the current paste configuration. A new PasteOption instance returns a set containing Formulas and Formats by default.

Declaration

public PasteType PasteType { get; set; }

Public Property PasteType As PasteType

Examples

worksheet.Range["A1"].Formula = "=1+1";
worksheet.Range["A1"].Interior.Color = Color.Yellow;

PasteOption option = new PasteOption();
option.PasteType = PasteType.Values;
worksheet.Range["A1"].Copy(worksheet.Range["B1"], option);
PasteType pasteType = option.PasteType;