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/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v4/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('NzIwMDQ4NmRhNzU4NzU5ZTY1YTA4NDQ5NDkxNjIxNzRiZTQ4Y2RmYTIxNjk2MzAwZGMxYjJkYjkwOWJiMWMyODhiZTE5Yzk3MzQzYWNkZmVlZGFjMTc4YjljYTVlOGEzY2ZmZjViODk5Yjc5Y2JhODllYjk3ZjQ5YTc1ODNlMTUsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TWpNd05Dd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=');
// Create the spreadsheet
var table = jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
minDimensions: [6,6],
}],
});
</script>
</html>