This sample implements a grid control that can have algebraic formulas in its cells.
Features
GridFormulaCellModel class gives access to a formula library of functions with its formula engine support.
This sample lists the library functions that ship with the formula engine.
It also has an example of how you can add your own calculations to the library.
The following code illustrates how to display GridAwareTextBox above the grid. above the grid.
private GridAwareTextBox textBox1; this.textBox1.WireGrid(this.gridControl1);
The grid-aware text box internally binds to the current cell of the grid and allows you to make changes to the grid cell through the text box.
Interactive Features
The formulae are similar to Excel formulae. For using formula in a cell, set the cell type to FormulaCell.
You can specify the formulae in the cell through the GridStyleInfo.Text property.