excelize Provide formula tree to allow recalculation

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

Jan 02 '21 23:01 gedw99

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

Feb 19 '21 15:02 Sireax

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

Feb 20 '21 05:02 xuri

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

Feb 02 '22 14:02 alexvr8282

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.

May 10 '22 22:05 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.

May 11 '22 16:05 AngangGuo