Provide formula tree to allow recalculation

[gedw99]

At the moment there is no engine to do formula recalculation.

I propose the ability to determine the tree calculation

It would also then make it possible for a change to a cell in a formula tree to cause all dependent cells to reapply their formula and hence update their cell contents

[Sireax]

Yeah, adding recalculation engine would be really helpful.
Could you suggest temporary solution for my problem?

I need to open Excel file, change some fields and then get calculated value from another cell. I tried to just change the value and do calculation, but CalcCellValue() returns the initial value, like before the update

[xuri]

Thanks for the suggestion, maybe add this feature after the formula function has been implemented.

[alexvr8282]

I tried to use UpdateLinkedValue but i don't obtain the correct value that it depends from evaluating a serie of formula

[AngangGuo]

Are there any progress about this issue?
I noticed that there're lots of the formula functions have been implemented. Maybe add a function to check all the formula in a spreadsheet. Update them if these functions are implemented. Return error if there're any unknown functions.

[AngangGuo]

This is my temp solution for now:

When opening the file in Excel, I can re-calculate all the formulas manually by pressing Ctrl+Alt+Shift+F9.