i have something where two table are interconnected in excel.
for eg. table 1 is about salary and table 2 is about expenses and somewhere in table2 i want to calculate something using values from table1 in formula like “=C9/‘Salary’!C2*‘Tax’!$B$29” .
the formula plugin doesn’t support that yet but you can use getDataAtCell/
setDataAtCell methods. Here’s a demo https://jsfiddle.net/1dLzb7st/
I’ve packed the logic into an
afterChange hook to get the SUM updated.