# GC.Spread.Sheets.ClipboardPasteOptions

## Content

# Enumeration: ClipboardPasteOptions

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

Specifies what data is pasted from the Clipboard.

**`example`**
```
//This example uses the ClipboardPasteOptions enumeration.
activeSheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
```

## Table of contents

### Enumeration members

- [all](GC.Spread.Sheets.ClipboardPasteOptions#all)
- [formatting](GC.Spread.Sheets.ClipboardPasteOptions#formatting)
- [formulas](GC.Spread.Sheets.ClipboardPasteOptions#formulas)
- [formulasAndFormatting](GC.Spread.Sheets.ClipboardPasteOptions#formulasandformatting)
- [values](GC.Spread.Sheets.ClipboardPasteOptions#values)
- [valuesAndFormatting](GC.Spread.Sheets.ClipboardPasteOptions#valuesandformatting)

## Enumeration members

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

• **all** = `0`

Pastes all data objects, including values, formatting, and formulas.

___

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

• **formatting** = `2`

Pastes only formatting.

___

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

• **formulas** = `3`

Pastes only formulas.

___

### <a id="formulasandformatting" name="formulasandformatting"></a> formulasAndFormatting

• **formulasAndFormatting** = `5`

Pastes formulas and formatting.

___

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

• **values** = `1`

Pastes only values.

___

### <a id="valuesandformatting" name="valuesandformatting"></a> valuesAndFormatting

• **valuesAndFormatting** = `4`

Pastes values and formatting.