Hey,
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.
Scenario :
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
this.spreadsheet.sheetByName(this.targetedRangeSheetName).range(this.targetedRangeCell).value()
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?