GrapeCity.Spreadsheet.CalculationEngine

CalculationEngine Class

Represents a class which store, evaluate or adjust expressions.

CalculationEngine

public sealed class CalculationEngine : IAsyncFunctionManager

Public NotInheritable Class CalculationEngine
    Implements IAsyncFunctionManager

Name	Description
CacheOptions	Gets or sets the CacheOptions value describing the caching option.
CalcFeatures	Gets or sets a CalcFeatures value indicates which calculation feature(s) is enabled.
CalculateBeforeSave	Gets or sets the property which specifies whether workbooks should be calculated as needed before saving.
Calculation	Specifies when the control should recalculate the data in the workbook.
CalculationOnDemandMode	Gets or sets the CalculationOnDemandMode value which determines how individual cells are calculated on demand.
EvaluationContext	Gets the global shared evaluation context.
Iterative	Gets or sets whether the workbook should perform iterative calculations for formulas that contain circular references.
MaximumChange	Gets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.
MaximumIterations	Gets or sets the maximum number of iterations for calculations with circular references.
ReferenceStyle	Gets or sets ReferenceStyle value which specifies whether to use A1 style or R1C1 style in cell and range references.
SuspendCalculation	Gets or sets a value indicating whether formulas are immediately calculated as dependent cells are changed.

Name	Description
Calculate()	Calculates all dirty cells in the whole workbook set.
Calculate(IWorkbook, bool, bool)	Calculates cells in the specified workbook.
Calculate(IWorksheet)	Calculates cells in the specified worksheet.
Evaluate(string, IWorksheet, CellReference)	Evaluates the specified expression using the specified evaluation context.
IsCircularCell(IWorksheet, int, int)	Determines whether the specified cell is a circular cell.
IsTrackingVisualChange()	Gets a boolean value indicating whether the visual change should notify the calculation engine.
Max(IEvaluationContext, IReferenceSource, int, int, int, int)	Gets MAX of the specified range.
Min(IEvaluationContext, IReferenceSource, int, int, int, int)	Gets MIN of the specified range.
NotifyVisualChanged(IWorkbook)	Notifies the calculation engine the visual of all worksheet in the specified workbook are repainted.
NotifyVisualChanged(IWorksheet, Reference[])	Notifies the calculation engine the visual of the specified cell range is repainted.
NotifyVisualChanged(IWorksheet, int, int, int, int)	Notifies the calculation engine the visual of the specified cell range is repainted.
Rebuild()	Rebuilds all internal data of the calculation engine.
Sum(IEvaluationContext, IReferenceSource, int, int, int, int)	Gets SUM of the specified range.
TriggerVolatileCells()	This function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate.