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.