Version

Configuring Tab Bar Area (XamSpreadsheet)

Purpose

This topic explains how to configure the worksheet’s tabs area.

Required background

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

Type Content

Concept

Infragistics Excel Engine

Topic Purpose

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 .

This topic explains in details the features of the XamSpreadsheet control from developer perspective.

This topic provides an overview of the visual elements of the XamSpreadsheet control.

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

In this topic

This topic contains the following sections:

Worksheets Configuration Summary

Worksheets configuration summary chart

The following table explains briefly the configurable aspects of the XamSpreadsheet’s tab bar. Further details are available after the table.

Configurable aspect Details Property/Method

Show or hide the tab bar area

Set the width of the tab bar area

Enable, disable and configure workbook structural changes

Show or Hide

Overview

You can specify whether the XamSpreadsheet’s tab bar area is visible.

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:

Show the tab bar

TabBarVisible

true

Hide the tab bar

TabBarVisible

false

Set the Width

Overview

You can set or obtain the width of the tab bar area, expressed in 1/1000ths of the XamSpreadsheet’s width. A value of 1000 indicates the worksheet’s tab bar occupies the entire width of the application, while a value of 0 indicates the worksheet’s tab bar has no width. All space not occupied by the worksheet’s tab bar will be used by the horizontal scroll bar, if it is visible.

Property settings

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And:

Set the tab bar area

TabBarWidth

Set it to a value of type int

Obtain the tab bar area

TabBarWidth

Read its value

Workbook Protection

Overview

You can restrict workbook 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.

Related Content

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains how to configure the cell editing feature.

This topic explains how to configure the navigation feature.

This topic explains how to configure the selection feature.

This topic explains how to set, remove and configure workbook protection.