Essential Grid supports Excel-like formulas on each cell. It also supports cross-sheet references and named ranges. You can easily add custom functions to its function library. Setting the cell type of a cell to a formula cell will allow you to enter algebraic expressions and cell references. Cell references are entries such as A11 for column A row 11 or BA3 for column BA row 3. A formula is a defined calculation from the Formula Library, which is included with Essential Grid. This Formula Library is extensible and allows you to add additional formulas.
The different samples that illustrate the Formula Support features of Essential Grid are listed below:
Formula Grid Demo- Implements a grid control that can have algebraic formulas in its cells and displays all the functions in the GridFormulaEngine function library.
Formula Range Selection Demo- Defines a class called FormulaRangeSelectionController, which allows you to apply formulas to selected range of cells.
Cross-Reference Demo- Illustrates making cross-sheet references between grids.
Named Range Demo- Illustrates the use of multiple sheet references and named ranges with the GridFormulaEngine.
Retirement Simulation Demo- Illustrates a way to use GridFormulaEngine.NamedRanges in a grid control.