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


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

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

PropertyDescription
Gets the cell range when pasting.  
Gets the ClipboardPasteOptions value when pasting.  
Gets the source range.  
Gets the source sheet.  
Gets the worksheet.  
Example
This example uses the ClipboardPasted 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