This topic explains how to configure Ignite UI for jQuery® Spreadsheet control.
This topic contains the following sections:
To understand this topic you need to be familiar with the concept and topics related to the Infragistics JavaScript Excel Library.
The igSpreadsheet supports navigation of the active cell through the cells of the active pane of the currently selected worksheet. The user may change the active cell using the keyboard or mouse and use the horizontal and vertical scroll bars to change the visible columns and rows of the active sheet pane.
In addition to the normal navigation behavior, the igSpreadsheet control supports one more navigation mode:
End Mode - in this mode the arrow keys are used to navigate adjacent cells with data.
The table below lists the configurable navigation behaviors of the igSpreadsheet control.
| Configurable behavior | Behavior details | Configuration properties |
|---|---|---|
| End Mode | Enable or disable end mode navigation. | isInEndMode |
You can control whether the existing selection is replaced or altered depending on the modifier keys (Shift and/or Control) pressed by the user.
To switch between the Spreadsheet's selection modes (normal, extendSelection and addToSelection) programmatically, use the selectionMode property.
The following table maps the desired configuration to the property settings that manage it.
| In order to: | Use this property: | And set it to: |
|---|---|---|
| Set Normal mode | selectionMode |
normal |
| Set extendSelection mode | selectionMode |
extendSelection |
| Set addToSelection mode | selectionMode |
addToSelection |
You can configure several worksheet aspects using properties defined directly on the igSpreadsheet control (listed in the table below). Keep in mind, these properties are convenient when you want to update several worksheets, because they will affect all worksheets selected by the user.
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 that separate the columns and rows. | areGridlinesVisible |
| Headers | This option shows or hides the columns' and rows' headers. | areHeadersVisible |
| Zoom Level | This option controls the magnification of the worksheet. | zoomLevel |
View on GitHub