Occurs when the user changes the active sheet.
Syntax
Event Data
The event handler receives an argument of type ActiveSheetChangingEventArgs containing data related to this event. The following ActiveSheetChangingEventArgs properties provide information specific to this event.
Property | Description |
---|
ActivatedSheetIndex | Gets or sets the index of the new active sheet. |
Cancel | Gets or sets whether to cancel the active sheet change. |
Remarks
Example
This example raises the ActiveSheetChanging event when the user clicks on another sheet.
C# | Copy Code |
---|
fpSpread1.Sheets.Count = 3;
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
private void fpSpread1_ActiveSheetChanged(object sender, System.EventArgs e)
{
ListBox1.Items.Add("Active Sheet Changing.");
} |
Visual Basic | Copy Code |
---|
FpSpread1.Sheets.Count = 3
FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
Private Sub FpSpread1_ActiveSheetChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ActiveSheetChangingEventArgs)
Handles FpSpread1.ActiveSheetChanging
ListBox1.Items.Add("Active Sheet Changing.")
End Sub |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also