jQuery grid supports the following commonly used Excel formulas.
In formulas, references to cells or range of cells are supported in this format.
- Absolute cell references e.g., $A$2, A$2, $A2, $A$1:$D$5, $A:$C, $5:$10 etc.
- Relative cell references e.g., A2, A1:D5, A:A, 6:8, etc.
If you found any commonly used formulas absent from the list,
please let's know to consider them for addition in future versions.