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:

Javascript formulas

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

These are used when values in a column are dependent upon corresponding row values in one or more columns.

Result of these formulas are treated as normal data by 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.

Note:

Similar use case can also be solved by using either Excel formulas or rowTemplate, two other very powerful features of ParamQuery grid.