Formulas Support an Extensive, Built-in Function Library
- Functions include Aggregate, Date and Time, Logical, Math and Trigonometry, Text.
- Supports custom functions
- Supports globalization
Using CalcEngine, you can build a custom calculator unique to your business objects. For example, let users select objects or fields and then use CalcEngine to perform mathematical equations against them.
Save development time not only evaluating the expressions, but mostly not having to write your own expression parser. CalcEngine supports parsing text expressions that follow the Microsoft Excel format.
While FlexGrid delivers the datagrid experience from Microsoft Excel, the CalcEngine provides the formula bar functionality for any custom desktop application. Plus, with CalcEngine you can create editable expressions for any UI - not just a datagrid.
Parse and compute algebraic expressions, mathematical functions, and formulas using variables and across multiple spreadsheets or controls.