TabStripRatio Property (FpSpread)

Gets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.

Syntax

Visual Basic
C#

'Declaration
 
Public Property TabStripRatio As Double

'Usage
 
Dim instance As FpSpread
Dim value As Double
 
instance.TabStripRatio = value
 
value = instance.TabStripRatio

public double TabStripRatio {get; set;}

Property Value

Double-precision, floating point number representing the ratio of the tab strip length to the overall Spread component length

Remarks

This property directly affects the scroll bar width, which is immediately to the right of the tab strip. the larger the tab strip ratio, the larger the tab strip width, and thus the smaller the scroll bar width.

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;

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.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

Reference

FpSpread Class
FpSpread Members
TabStripPolicy Property

User-Task Documentation

Customizing the Sheet Name Tabs