Spread Windows Forms 12.0 Product Documentation
ActivatedSheetIndex Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ActiveSheetChangingEventArgs Class : ActivatedSheetIndex Property
Gets or sets the index of the new active sheet.
Syntax
'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;
     }
}
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
See Also

Reference

ActiveSheetChangingEventArgs Class
ActiveSheetChangingEventArgs Members