# GC.Spread.Sheets.CopyPasteHeaderOptions

## Content

# Enumeration: CopyPasteHeaderOptions

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

Specifies which headers are included when data is copied to or pasted.

**`example`**
```
//This example allows you to copy and paste headers.
spread.options.copyPasteHeaderOptions = GC.Spread.Sheets.CopyPasteHeaderOptions.allHeaders;
activeSheet.setRowCount(2,GC.Spread.Sheets.SheetArea.colHeader);
activeSheet.setColumnCount(2,GC.Spread.Sheets.SheetArea.rowHeader);
activeSheet.setValue(0, 2,"Column",GC.Spread.Sheets.SheetArea.colHeader);
activeSheet.setValue(1, 0,"Row",GC.Spread.Sheets.SheetArea.rowHeader);
```

## Table of contents

### Enumeration members

- [allHeaders](GC.Spread.Sheets.CopyPasteHeaderOptions#allheaders)
- [columnHeaders](GC.Spread.Sheets.CopyPasteHeaderOptions#columnheaders)
- [noHeaders](GC.Spread.Sheets.CopyPasteHeaderOptions#noheaders)
- [rowHeaders](GC.Spread.Sheets.CopyPasteHeaderOptions#rowheaders)

## Enumeration members

### <a id="allheaders" name="allheaders"></a> allHeaders

• **allHeaders** = `3`

Includes selected headers when data is copied; overwrites selected headers when data is pasted.

___

### <a id="columnheaders" name="columnheaders"></a> columnHeaders

• **columnHeaders** = `2`

Includes selected column headers when data is copied; overwrites selected column headers when data is pasted.

___

### <a id="noheaders" name="noheaders"></a> noHeaders

• **noHeaders** = `0`

Includes neither column nor row headers when data is copied; does not overwrite selected column or row headers when data is pasted.

___

### <a id="rowheaders" name="rowheaders"></a> rowHeaders

• **rowHeaders** = `1`

Includes selected row headers when data is copied; overwrites selected row headers when data is pasted.