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.
Used for CalcEngineHelper
A class that allows you to quickly add calculation support for controls on a form, or usercontrol.
CalcSheet represents a single worksheet in a workbook.
Wrapper ArrayList that holds a collection of CalcSheets.
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 holds a collection of CalcSheet objects.
FormulaInfo maintains information on a single formula object.
Typed Hashtable returning FormulaInfo objects.
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.
Encapsulates the properties that are needed to support multiple families of crossed-referenced grids. This class is for internal use only.
Event argument class for the QuickValueSetEventArgs event.
RangeInfo represents a rectangle array of cells that may contain formulas, strings, or numbers that may be referenced by other formulas.
The event args for the UnknownFunction event which is raised whenever the CalcEngine encounters a function that is does not know.
A class containing data for the ICalcData.ValueChanged event.
ICalcData defines the minimal interface that a data object must support in order to use this formula engine.
Used in conjunction with RowMaxCount.
Flags the reason that quickValueSet was raised.
Specifies options for caching look up tables in HLookUp and VLookUp functions.
Delegate used to define functions that you add to the function library.
Event delegate for the FormulaParsing event
An event handler that represents the method to handle the QuickValueSetEventHandler event.
Event delegate for UnknownFunction event.
An event handler that represents the method to handle the ValueChanged event.