Work with Selection Object

You can manipulate with Grid cells via the API of the selection object. It is possible to get the object of one or more selected cells or rows, to set selection as to a single row or cell as to multiple rows or cells. The selection object also allows removing selection from previously selected cells.

Enabling/Disabling Selection object

Starting from v7.0, you can activate selection of cells via the enable() method of the selection object.

grid.selection.enable();

To disable selection of cells in Grid, make use of the disable() method of the selection object:

grid.selection.disable();

Setting selection to cells

You can set selection to one or more rows or cells using the setCell() method of the selection object. The method takes the following parameters:

row	(object|string) an object with a cell to be selected or the id of a row
column	(object|string) the config of a column or its id
ctrlUp	(boolean) true - to select the desired rows or cells, otherwise - false (for multiselection mode)
shiftUp	(boolean) true - to select a range of rows or cells, otherwise - false (for multiselection mode)

Setting selection to a cell

The example below shows how to highlight the first cell in the "Yearly Change" column:

var grid = new dhx.Grid("grid_container", {    columns: [// columns config],    selection:"cell",    multiselection: false, /*!*/    data: dataset});
var row = grid.data.getItem(grid.data.getId(0));var column = grid.getColumn("yearlyChange");grid.selection.setCell(row, column);

Related sample: Grid. Multiselection

note

The multiselection property is disabled.

Setting selection to multiple cells/rows

You can highlight the desired cells when the multiselection:true and the selection:"cell" properties are set:

var grid = new dhx.Grid("grid_container", {    columns: [// columns config],    selection:"cell",  /*!*/    multiselection: true, /*!*/    data: dataset});
grid.selection.setCell(grid.data.getId(0),"yearlyChange");grid.selection.setCell(grid.data.getId(1),"netChange", true, false);grid.selection.setCell(grid.data.getId(3),"netChange", true, false);

Related sample: Grid. Multiselection

It is also possible to select a range of cells at once:

For that, manipulate the ctrlUp and shiftUp parameters accordingly:

grid.selection.setCell(grid.data.getId(1),"yearlyChange");grid.selection.setCell(grid.data.getId(3),"density", false, true);

Related sample: Grid. Multiselection

note

Use the selection:"rows" property to be able to operate rows.

To make the process of selecting cells more flexible, you can apply the related events of the selection object:

• afterSelect
• beforeSelect

Removing selection

Starting from v7.0, you can remove selection from a selected cell/row or from highlighted cells/rows using the removeCell() method of the selection object. The method takes two parameters:

rowId	(string|number) optional, the id of a row
colId	(string|number) optional, the id of a column

// unselects all previously selected cellsgrid.selection.removeCell(); // unselects all previously selected cells of the specified rowgrid.selection.removeCell(rowId); // removes selection from the specified cellgrid.selection.removeCell(rowId, colId);

To make the process of unselecting cells more flexible, you can apply the related events of the selection object:

• afterUnSelect
• beforeUnSelect

Getting object of selected cells

To get the object of a selected Grid cell, use the getCell() method of the selection object:

var selectedCell = grid.selection.getCell();// -> {row: {…}, column: {…}}

To get the object of multiple selected cells, use the getCells() method of the selection object:

var selectedCells = grid.selection.getCells();// -> [{…}, {…}, {…}]0: {row: {…}, column: {…}}1: {row: {…}, column: {…}}2: {row: {…}, column: {…}}