GrapeCity.Xaml.SpreadSheet.UI
ClipboardPasting Event (GcSpreadSheet)
Example 


GrapeCity.Xaml.SpreadSheet.UI Namespace > GcSpreadSheet Class : ClipboardPasting Event
Occurs when the user pastes from the Clipboard.
Syntax
'Declaration
 
Public Event ClipboardPasting As EventHandler(Of ClipboardPastingEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of ClipboardPastingEventArgs)
 
AddHandler instance.ClipboardPasting, handler
public event EventHandler<ClipboardPastingEventArgs> ClipboardPasting
Event Data

The event handler receives an argument of type ClipboardPastingEventArgs containing data related to this event. The following ClipboardPastingEventArgs properties provide information specific to this event.

PropertyDescription
(Inherited from System.ComponentModel.CancelEventArgs)
Gets the cell range for pasting.  
Gets a value indicating whether is cutting.  
Gets the ClipboardPasteOptions value when pasting.  
Gets the soruce range.  
Gets the source sheet.  
Gets the worksheet for patsting.  
Example
This example uses the ClipboardPasting event.
private void gcSpreadSheet1_ClipboardChanged(object sender, EventArgs e)
        {
            listBox1.Items.Add("ClipboardChanged");
        }

private void gcSpreadSheet1_ClipboardChanging(object sender, EventArgs e)
        {
            listBox1.Items.Add("ClipboardChanging");
        }

private void gcSpreadSheet1_ClipboardPasted(object sender, GrapeCity.Xaml.SpreadSheet.UI.ClipboardPastedEventArgs e)
        {
            listBox1.Items.Add(e.CellRange.ColumnCount.ToString());
            listBox1.Items.Add(GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString());
        }

private void gcSpreadSheet1_ClipboardPasting(object sender, GrapeCity.Xaml.SpreadSheet.UI.ClipboardPastingEventArgs e)
        {
            listBox1.Items.Add(e.CellRange.ColumnCount.ToString());
            listBox1.Items.Add(GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString());
        }
Private Sub GcSpreadSheet1_ClipboardChanged(sender As System.Object, e As System.EventArgs) Handles GcSpreadSheet1.ClipboardChanged
        ListBox1.Items.Add("ClipboardChanged")
    End Sub

Private Sub GcSpreadSheet1_ClipboardChanging(sender As System.Object, e As System.EventArgs) Handles GcSpreadSheet1.ClipboardChanging
        ListBox1.Items.Add("ClipboardChanging")
    End Sub

Private Sub GcSpreadSheet1_ClipboardPasted(sender As System.Object, e As GrapeCity.Xaml.SpreadSheet.UI.ClipboardPastedEventArgs) Handles GcSpreadSheet1.ClipboardPasted
        ListBox1.Items.Add(e.CellRange.ColumnCount.ToString())
        ListBox1.Items.Add(GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString())
    End Sub

Private Sub GcSpreadSheet1_ClipboardPasting(sender As System.Object, e As GrapeCity.Xaml.SpreadSheet.UI.ClipboardPastingEventArgs) Handles GcSpreadSheet1.ClipboardPasting
        ListBox1.Items.Add(e.CellRange.ColumnCount.ToString())
        ListBox1.Items.Add(GrapeCity.Xaml.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString())
    End Sub
See Also