|
|
CalcDataGrid simple
The CalcDataGrid class in Essential Calculate gives you easy way to add calculation support to a Windows Forms DataGrid.
|
|
|
|
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.
DataGrid with Sum formula
All four cells in the bottom row hold a Sum formula, two cell are showing their computed values and two cells are showing their formulas.
|
|
|
|
Essential Calculate can manage multiple DataBoundGrid objects. You can have formulas that reference values in one grid from another grid.
Cell A1 of Multiple Sheets
Essential Calculate 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).
Applying Formula to calculate the sum of values in Cell A1 of multiple sheets
DataBoundGrids on multiple tabs after calculating the sum of cell A1 from multiple sheets
Cell A1 in the first tab holds the formula to calculate the sum of cell A1 from multiple sheets.
|
|
|
|
|
|
|
