Formula value calculation before render

[sanchit3008]

Is your feature request related to a problem? Please describe.
Suppose I have a list of formulae for each cell, there should be a way for the sheet to calculate values for these cells without providing it manually for the first render.

Describe alternatives you've considered
ref.current.setCellValue works fine for small sheets but for 10000+ formulae it runs into issues as the state updates after every call to setCellValue which causes the sheet to rerender the same number of times- leading to the state being updated while the sheet is being rerendered resulting in a warning.

Please let me know if this is not an issue and there is a workaround. Thanks.

[sanchit3008]

This problem boils down to how to set values for multiple cells but render only once

[sanchit3008]

I have a suggestion for this - a dependency graph of cells can be made, and then a memoized recursive function can be written to calculate the value for each cell based on what has already been calculated / is a static value.