Formulas Support an Extensive, Built-in Function Library
- Functions include Aggregate, Date and Time, Logical, Math and Trigonometry, Text.
- Supports custom functions
- Supports globalization
CalcEngine: Expression Parser for .NET
Parse and evaluate expressions like Microsoft Excel with CalcEngine for .NET Standard.
- Calculate the sales projections or statistical calculations to find patterns in data
- Load data from Microsoft Excel into a datagrid and show computed values in cells
- Evaluate algebraic expressions, mathematical functions, and formulas using variable
- The first release 2020 v1 is Beta
-
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.
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.
When I run into complex problems, I turn to my ComponentOne Studio Enterprise toolbox.
Ken Spenser, Microsoft Regional Director - Framework Masters
I love to use C1 components! I can be confident that if I need to do a particular task, ComponentOne will have the control to do the job.
Silv Sordello, Software Developer
As an ISV, I need tools that allow me to be competitive. Therefore, it's a must to use reliable and stable tools for customized solutions...ComponentOne provides all that to me and even more!
Dennis Wallentin, Microsoft MVP (Excel)
Easier to use right off the bat. I liked using the Scheduler for drag-and-drop capability.
Michelle Gibson, Software Engineer