Hello @songyl ,
To resolve the issue with the spreadsheet where formulas are returning errors due to data not being loaded, you can follow this approach:
After the data is loaded, findfor all reference errors in the spreadsheet. This can typically be done by iterating through the cells and looking for any errors in the formulas.
After that for each reference error found, use the refToPos function to determine the positions of the missing cells. This will help you identify which specific cells are causing the errors.
Then make a request to the server to retrieve the values of these missing cells.
Once you have the values from the server, use the setCellValue method to update the corresponding cells in the spreadsheet.