[]
Spread.Sheets.PasteOperationOptions
Specifies the operation options mathematically combine values between the copy and paste ranges
example
//This example uses the PasteOperationOptions enumeration.
activeSheet.getCell(0,0).value("1");
activeSheet.setSelection(0, 0, 1, 1);
spread.commandManager().execute({cmd:"copy", sheetName: activeSheet.name()});
activeSheet.setSelection(0, 0, 3, 3);
spread.commandManager().execute(
{
cmd:"paste",
sheetName: activeSheet.name(),
pasteSpecialOptions: {
operationOptions: GC.Spread.Sheets.PasteOperationOptions.add
}
}
);
• add = 1
Add the values in the copy ranges to the values in the paste ranges.
• divide = 4
Divide the values in the paste ranges by the values in the copy ranges.
• multiply = 3
Multiply the values in the paste ranges by the values in the copy ranges.
• none = 0
Paste the contents of the copy ranges without an operation.
• subtract = 2
Subtract the values in the copy ranges from the values in the paste ranges.