Spread Windows Forms 7.0 Product Documentation
ActiveSheetIndex Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : ActiveSheetIndex Property


Glossary Item Box

Gets or sets the index of the active sheet in the component.

Syntax

Visual Basic (Declaration) 
Public Property ActiveSheetIndex As Integer
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As Integer
 
instance.ActiveSheetIndex = value
 
value = instance.ActiveSheetIndex
C# 
public int ActiveSheetIndex {get; set;}

Property Value

Integer index of the currently selected sheet

Remarks

This property is available at run time only.

Example

This example sets the active sheet.
C#Copy Code
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.ActiveColumnIndex = 2;
fpSpread1.ActiveSheet.ActiveRowIndex = 2;
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.Sheets.Count = 3;
fpSpread1.ActiveSheetIndex = 1;
Visual BasicCopy Code
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.ActiveColumnIndex = 2
fpSpread1.ActiveSheet.ActiveRowIndex = 2
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
fpSpread1.Sheets.Count = 3
fpSpread1.ActiveSheetIndex = 1

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

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