In This Topic
CalcEngine offers many advanced features, which are listed as follows:
- Extensive built-in library
CalcEngine provides an extensive built-in function library which supports formulas. These functions include Aggregate, Date and Time, Logical, Math, Text, Trigonometry, and custom functions.
- Cross-sheet reference and computation
CalcEngine can parse and compute algebraic expressions, mathematical functions, and formulas using variables and across multiple spreadsheets or controls.
- Compute expressions from grids and sheets
CalcEngine can be bound to business objects, collection views, dynamic types, Entity Framework and DataTables. It can also be used to load Excel data into arbitrary data grid control, such as FlexGrid, and show computed values in cells.