Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / CalculationEngine Class
Properties Methods


In This Topic
    CalculationEngine Class Members
    In This Topic

    The following tables list the members exposed by CalculationEngine.

    Public Properties
     NameDescription
    Public PropertyCacheOptionsGets or sets the CacheOptions value describing the caching option.  
    Public PropertyCalcFeaturesGets or sets a CalcFeatures value indicates which calculation feature(s) is enabled.  
    Public PropertyCalculateBeforeSaveGets or sets the property which specifies whether workbooks should be calculated as needed before saving.  
    Public PropertyCalculationSpecifies when the control should recalculate the data in the workbook.  
    Public PropertyCalculationOnDemandModeGets or sets the CalculationOnDemandMode value which determines how individual cells are calculated on demand.  
    Public PropertyEvaluationContextGets the global shared evaluation context.  
    Public PropertyIterativeGets or sets whether the workbook should perform iterative calculations for formulas that contain circular references.  
    Public PropertyMaximumChangeGets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.  
    Public PropertyMaximumIterationsGets or sets the maximum number of iterations for calculations with circular references.  
    Public PropertyReferenceStyleGets or sets ReferenceStyle value which specifies whether to use A1 style or R1C1 style in cell and range references.  
    Top
    Public Methods
     NameDescription
    Public MethodCalculateOverloaded. Calculates all dirty cells in the whole workbook set.  
    Public MethodEvaluateEvaluates the specified expression using the specified evaluation context.  
    Public MethodIsCircularCellDetermines whether the specified cell is a circular cell.  
    Public MethodIsTrackingVisualChangeGets a boolean value indicating whether the visual change should notify the calculation engine.  
    Public Methodstatic (Shared in Visual Basic)MaxGets MAX of the specified range.  
    Public Methodstatic (Shared in Visual Basic)MinGets MIN of the specified range.  
    Public MethodNotifyVisualChangedOverloaded. Notifies the calculation engine the visual of the specified cell range is repainted.  
    Public MethodRebuildRebuilds all internal data of the calculation engine.  
    Public Methodstatic (Shared in Visual Basic)SumGets SUM of the specified range.  
    Public MethodTriggerVolatileCellsThis function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate.  
    Top
    See Also

    Reference

    CalculationEngine Class
    GrapeCity.Spreadsheet Namespace
    System.IDisposable