Sheet Tab Control

Sheet Tab User Interface

ReoGrid features a built-in sheet tab user interface control, allowing end-users to switch between active worksheets seamlessly. 168

Scroll the sheet tab control

If there are too many worksheets to be fully displayed in the Sheet Tab Control, the user can scroll through the Sheet Tab Control to select worksheets that are hidden from view. 167

Hide sheet tab control

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

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

Set width of tab control

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

grid.SheetTabControlWidth = 200;

217

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";

Was the content of the page helpful?