Spread WPF Documentation
ClipboardPasting Event (GcSpreadSheet)
Example 


Occurs when the user pastes from the Clipboard.
Syntax
'Declaration
 
Public Event ClipboardPasting As System.EventHandler(Of ClipboardPastingEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of ClipboardPastingEventArgs)
 
AddHandler instance.ClipboardPasting, handler
public event System.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
Cancel (Inherited from System.ComponentModel.CancelEventArgs)
CellRangeGets the cell range for pasting.  
IsCuttingGets a value indicating whether is cutting.  
PasteOptionGets the ClipboardPasteOptions value when pasting.  
SourceRangeGets the soruce range.  
SourceSheetGets the source sheet.  
WorksheetGets 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.Windows.SpreadSheet.UI.ClipboardPastedEventArgs e)
        {
            listBox1.Items.Add(e.CellRange.ColumnCount.ToString());
            listBox1.Items.Add(GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString());
        }

private void gcSpreadSheet1_ClipboardPasting(object sender, GrapeCity.Windows.SpreadSheet.UI.ClipboardPastingEventArgs e)
        {
            listBox1.Items.Add(e.CellRange.ColumnCount.ToString());
            listBox1.Items.Add(GrapeCity.Windows.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.Windows.SpreadSheet.UI.ClipboardPastedEventArgs) Handles GcSpreadSheet1.ClipboardPasted
        ListBox1.Items.Add(e.CellRange.ColumnCount.ToString())
        ListBox1.Items.Add(GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.Values.ToString())
    End Sub

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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.