1.基于性能考虑，使用了分页加载数据。参加示例如：Code Snippet
2.单元格里定义了计算公式，如: =Sheet2!C5+C4 ;因为sheet2页的数据还没加载出来，导致计算结果不对。
针对上述现象，有好的解决办法吗？
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.