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


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
CellRange Gets the cell range when pasting.  
PasteOption Gets the ClipboardPasteOptions value when pasting.  
SourceRange Gets the source range.  
SourceSheet Gets the source sheet.  
Worksheet 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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options