VisibleCount Property

Gets or sets the number of sheet name tabs displayed in the command bar of the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public Property VisibleCount As Integer

'Usage
 
Dim instance As TabInfo
Dim value As Integer
 
instance.VisibleCount = value
 
value = instance.VisibleCount

public int VisibleCount {get; set;}

Property Value

Integer number of tabs that are displayed

Remarks

If more tabs (with sheet names) are available to view, an ellipses (...) button displays in the command bar. Click the button to scroll to the previous or next tab.

For this property to have an effect, you must set the TabControlPolicy property to Always or AsNeeded.

Example

This example shows how to set the display of the sheet name tabs.

FpSpread1.Sheets.Count = 3; 
FpSpread1.Tab.ActiveTabBackColor = Color.Yellow; 
FpSpread1.Tab.ActiveTabBorderColor = Color.Red; 
FpSpread1.Tab.FirstVisibleTab = 1; 
FpSpread1.Tab[0] = "First"; 
FpSpread1.Tab[1] = "Second"; 
FpSpread1.Tab[2] = "Third"; 
FpSpread1.Tab.TextColor = Color.Red; 
FpSpread1.Tab.TabControlPolicy = FarPoint.Web.Spread.TabControlPolicy.Always; 
FpSpread1.Tab.VisibleCount = 2; 
FpSpread1.Tab.ScrollIncrement = 2; 
ListBox1.Items.Add(FpSpread1.Tab.Count.ToString());

Visual Basic

FpSpread1.Sheets.Count = 3
FpSpread1.Tab.ActiveTabBackColor = Color.Yellow
FpSpread1.Tab.ActiveTabBorderColor = Color.Red
FpSpread1.Tab.FirstVisibleTab = 1
FpSpread1.Tab.Item(0) = "First"
FpSpread1.Tab.Item(1) = "Second"
FpSpread1.Tab.Item(2) = "Third"
FpSpread1.Tab.TextColor = Color.Red
FpSpread1.Tab.TabControlPolicy = FarPoint.Web.Spread.TabControlPolicy.Always
FpSpread1.Tab.VisibleCount = 2
FpSpread1.Tab.ScrollIncrement = 2
ListBox1.Items.Add(FpSpread1.Tab.Count)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

TabInfo Class
TabInfo Members
TabControlPolicy Property