Selection
This section is dedicated to all properties, events and methods for handling selection on the JavaScript grid.
Documentation
Methods
Methods available to deal with the JavaScript grid selection
| Method | Description |
|---|
| getHighlighted | Get the coordinates of the highlighted cells.
getHighlighted() : Array | null
|
| getRange | Get the range description of the highlighted cells.
getRange() : String | null
|
| selectAll | Select all cells.
selectAll() : void
|
| updateSelection | Select the cells from the coordinates of a DOM element.
updateSelection(e1: DOMElement, e2: DOMElement) : void
|
| updateSelectionFromCoords | Select the cells by coordinates.
updateSelectionFromCoords(x1: Number, y1: Number, x2: Number, y2: Number) : void
|
| resetSelection | Remove the selection.
resetSelection() : void
|
| isSelected | Verify if the coordinates given are included in the current selection.
isSelected(x: Number, y: Number) : Boolean
|
Events
| Event | Description |
|---|
| onblur | onblur(worksheet: Object) : void |
| onfocus | onfocus(worksheet: Object) : void |
| onselection | onselection(worksheet: Object, x1: Number, y1: Number, x2: Number, y2: Number, e: MouseEvent) : void |
Initial Settings
| Property | Description |
|---|
| selectionCopy: boolean | Disable the clone selection. |
Examples
Select all worksheet cells in the grid programmatically.
Source code
<html>
<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<div id="spreadsheet"></div>
<button onclick="table[0].selectAll()">Select all</button>
<button onclick="table[0].updateSelectionFromCoords(2,2,3,3)">updateSelectionFromCoords(2,2,3,3)</button>
<script>
// Set the JSS spreadsheet license
jspreadsheet.setLicense('YmI4ODZlYTAzMDM0Yzc4YmY0YjU5ZWUxNmZjZWE3ZTQwMzMxMDljMjc5ZmZhM2Q4ZDMxNzQwYzUyZGE0MThkZmJiNTUzYWE2OTAyNDZhMGVkMTQxMzVmNDFjZGNmNjJhY2YxNGVlOTNlOGJlOTA4N2ZkZTlhZjI4YTRhMjM2MTMsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTVOalE1T0RBMk9Td2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWQyVmlJaXdpYkc5allXeG9iM04wSWwwc0luQnNZVzRpT2lJek5DSXNJbk5qYjNCbElqcGJJblkzSWl3aWRqZ2lMQ0oyT1NJc0luWXhNQ0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owSWl3aVltRnlJaXdpZG1Gc2FXUmhkR2x2Ym5NaUxDSnpaV0Z5WTJnaUxDSndjbWx1ZENJc0luTm9aV1YwY3lKZExDSmtaVzF2SWpwMGNuVmxmUT09');
// Create the spreadsheet
var table = jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
minDimensions: [6,6],
}],
});
</script>
</html>
