Spread Windows Forms 6.0 Product Documentation
SheetSpanModelEventHandler Delegate
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : SheetSpanModelEventHandler Delegate


sender
Object that raised the event
e
Event arguments

Glossary Item Box

Handles the Changed event in the span model of the sheet.

Syntax

Visual Basic (Declaration) 
Public Delegate Sub SheetSpanModelEventHandler( _
   ByVal sender As Object, _
   ByVal e As SheetSpanModelEventArgs _
) 
Visual Basic (Usage)Copy Code
Dim instance As New SheetSpanModelEventHandler(AddressOf HandlerMethod)
C# 
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.
C#Copy Code
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(); 
} 
Visual BasicCopy Code
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.