Spread Windows Forms 9.0 Product Documentation
SheetSpanModelEventHandler Delegate
ExampleExample 


Object that raised the event
Event arguments
Handles the Changed event in the span model of the sheet.
Syntax
'Declaration
 
Public Delegate Sub SheetSpanModelEventHandler( _
   ByVal sender As Object, _
   ByVal e As SheetSpanModelEventArgs _
) 
'Usage
 
Dim instance As New SheetSpanModelEventHandler(AddressOf HandlerMethod)
public delegate void SheetSpanModelEventHandler( 
   object sender,
   SheetSpanModelEventArgs e
)

Parameters

sender
Object that raised the event
e
Event arguments
Remarks
For information on the event, refer to the Changed event.
Example
This example creates the handler for the model.
FarPoint.Win.Spread.Model.BaseSheetSpanModel model; 
 
model = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span; 
model.AddSelection(0, 0, 2, 2); 
 
model.Changed += new FarPoint.Win.Spread.Model.SheetSpanModelEventHandler(modelSpanModelChanged); 
     
private void button1Click(object sender, System.EventArgs e) 
{ 
    model.Add(4, 2, 2, 3); 
} 
 
private void modelSpanModelChanged(object sender, FarPoint.Win.Spread.Model.SheetSpanModelEventArgs e) 
{ 
    textBox1.Text = e.ColumnCount.ToString(); 
} 
Friend WithEvents model As FarPoint.Win.Spread.Model.BaseSheetSpanModel

model = FpSpread1.ActiveSheet.Models.Span
model.Add(0, 0, 2, 2)

Dim h As FarPoint.Win.Spread.Model.SheetSpanModelEventHandler = AddressOf modelSpanModelChanged
AddHandler model.Changed, h

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    model.Add(4, 2, 2, 3)
End Sub

Private Sub modelSpanModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetSpanModelEventArgs)
    TextBox1.Text = e.ColumnCount.ToString()
End Sub
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetSpanModelEventHandler Members
FarPoint.Win.Spread.Model Namespace
SheetSpanModelEventArgs Class
Changed Event

 

 


Copyright © GrapeCity, inc. All rights reserved.