JCalc is an Excel compatible formula calculation engine for Java. 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.
JCalc is a complete, self contained library. The jar contains the entire JSpreadsheet library and the entire JODF library, so you do not need any other Independentsoft jar to read, create, modify, calculate and save a document. Everything in the JSpreadsheet tutorial and the JODF tutorial applies unchanged to JCalc — the same packages, the same classes, one jar.
JCalc contains the complete JSpreadsheet library, so every example of the JSpreadsheet tutorial works unchanged with JCalc.
JCalc contains the complete JODF library, so every example of the JODF tutorial works unchanged with JCalc.
JSpreadsheet Tutorial
JODF Tutorial