ComponentOne WinForms CalcEngine
Parse and evaluate Excel-like expressions in .NET applications.
- Supports runtime parsing and evaluation of complex Excel-style expressions.
- Includes extensive built-in and custom function support.
- Enables data binding and cross-sheet references for multi-source computations.
Prices from:
| Available in | |
|---|---|
| ComponentOne Studio WinForms | Loading |
| ComponentOne Studio WinForms Data Services Edition | Loading |
| ComponentOne Studio Enterprise | Loading |
Runtime Expression Parsing
CalcEngine parses and evaluates expressions at runtime using a syntax similar to Microsoft Excel, enabling dynamic computation within .NET applications without pre-compilation.
Comprehensive Function Library
It includes a wide range of built-in functions such as math, text manipulation, date and time, logical operations, conversion, and aggregate calculations, resembling Excel's function set.
Custom Function Support
Developers can extend CalcEngine by adding custom functions, allowing tailored calculations specific to application needs while leveraging the standard calculation framework.
Data Binding with Collections
CalcEngine supports binding to data sources like business objects, lists, arrays, and DataTables, facilitating calculations based on properties or fields of objects in collections.
Cross-Sheet Referencing
It allows formulas to reference and calculate values across multiple data sheets or data sources by using worksheet-style notation.
Integration with FlexGrid
The engine integrates with ComponentOne's FlexGrid control to enable Excel-style formula bars and computed cell values within data grid interfaces.
Error Handling and Evaluation Methods
CalcEngine provides methods such as TryEvaluate to safely compute expressions, returning detailed error information when evaluation fails to assist in debugging and validation.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Component Type
- .NET
.NET Version
- .NET 10 LTS
- .NET 9 STS
- .NET 8 LTS
- .NET 6 LTS
- .NET 4.8 or earlier
.NET Platform
- .NET Assembly
- .NET Class
- .NET WinForms
IDE Support
- Visual Studio
About MESCIUS
MESCIUS, formerly known as GrapeCity, is a leading developer-focused brand established in Japan, with a history spanning over 30 years. It is recognized for its extensive suite of software components, including reporting frameworks, spreadsheet libraries, and Japanese market-oriented input controls. Popular products such as ActiveReports, SPREAD, InputMan, and ComponentOne support both .NET and JavaScript ecosystems and are widely used in business-critical applications. MESCIUS offers distinctive advantages such as proven reliability, comprehensive Japanese localization, and strong technical support, making it a trusted choice for IT professionals and software developers building complex and localized systems.
As official and authorized distributors since 1996, ComponentSource supplies you with legitimate licenses directly from MESCIUS.