ValidationPasting Event (GcSpreadSheet)

Visual Basic
C#

'Declaration
 
Public Event ValidationPasting As EventHandler(Of ValidationPastingEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of ValidationPastingEventArgs)
 
AddHandler instance.ValidationPasting, handler

public event EventHandler<ValidationPastingEventArgs> ValidationPasting

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

Property	Description
FromRange	Gets the source range.
FromSheet	Gets the source sheet.
Handle	Gets or sets whether the event is handled.
InvalidMessage	Gets or sets the invalid message.
IsCutting	Gets a value that indicates whether the data is cut.
IsInvalid	Gets or sets whether the value is invalid.
PastingRange	Gets the pasting range.
ToRange	Gets the cell range when pasting.
ToWorksheet	Gets the worksheet.

Copy and paste the validator in cell (1,1) to see the event code.

C#
VB.NET

private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            var valid1 = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.GreaterThan, "5", "20", true);
            GcSpreadSheet1.Sheets[0].Cells[1, 1].DataValidator = valid1;
            GcSpreadSheet1.Sheets[0].Cells[1, 0].Text = "A number greater than 5 is valid.";
        }

        private void GcSpreadSheet1_ValidationPasting(object sender, GrapeCity.Xaml.SpreadSheet.UI.ValidationPastingEventArgs e)
        {
            TextBox1.Text = e.IsInvalid.ToString();
        }

        private void GcSpreadSheet1_ValidationDragDropBlock(object sender, GrapeCity.Xaml.SpreadSheet.UI.ValidationDragDropBlockEventArgs e)
        {
            TextBox1.Text = e.RowCount.ToString();
        }

Dim valid1 = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.GreaterThan, "5", "20", True)
GcSpreadSheet1.Sheets(0).Cells(1, 1).DataValidator = valid1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Text = "A number greater than 5 is valid."

Private Sub GcSpreadSheet1_ValidationPasting(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.ValidationPastingEventArgs) Handles GcSpreadSheet1.ValidationPasting
TextBox1.Text = e.IsInvalid.ToString()
End Sub

Private Sub GcSpreadSheet1_ValidationDragDropBlock(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.ValidationDragDropBlockEventArgs) Handles GcSpreadSheet1.ValidationDragDropBlock
TextBox1.Text = e.RowCount.ToString()
End Sub

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members