|
Multiple DataGrids gridreferences
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.
|
|
|
|
