Namespace Syncfusion.Calculate

Classes

CalcEngine CalcEngine encapsulates the code required to parse and compute formulas. Hashtable properties maintain a Formula Library of functions as well as a list of dependent cells. You can add and remove library functions.

CalcEngineHelper Used for CalcEngineHelper

CalcQuickBase A class that allows you to quickly add calculation support for controls on a form, or usercontrol.

CalcSheet CalcSheet represents a single worksheet in a workbook.

CalcSheetList Wrapper ArrayList that holds a collection of CalcSheets.

CalculateConfig CalculateConfig serves as a Configuration class for the calculate library. In the current version, there are no explicit settings. Adding this component from the tool box allows you to easily configure your project for calculate support.

CalcWorkbook CalcWorkbook holds a collection of CalcSheet objects.

FormulaInfo FormulaInfo maintains information on a single formula object.

FormulaInfoHashtable Typed Hashtable returning FormulaInfo objects.

FormulaParsingEventArgs Used by the FormulaParsing event, FormulaParsingEventArgs holds a reference to the string that is to be parsed. The FormulaParsing event allows the listener to preprocess the string that is being parsed.

GridSheetFamilyItem Encapsulates the properties that are needed to support multiple families of crossed-referenced grids. This class is for internal use only.

QuickValueSetEventArgs Event argument class for the QuickValueSetEventArgs event.

RangeInfo RangeInfo represents a rectangle array of cells that may contain formulas, strings, or numbers that may be referenced by other formulas.

UnknownFunctionEventArgs The event args for the UnknownFunction event which is raised whenever the CalcEngine encounters a function that is does not know.

ValueChangedEventArgs A class containing data for the ICalcData.ValueChanged event.

Interfaces

ICalcData ICalcData defines the minimal interface that a data object must support in order to use this formula engine.

ISheetData Used in conjunction with RowMaxCount.

Enums

FormulaInfoSetAction Flags the reason that quickValueSet was raised.

LookupCachingMode Specifies options for caching look up tables in HLookUp and VLookUp functions.

Delegates

CalcEngine.LibraryFunction Delegate used to define functions that you add to the function library.

FormulaParsingEventHandler Event delegate for the FormulaParsing event

QuickValueSetEventHandler An event handler that represents the method to handle the QuickValueSetEventHandler event.

UnknownFunctionEventHandler Event delegate for UnknownFunction event.

ValueChangedEventHandler An event handler that represents the method to handle the ValueChanged event.