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 provides an overview of the visual elements of the XamSpreadsheet control.
Worksheets Configuration Summary
Worksheets configuration summary
You can configure several worksheet aspects using properties defined directly on the XamSpreadsheet 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.
Note:
Note
Note
If you need to configure these aspects individually for each worksheet please look at the Excel Engine’s Worksheet Operations section.
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.
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.
