Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property ActiveSheet As SheetView | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FpSpread Dim value As SheetView instance.ActiveSheet = value value = instance.ActiveSheet | |
| C# | |
|---|---|
public SheetView ActiveSheet {get; set;} | |
Property Value
SheetView object with the currently selected sheetExceptions
| Exception | Description |
|---|---|
| System.ArgumentException | Specified sheet is not in the collection |
Remarks
This property is available at run time only.
Example
This example sets the active cell and its data in 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 Basic | Copy 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