SpreadJS Documentation
Using Clipboard Operations
SpreadJS Documentation > Developer's Guide > Managing the User Interface > Using Clipboard Operations

The user can cut, copy, and paste data in the widget.

The following conditions apply when using cut, copy, or paste:

You can display an indicator after copying or cutting cell values. Use the options.cutCopyIndicatorVisible property to specify the indicator and the options.cutCopyIndicatorBorderColor property to specify the border color. The following image displays an indicator after selecting a block of cells and pressing the Ctrl + C keys.

You can specify whether to copy and paste headers with Workbook options.copyPasteHeaderOptions.

The options.clipBoardOptions property only applies to copying and pasting data.

Some styles can also be copied and pasted to and from Excel. For more information, refer to Copying and Pasting Styles.

Using Code

This example specifies the paste options.

JavaScript
Copy Code
activeSheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.Values;
See Also