|
|
CalcDataGrid - simple to use Windows Forms DataGrid support
When used with Essential XlsIO, Essential Calculate gives you Excel functionality without Excel.
|
|
|
|
The CalcDataGrid class lets you support calculations on a Windows Forms DataGrid. You can use Excel-like formulas to calculate values depending upon other cell values.
|
|
|
|
Essential Calculate can manage multiple DataBoundGrid objects. You can have formulas that reference values in one grid from another grid.
Essential Calculate also provides support for sheet ranges. Setting the property CalcEngine.SupportsSheetRanges to true makes the engine supports sheet ranges like =SUM(Sheet1:Sheet3!A1) and =SUM(Sheet1:Sheet3!A1:B4).
|
|
|
|
|
|
|