Formula Support

Essential Grid supports MS 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.

A Formula in a Grid control refers to a well-defined algebraic expression based on grid cell values or functions of the Function Library enclosed in Grid Framework. Complete formula support is provided in GridControl using Formula Cells.

Every cell in a grid (or a few specific cells) can be defined as a Formula Cell. The default setting of the Grid Control treats all Formula cells as Text Boxes unless the cell value is prefixed with an 'equal' sign.

Unique names can be assigned to a single cell or cell range and used in formulae or cells within a grid.

A formula cell can be defined with values referenced from another grid. In such cases, multiple grids can either be in worksheet format or individual grids layed out on a form.

Essential Grid comes with an extensive Formula Function Library whose functions can be nested in expressions. In addition to existing functions, custom functions can also be defined and included. The Essential Grid Formula Engine has helper methods that can be used to retrieve lists of values and compute formulas to manage custom functions.