This topic explains what actions can be performed by the user when selecting worksheet cells.
To understand this topic you need to be familiar with the concept and topics related to the Infragistics JavaScript Excel Library.
The igSpreadsheet control supports three selection modes: normal, extendSelection and addToSelection. In this topic we will cover those modes explaining what is the difference between them.
The default value for the selectionMode option is normal. When the selection mode is set to normal the selection is done by dragging the mouse to select a cell or range of cells. In this mode every new selection replaces the old one. Similarly when you use the keyboard navigation to select a cell or a range of cells, a new selection is created. If you want instead of replacing the selection to add a new selection to the existing one, you need to hold the Ctrl button and select the new range with your mouse. If you need to alter the selected range containing the active cell, you need to hold the Shift button and click with the mouse or navigate via keyboard with arrow keys.
$("#spreadsheet").igSpreadsheet({
height: "600",
width: "75%",
selectionMode: "normal"
});
In the case where the selection mode is set to extendSelection then the selection range is only one and it is enclosed between the active cell and the cell selected by the mouse or by navigating the keyboard. If you need to move the active cell this can be done by holding the Ctrl key and using the mouse.
$("#spreadsheet").igSpreadsheet({
height: "600",
width: "75%",
selectionMode: "extendSelection"
});
This mode allows new cells ranges to be added without the need of holding the Ctrl button. The user may click on cell(s) to add it (them) to the current selection.
$("#spreadsheet").igSpreadsheet({
height: "600",
width: "75%",
selectionMode: "addToSelection"
});
The following table summarizes the user interaction capabilities of the igSpreadsheet control.
| The user can... | Using... | Details |
|---|---|---|
| Select a single cell | Click on it or Press Shift + Arrow | A single cell will be selected (this will be the active cell). |
| Select a range of cells | Click the start cell and drag or Hold the Shift key and select cells with Arrow keys. | A range of cells will be selected. The cell from which the user starts the selection range will be the active cell. |
| Select several cells/cell ranges | Hold Ctrl key pressed while selecting cells/cell ranges. | Use the steps described in the previous two table rows to add single cell or multiple cell ranges to the current selection. |
| Enter/Exit extendSelection mode | Press F8 | This key combination will toggle between Normal and extendSelection modes. |
| Enter/Exit addToSelection mode | Press Shift + F8 | This key combination will toggle between Normal and addToSelection modes. |
Note: If the user has more than one worksheet selected and perform selection in the active worksheet all other selected worksheets will get the same selection and subsequent operations will be executed over all selected worksheets.
View on GitHub