Expand All

Basics

Formatting

Context menu

Drag n Drop

Spreadsheet

Tabs

Export

Layouts

RTL Layout

Rows

Paging

Big data

Columns

Cells

Inline editing

Row Grouping

Pivot

Sorting

Filter

Selections

Nesting / Row details

Tree grid

Charts

Angular

React React

Vue Vue

Knockout

;

Read only cells

The grid cells can be selectively made read only depending upon any arbitrary run time condition.

Read only cells can't be modified with inline editing or paste of data.

In this example, the read only cells are shown as disabled in "Company Name" and "Contact Name" columns and are dependent upon values in Country column. ( run time condition ).

editable: function (ui) {
    var country = (ui.rowData.Country || "").toUpperCase();
    //make cell read only if country in this row is present in countries list. 
    return ($.inArray(country, ['SPAIN', 'UK', 'USA']) === -1);
}