Calc .NET is an Excel compatible formula calculation engine for .NET. It recalculates every formula of a workbook and updates the cached cell values in place, so a spreadsheet produced or edited by your code carries the same results Excel would show — without Microsoft Excel or any other third party application.
Point a CalcSession at a workbook and it walks the dependency graph, evaluates every formula in the right order and writes the results back into the cells. It handles cross sheet references, defined names, structured table references, shared and array formulas, dynamic array spilling, circular references, and more than 490 Excel worksheet functions — maths, statistics, text, date and time, lookup, information, database, financial, engineering, logical and the modern dynamic array and LAMBDA family. The result of a run tells you exactly what happened: how many formulas were found, how many were calculated, which cells are volatile, and a diagnostic for every cell that could not be calculated.
Calc .NET is a complete, self contained component. It contains the entire Spreadsheet .NET library and the entire ODF .NET library, so you do not need any other Independentsoft component to read, create, modify, calculate and save a document. Everything in the Spreadsheet .NET tutorial and the ODF .NET tutorial applies unchanged to Calc .NET — the same namespaces, the same classes, one assembly.
Calc .NET contains the complete Spreadsheet .NET library, so every example of the Spreadsheet .NET tutorial works unchanged with Calc .NET.
Calc .NET contains the complete ODF .NET library, so every example of the ODF .NET tutorial works unchanged with Calc .NET.
Spreadsheet .NET Tutorial
ODF .NET Tutorial