Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What algorithm does Excel use to recalculate formulas?

Are the formulas represented in a syntax tree then recalculated using a design pattern like the Visitor pattern? How would you go about reproducing the recalculation process in code?

like image 208
David Robbins Avatar asked Feb 03 '26 23:02

David Robbins


1 Answers

Resolver One was a spreadsheet developed using IronPython.

Its source code has been released as Dirigible Spreadsheet. There used to be an article that described its overall algorithm:

enter image description here

like image 166
Esteban Küber Avatar answered Feb 05 '26 13:02

Esteban Küber