Spread Windows Forms 9.0 Product Documentation
Sheets Property (FpSpread)
Example 


Gets the sheets (SheetView objects) in the component.
Syntax
'Declaration
 
Public ReadOnly Property Sheets As SheetViewCollection
'Usage
 
Dim instance As FpSpread
Dim value As SheetViewCollection
 
value = instance.Sheets
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.
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;
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 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

Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.