Spread Windows Forms 9.0 Product Documentation
ActiveSheet Property
Example 


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
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;
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with the Active Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.