Selection
This section is dedicated to bring all properties, events and methods to handle the 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 | Remote the selection.
resetSelection() : void
|
| isSelected | Verify if a coordinates given is 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 cell grid programatically
<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>
var table = jspreadsheet(document.getElementById('spreadsheet'), {
worksheet: [{
minDimensions: [6,6],
}],
});
</script>
</html>