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


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
Cancel (Inherited from System.ComponentModel.CancelEventArgs)
CellRange Gets the cell range for pasting.  
IsCutting Gets a value indicating whether is cutting.  
PasteOption Gets the ClipboardPasteOptions value when pasting.  
SourceRange Gets the soruce range.  
SourceSheet Gets the source sheet.  
Worksheet 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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options