ActiveSheet Property (FpSpread)

Gets or sets the active sheet in the component.

Syntax

Visual Basic
C#

'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

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.

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

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

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with the Active Sheet