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.
Some styles can also be copied and pasted to and from Excel. For more information, refer to Copying and Pasting Styles.
This example specifies the paste options.
JavaScript |
Copy Code
|
---|---|
activeSheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.Values; |