Enumeration: PasteOperationOptions

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
        }
    }
);

Table of contents

Enumeration members

• add
• divide
• multiply
• none
• subtract

Enumeration members

add

• add = 1

Add the values in the copy ranges to the values in the paste ranges.

divide

• divide = 4

Divide the values in the paste ranges by the values in the copy ranges.

multiply

• multiply = 3

Multiply the values in the paste ranges by the values in the copy ranges.

none

• none = 0

Paste the contents of the copy ranges without an operation.

subtract

• subtract = 2

Subtract the values in the copy ranges from the values in the paste ranges.