Spread.Sheets Documentation
ClipboardPasting Event
The sheet that triggered the event.
The sheet's name.
The range to paste.
The paste option that indicates what data is pasted from the clipboard: values, formatting, or formulas.
The data from the clipboard that will be pasted into Spread.Sheets.
Occurs when the user is pasting from the Clipboard.
Syntax
var instance; // Type: Events
instance.ClipboardPasting = function(sheet, sheetName, cellRange, pasteOption, pasteData) { };
ClipboardPasting = function ( 
   sheet : Worksheet,
   sheetName : string,
   cellRange : Range,
   pasteOption : ClipboardPasteOptions,
   pasteData : Object
) { };

Parameters

sheet
The sheet that triggered the event.
sheetName
The sheet's name.
cellRange
The range to paste.
pasteOption
The paste option that indicates what data is pasted from the clipboard: values, formatting, or formulas.
pasteData
The data from the clipboard that will be pasted into Spread.Sheets.
Example
This example uses the ClipboardPasting event.
// Use IE to see the console log text
var activeSheet = spread.getActiveSheet();

activeSheet.bind(GC.Spread.Sheets.Events.ClipboardChanged, function (sender, args) {
    console.log("ClipboardChanged.");
});

activeSheet.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (sender, args) {
    console.log("ClipboardChanging");
});

activeSheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function (sender, args) {
    console.log("ClipboardPasted");
});

activeSheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
    console.log("ClipboardPasting");
});
Remarks
Parameter Type Description
sheet GC.Spread.Sheets.Worksheet The sheet that triggered the event.
sheetName string The sheet's name.
cellRange GC.Spread.Sheets.Range The range to paste.
pasteOption GC.Spread.Sheets.ClipboardPasteOptions The paste option that indicates what data is pasted from the clipboard: values, formatting, or formulas.
pasteData Object The data from the clipboard that will be pasted into Spread.Sheets.
pasteData.text string The text string of the clipboard.
pasteData.html string The html string of the clipboard.
cancel boolean A value that indicates whether the operation should be canceled.
See Also

Reference

Events type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.