Enumeration: CopyPasteHeaderOptions

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
• columnHeaders
• noHeaders
• rowHeaders

Enumeration members

allHeaders

• allHeaders = 3

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

columnHeaders

• columnHeaders = 2

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

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.

rowHeaders

• rowHeaders = 1

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