In the context of our application, we need to extract a specific cell's value anywhere in the spreadsheet.
However, calculated cells from the not activeSheet don't seem to be updated unless we switch the actual sheet.
Les say we have Sheet1 and Sheet2
A1 in Sheet1 is our targeted cell which we re-fetch the value onChange of the spreadsheet component with : this.spreadsheet.sheetByName(this.targetedRangeSheetName).range(this.targetedRangeCell).value();
If A1 is a formula like =SUM(B1:B3), when we change something in B1, B2 or B2, onChange is triggered and we re-fetch our targeted cell's value, which matches the value we would expect.
However, if the formula of Sheet1 A1 is something like : =SUM(Sheet2!B1:B3), if we change someting in Sheet2's B1, B2 or B3, onChange is trigger but
returns the old value.
How can I an updated value of Sheet1!A1 without switching the activeSheet to Sheet1? Is there a way to trigger the calc on Sheet1?