Pastes the Range object to the specified range using the special paste options.
| Name | Type | Default | Description |
| sPasteType | PasteType | "xlPasteAll" | Paste option. |
| sPasteSpecialOperation | PasteSpecialOperation | "xlPasteSpecialOperationNone" | The mathematical operation which will be applied to the copied data. |
| bSkipBlanks | boolean | [bSkipBlanks=false] - Specifies whether to avoid replacing values in the paste area when blank cells occur in the copy area. |
|
| bTranspose | boolean | [bTranspose=false] - Specifies whether the pasted data will be transposed from rows to columns. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1");
var oDestRange = oWorksheet.GetRange("A2");
oRange.SetValue(1);
oDestRange.SetValue(2);
oRange.Copy();
oDestRange.PasteSpecial("xlPasteValues", "xlPasteSpecialOperationAdd", false, false);
builder.SaveFile("xlsx", "PasteSpecial.xlsx");
builder.CloseFile();