# 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`**
```javascript
//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)
- [allAndColumnWidth](GC.Spread.Sheets.ClipboardPasteOptions#allandcolumnwidth)
- [columnWidths](GC.Spread.Sheets.ClipboardPasteOptions#columnwidths)
- [comments](GC.Spread.Sheets.ClipboardPasteOptions#comments)
- [formatting](GC.Spread.Sheets.ClipboardPasteOptions#formatting)
- [formulas](GC.Spread.Sheets.ClipboardPasteOptions#formulas)
- [formulasAndFormatting](GC.Spread.Sheets.ClipboardPasteOptions#formulasandformatting)
- [formulasAndNumberFormatting](GC.Spread.Sheets.ClipboardPasteOptions#formulasandnumberformatting)
- [noBorder](GC.Spread.Sheets.ClipboardPasteOptions#noborder)
- [usingSourceTheme](GC.Spread.Sheets.ClipboardPasteOptions#usingsourcetheme)
- [validation](GC.Spread.Sheets.ClipboardPasteOptions#validation)
- [values](GC.Spread.Sheets.ClipboardPasteOptions#values)
- [valuesAndFormatting](GC.Spread.Sheets.ClipboardPasteOptions#valuesandformatting)
- [valuesAndNumberFormatting](GC.Spread.Sheets.ClipboardPasteOptions#valuesandnumberformatting)
- [valuesAndSourceFormatting](GC.Spread.Sheets.ClipboardPasteOptions#valuesandsourceformatting)

## Enumeration members

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

• **all** = `0`

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

___

### <a id="allandcolumnwidth" name="allandcolumnwidth"></a> allAndColumnWidth

• **allAndColumnWidth** = `14`

Pastes all data objects and keep column width

___

### <a id="columnwidths" name="columnwidths"></a> columnWidths

• **columnWidths** = `10`

Pastes the column widths.

___

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

• **comments** = `6`

Pastes only comments.

___

### <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="formulasandnumberformatting" name="formulasandnumberformatting"></a> formulasAndNumberFormatting

• **formulasAndNumberFormatting** = `11`

Paste formulas and number formatting options

___

### <a id="noborder" name="noborder"></a> noBorder

• **noBorder** = `9`

Pastes all cell contents except borders.

___

### <a id="usingsourcetheme" name="usingsourcetheme"></a> usingSourceTheme

• **usingSourceTheme** = `8`

Paste all data object and apply source theme to style/

___

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

• **validation** = `7`

Paste only validation.

___

### <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.

___

### <a id="valuesandnumberformatting" name="valuesandnumberformatting"></a> valuesAndNumberFormatting

• **valuesAndNumberFormatting** = `12`

Paste values and number formatting options

___

### <a id="valuesandsourceformatting" name="valuesandsourceformatting"></a> valuesAndSourceFormatting

• **valuesAndSourceFormatting** = `13`

Paste values and source formatting options