Posted 13 December 2024, 8:24 am EST
Hello,
There is a table binding to a data array. By directly changing the data array, the value display of the table on the worksheet will also change. This is very useful.
However, formula cells that reference values on the table are not re-calculated. I expect this is probably because the dirty flag indicating changes in the values on the table did not change. Is there a way to make data-binding cells dirty for recalc?
For an example, using the demo below, I set D4 cell to a fomula “=C4*2” as a result of the doubled age. When I change a vlue in the Age textbox, the re-calculation of D4 doesn’t work.
https://developer.mescius.com/spreadjs/demos/features/data-binding/cell-level-binding/purejs
