# GC.Spread.Sheets.PasteOperationOptions

## Content

# Enumeration: PasteOperationOptions

[Spread](../modules/GC.Spread).[Sheets](../modules/GC.Spread.Sheets).PasteOperationOptions

Specifies the operation options mathematically combine values between the copy and paste ranges

**`example`**
```javascript
//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](GC.Spread.Sheets.PasteOperationOptions#add)
- [divide](GC.Spread.Sheets.PasteOperationOptions#divide)
- [multiply](GC.Spread.Sheets.PasteOperationOptions#multiply)
- [none](GC.Spread.Sheets.PasteOperationOptions#none)
- [subtract](GC.Spread.Sheets.PasteOperationOptions#subtract)
- [transform](GC.Spread.Sheets.PasteOperationOptions#transform)

## Enumeration members

### <a id="add" name="add"></a> add

• **add** = `1`

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

___

### <a id="divide" name="divide"></a> divide

• **divide** = `4`

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

___

### <a id="multiply" name="multiply"></a> multiply

• **multiply** = `3`

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

___

### <a id="none" name="none"></a> none

• **none** = `0`

Paste the contents of the copy ranges without an operation.

___

### <a id="subtract" name="subtract"></a> subtract

• **subtract** = `2`

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

___

### <a id="transform" name="transform"></a> transform

• **transform** = `5`

Transform the values in the paste ranges by the formula in the copy ranges.