• Build a Business Calculator

    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.

  • Out-of-the-Box Expression Parser

    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.

  • Deliver More of an Excel Experience

    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.

Formulas Support an Extensive, Built-in Function Library

  • Functions include Aggregate, Date and Time, Logical, Math and Trigonometry, Text.
  • Supports custom functions
  • Supports globalization

Cross-sheet References and Computation

Parse and compute algebraic expressions, mathematical functions, and formulas using variables and across multiple spreadsheets or controls.

Compute Expressions from Grids and Spreadsheet Controls

  • Bind CalcEngine to business objects, collection views, dynamic types, Entity Framework and DataTables.
  • Load Excel data into arbitrary data grid control, such as FlexGrid, and show computed values in cells.