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 .
You can specify whether the UltraSpreadsheet’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 UltraSpreadsheet’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.