Version

Configuring Worksheets (UltraSpreadsheet)

Purpose

This topic explains how to configure the worksheets.

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 UltraSpreadsheet control from developer perspective.

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

Worksheets Configuration Summary

Worksheets configuration summary

You can configure several worksheet aspects using properties defined directly on the UltraSpreadsheet control (listed in the table below). However these properties are convenient when you want to update several worksheets, because they will affect all worksheets selected by the user.

Worksheets configuration summary chart

The following table explains briefly the configurable aspects of the worksheets and maps them to the properties that configure them.

Configurable aspect Details Properties/Methods

Gridlines

This option shows or hides the lines which separating columns and rows.

Headers

This option shows or hides the columns' and rows' headers.

Zoom Level

This option controls the magnification of the worksheet.

Worksheet Protection

The worksheet protection feature allows you to protect (with or without password) several user operations like cell value editing, inserting and deleting columns and rows and more. Each operation can be enabled or disabled individually using the boolean arguments of the Protect method.

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 configure the worksheet’s tabs area.