Spread Windows Forms 11.0 Product Documentation
ActiveSheet Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : ActiveSheet Property
Gets or sets the active sheet in the component.
Syntax
'Declaration
 
Public Property ActiveSheet As SheetView
'Usage
 
Dim instance As FpSpread
Dim value As SheetView
 
instance.ActiveSheet = value
 
value = instance.ActiveSheet
public SheetView ActiveSheet {get; set;}

Property Value

SheetView object with the currently selected sheet
Exceptions
ExceptionDescription
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.
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;
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
See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with the Active Sheet