Built-in sheet tab control

From version 0.8.8 the multiple worksheet is available, to switch between multiple worksheet, a built-in sheet tab control is contained in both Windows Form and WPF ReoGrid control.

Built-in sheet tab control

By default, the sheet tab control displayed below worksheet.

Windows Form

167

 WPF

168

Scroll sheet tab control

It is possible to scroll the tab control by holding press on the arrow buttons at left side of control.

216

Hide sheet tab control

To hide sheet tab control, set WorkbookSettings.View_ShowSheetTabControl to false:

C#:

grid.SetSettings(unvell.ReoGrid.WorkbookSettings.View_ShowSheetTabControl, false);

VB:

grid.SetSettings(unvell.ReoGrid.WorkbookSettings.View_ShowSheetTabControl, False)

After hide:

215

Set width of tab control

Use property SheetTabControlWidth of control to change the width of sheet tab control:

grid.SheetTabControlWidth = 200;

217
Tip: It is possible to read this property, save and load it to restore the user interface after next application boot.

Change background color and text color for sheet tab

To change the background color and text color, use property NameBackColor and NameTextColor of worksheet:

grid.Worksheets[1].NameBackColor = Color.LightCoral;

Result:

275

Hide new worksheet button

To hide new sheet button, set the SheetTabNewButtonVisible property to false:

grid.SheetTabNewButtonVisible = false;

Result:

281

Sheet tab context strip menu

Right click on the sheet tab will pop up a context strip menu:

280

To set context strip menu:

grid.SheetTabContextMenuStrip = myContextStripMenu;

To prevent built-in pop up menu, set the property to an empty menu strip:

grid.SheetTabContextMenuStrip = new ContextMenuStrip();

Change the context strip menu languages

By changing the value of properties from class LanguageResource to change the text on context menu:

LanguageResource.Menu_InsertSheet = "Insert";

Return to document

Next: Memory Workbook