[]
        
(Showing Draft Content)

GC.Spread.Sheets.PasteOperationOptions

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

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.