Spread WPF Documentation
ValidationDragDropBlock Event (GcSpreadSheet)
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class : ValidationDragDropBlock Event
Occurs when the user drags and drops a range of cells.
Syntax
'Declaration
 
Public Event ValidationDragDropBlock As System.EventHandler(Of ValidationDragDropBlockEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of ValidationDragDropBlockEventArgs)
 
AddHandler instance.ValidationDragDropBlock, handler
public event System.EventHandler<ValidationDragDropBlockEventArgs> ValidationDragDropBlock
Event Data

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

PropertyDescription
ColumnCountGets the column count of the cell range being dragged.  
CopyGets whether the source range is copied.  
FromColumnGets the column index of the top left cell of the source range (range being dragged).  
FromRowGets the row index of the top left cell of the source range (range being dragged).  
HandleGets or sets whether the event is handled.  
InsertGets whether the source range is inserted.  
InvalidMessageGets or sets the invalid message.  
IsInvalidGets or sets whether the value is valid.  
RowCountGets the row count of the cell range being dragged.  
ToColumnGets the column index of the bottom right cell of the destination range (where selection is dropped).  
ToRowGets the row index of the top left cell of the destination range (where selection is dropped).  
Example
Drag and move the validator in cell (1,1) to see the event code result. 
var valid1 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Windows.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.Windows.SpreadSheet.UI.ValidationPastingEventArgs e)
        {
            TextBox1.Text = e.IsInvalid.ToString();
        }

private void GcSpreadSheet1_ValidationDragDropBlock(object sender, GrapeCity.Windows.SpreadSheet.UI.ValidationDragDropBlockEventArgs e)
        {
            TextBox1.Text = e.RowCount.ToString();
        }
Dim valid1 = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateNumberValidator(GrapeCity.Windows.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.Windows.SpreadSheet.UI.ValidationPastingEventArgs) Handles GcSpreadSheet1.ValidationPasting
            TextBox1.Text = e.IsInvalid.ToString()
    End Sub

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

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page