Gets the sheets (SheetView objects) in the component.

Syntax

Visual Basic (Declaration)
Public ReadOnly Property Sheets As SheetViewCollection

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim value As SheetViewCollection value = instance.Sheets

C#
public SheetViewCollection Sheets {get;}

Property Value

SheetViewCollection object containing the collection of sheets

Remarks

Use this property to work with individual sheets by specifying the sheet index, then setting properties for the specified object. The sheet index is zero-based; the first sheet is index 0.

Within a sheet object, use these properties (corresponding to shortcut objects) with indexes to set properties for those objects

Example

This example sets the number of sheets for the Spread component and the amount of space the tab strip occupies.

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.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always; fpSpread1.TabStripRatio = 0.75; fpSpread1.Sheets.Count = 3; fpSpread1.TabStrip[0].BackColor = Color.LightBlue;

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.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.TabStripRatio = 0.75;
fpSpread1.Sheets.Count = 3;
fpSpread1.TabStrip[0].BackColor = Color.LightBlue;

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.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always fpSpread1.TabStripRatio = 0.75 fpSpread1.Sheets.Count = 3 fpSpread1.TabStrip(0).BackColor = Color.LightBlue

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.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
fpSpread1.TabStripRatio = 0.75
fpSpread1.Sheets.Count = 3
fpSpread1.TabStrip(0).BackColor = Color.LightBlue

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

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread Windows Forms 7.0 Product Documentation
Sheets Property
See Also Example Support Options