ActivatedSheetIndex Property

Gets or sets the index of the new active sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ActivatedSheetIndex As Integer

'Usage
 
Dim instance As ActiveSheetChangingEventArgs
Dim value As Integer
 
instance.ActivatedSheetIndex = value
 
value = instance.ActivatedSheetIndex

public int ActivatedSheetIndex {get; set;}

Property Value

Integer index of the new active sheet

Example

This example shows the use of the property for a three-sheet workbook. In the ActiveSheetChanging event, if the third sheet is clicked, the event is cancelled and focus remains on the previous sheet.

private void fpSpread1_ActiveSheetChanging(object sender, FarPoint.Win.Spread.ActiveSheetChangingEventArgs e)
{
     if (e.ActivatedSheetIndex == 2)
     {
          e.Cancel = true;
     }
}

Visual Basic

Private Sub FpSpread1_ActiveSheetChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ActiveSheetChangingEventArgs)
Handles FpSpread1.ActiveSheetChanging
   If e.ActivatedSheetIndex = 2 Then
      e.Cancel = True
   End If
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

Reference

ActiveSheetChangingEventArgs Class
ActiveSheetChangingEventArgs Members