Spread Silverlight Documentation
DragFillBlockCompleted Event (GcSpreadSheet)
Example 


Occurs at the completion of the user dragging to fill a range of cells.
Syntax
'Declaration
 
Public Event DragFillBlockCompleted As System.EventHandler(Of DragFillBlockCompletedEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of DragFillBlockCompletedEventArgs)
 
AddHandler instance.DragFillBlockCompleted, handler
public event System.EventHandler<DragFillBlockCompletedEventArgs> DragFillBlockCompleted
Event Data

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

PropertyDescription
AutoFillTypeGets the AutoFillType value used for the fill operation.  
FillDirectionGets the direction of the fill.  
FillRangeGets the range used for the fill operation.  
Example
This example uses the DragFillBlockCompleted event.
gcSpreadSheet1.CanUserDragFill = true;

private void gcSpreadSheet1_DragFillBlock(object sender, GrapeCity.Windows.SpreadSheet.UI.DragFillBlockEventArgs e)
        {
           listBox1.Items.Add(e.AutoFillType.ToString());
           listBox1.Items.Add(e.FillDirection.ToString());
           listBox1.Items.Add(e.FillRange.RowCount.ToString());
        }

private void gcSpreadSheet1_DragFillBlockCompleted(object sender, GrapeCity.Windows.SpreadSheet.UI.DragFillBlockCompletedEventArgs e)
        {
            listBox1.Items.Add(e.AutoFillType.ToString());
            listBox1.Items.Add(e.FillDirection.ToString());
            listBox1.Items.Add(e.FillRange.RowCount.ToString());
        }
GcSpreadSheet1.CanUserDragFill = True
    
    Private Sub GcSpreadSheet1_DragFillBlock(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.DragFillBlockEventArgs) Handles GcSpreadSheet1.DragFillBlock
        ListBox1.Items.Add(e.AutoFillType.ToString())
        ListBox1.Items.Add(e.FillDirection.ToString())
        ListBox1.Items.Add(e.FillRange.RowCount.ToString())
    End Sub

    Private Sub GcSpreadSheet1_DragFillBlockCompleted(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.DragFillBlockCompletedEventArgs) Handles GcSpreadSheet1.DragFillBlockCompleted
        ListBox1.Items.Add(e.AutoFillType.ToString())
        ListBox1.Items.Add(e.FillDirection.ToString())
        ListBox1.Items.Add(e.FillRange.RowCount.ToString())
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.