CopyPasteHeaderOptions Enumeration

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

Members

Member	Description
allHeaders	Includes selected headers when data is copied; overwrites selected headers when data is pasted.
columnHeaders	Includes selected column headers when data is copied; overwrites selected column headers when data is pasted.
noHeaders	Includes neither column nor row headers when data is copied; does not overwrite selected column or row headers when data is pasted.
rowHeaders	Includes selected row headers when data is copied; overwrites selected row headers when data is pasted.

Example

This example allows you to copy and paste headers.

Javascript

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);

Inheritance Hierarchy

Object
GC.Spread.Sheets.CopyPasteHeaderOptions

Reference

GC.Spread.Sheets Namespace