Basics

Formatting

Context menu

Drag n Drop

Spreadsheet

Tabs

Export (csv, html, pdf, xlsx )

RTL Layout

Layouts

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

;

Column dependencies:

rowTemplate

This example sets up dependencies between grid columns by using rowTemplate option.

rowTemplate is different than js formulas in following ways:

  • This option uses native getters and setters feature of javascript and so the values are computed only when they are accessed e.g., when the view is scrolled, only the cells lying in the viewport are updated.
  • Two way dependency can be set up with use of rowTemplate setters.

In this use case, values in a column are dependent upon corresponding row values in one or more columns.

Result of rowTemplate getters are treated as normal data of the grid and so they work seamlessly with sorting, filtering, grouping, treegrid, etc.

In this example:

  • Total is dependent upon Domestic & Exports
  • Profits is dependent upon Total ( result of 1st formula ) & Expenditure.