Namespace Syncfusion.XlsIO.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.

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

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.

CalcWorkbook CalcWorkbook holds a collection of CalcSheet objects.

FormulaInfo FormulaInfo maintains information on a single formula object.

FormulaInfoHashtable Typed Hashtable returning FormulaInfo objects.

FormulaInfoSetAction Flags the reason that quickValueSet was raised.

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.

FormulaParsingEventHandler Event delegate for the FormulaParsing event

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

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

QuickValueSetEventArgs Event argument class for the QuickValueSetEventArgs event.

QuickValueSetEventHandler An event handler that represents the method to handle the QuickValueSetEventHandler 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.

UnknownFunctionEventHandler Event delegate for UnknownFunction event.

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

ValueChangedEventHandler An event handler that represents the method to handle the 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.