Spreadsheet calculation

Formula Engine

Give grid cells relationships, functions, and repeatable recalculation.

Explore source ↗

Parent systemProDataGrid

StatusActive

Modules2

RepositoryProDataGrid/ProDataGrid.FormulaEngine

Capability

A calculation layer for parsed expressions, cell references, dependency tracking, functions, recalculation, and Excel-oriented interoperability.

01
Parsed formulas and functions
02
Cell and range references
03
Dependency-driven recalculation
04
Excel compatibility package

How it composes

From intent
to working system.

Parse

Formula text becomes a typed expression tree.

Resolve

Names, cells, ranges, and functions bind against a workbook context.

Calculate

Dependencies determine evaluation order and invalidation.

Present

Grid integrations expose values, errors, and formula editing.

Quick start

Adopt this
capability.

Start with the primary module, then add the related packages only when the application needs those layers. Replace VERSION with the current NuGet version.

dotnet add package ProDataGrid.FormulaEngine

<PackageReference Include="ProDataGrid.FormulaEngine" Version="VERSION" />

<PackageVersion Include="ProDataGrid.FormulaEngine" Version="VERSION" />

var workbook = new FormulaWorkbook();
workbook.SetValue("A1", 40m);
workbook.SetValue("A2", 2m);
workbook.SetFormula("A3", "=SUM(A1:A2)");

var total = workbook.GetValue("A3");