We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Visual Studio Icon
.NET 8.0 support now available

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The WPF Calculation Engine library allows you to add extensive calculation support to your business objects, and easily set up forms that have calculation dependencies among various controls. It includes a function library of more than 400+ Excel-compatible functions, covering calculations for databases, dates and times, engineering, finances, and much more. In addition, the library provides support for named ranges, dynamic references, cross-sheet references, array formulas, and formula dependencies. When used in conjunction with our .NET Excel library (Essential XlsIO), you can fully load, manipulate, and compute Excel worksheets with no dependence on Excel.


Extensive calculations without Excel

Parse and compute expressions and formulas using Calculation Engine

Working with calculation engine

Efficiently parse and compute formulas using the Calculation Engine. It manages several hash tables, such as tables for formula information, dependent cells, dependent formula cells, named ranges, and library functions for calculations. It has several properties for calculating business objects, including Excel-like formula computation; parsing separators like decimals, arguments, and data time; logical operator calculation; and much more. Also, ICalcData provides methods for performing calculations by raw numbers or cell references, retrieving cell values or cell references, and updating cell values based on dependent cells.

Compute expressions and formulas with values and variables using CalcQuickBase

Working with values and variables

Supports parsing and computing formulas directly with values or variables using CalcQuickBase. Additionally, register variable names that can later be used in more complex formulas, and perform manual or automatic calculations.

Perform calculations by defining names for a cell or range of cells

Named Ranges

Define names for a cell, a range of cells, formulas, constants, or tables to easily identify the purpose of cell references. The library also supports adding, removing, and managing named ranges.


Functions

Built-in functions

The Calculation Engine is preloaded with more than 400+ Excel-compatible functions covering a broad range of business scenarios. The available functions range from standard mathematical functions such as cosine and sine, to statistical functions like averages and standard deviations, and even financial functions like declining balance and future value.

Custom functions

Easily add a custom function with your own business calculations by registering it with CalcEngine, and easily replace or remove it as needed.


Working with .NET Excel library (Essential XlsIO)

The Syncfusion .NET Excel library allows users to create, read, edit, and protect Excel documents in .NET applications without Microsoft Office. Additionally, it supports performing calculations in Excel workbooks by using the Calculation Engine. Calculations can be suspended to optimize performance while a series of changes are made to dependent cells either by the user or programmatically.


95+ WPF CONTROLS

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Transform your applications today by downloading our free evaluation version Download Free Trial

Syncfusion WPF Resources

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Up arrow icon
Live Chat Icon For mobile