Tab Bar Area Interactions (UltraSpreadsheet)

This topic explains what actions can be performed by the user when interacting with the worksheets.

The following table lists the concept and topics required as a prerequisite to understanding this topic.

Type	Content
Concept	Infragistics Excel Engine

Topic	Purpose
Understanding Infragistics Excel Engine	In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine .
Features Overview (UltraSpreadsheet)	This topic explains in details the features of the UltraSpreadsheet control from developer perspective.
Visual Elements Overview (UltraSpreadsheet)	This topic provides an overview of the visual elements of the UltraSpreadsheet control.
Activation and Navigation Interactions (UltraSpreadsheet)	This topic explains what actions can be performed by the user when navigating through the worksheet cells.

This topic contains the following sections:

Worksheet Tabs Navigation

The user may use the UltraSpreadsheet's tabs area under the worksheet’s cells to navigate and manage the worksheets.

Left and right arrow keys used to scroll the worksheets tabs area
Button for activating the previous worksheet
Worksheets area with tabs for each worksheet of the opened workbook
Button for activating the next worksheet
"Plus" button for adding new worksheet
Splitter used to split the area between the worksheet tabs and the horizontal scrollbar
Horizontal scrollbar of the active worksheet

The following table summarizes the user interaction capabilities of the UltraSpreadsheet's worksheets tabs area.

The user can…	Using…	Details	Configurable?
Select worksheet	Click on the desired worksheet tab in the worksheet tabs area	N/A
Navigate worksheets	Press `Ctrl` + `Page Up` or `Ctrl` + `Page Down` keys	N/A
Multiple worksheets selection	Click on the first worksheet tab, then press and hold `Ctrl` key and click on other worksheet tabs	N/A
Create new worksheet	Use the "plus" button right of the worksheet tabs	The new worksheet tab will be added on right of the currently selected worksheet tab
Rename worksheet	Double click on the worksheet’s tab	An in-place editor will be shown and the user may edit the worksheet tab’s name. Renaming is confirmed by pressing the Enter key
Reorder worksheet	Click on a worksheet tab and drag it to a new position	The worksheet tab will be reordered
Navigate through the worksheet tabs	Click the left or right arrow buttons left of the worksheet tabs	The three dot buttons on both sides are shown when more worksheet tabs are available in the respective direction
Resize the worksheets tab bar area	Use the splitter on right of the "plus" button	N/A	Configuring Tab Bar Area (UltraSpreadsheet)

Note	Note You can restrict workbook’s structural changes using the workbook’s Protect method. Workbook’s structural changes include: inserting, renaming, deleting and reordering of worksheets. To enable the above operations use the workbook’s Unprotect method.

Topic	Purpose
Configuring Tab Bar Area (UltraSpreadsheet)	This topic explains how to configure the worksheets.
Configuring Selection (UltraSpreadsheet)	This topic explains how to configure the selection feature.
Working with Selection (UltraSpreadsheet)	This topic explains the selection feature from developer perspective.