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



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!