If I call refresh() on my spreadsheet object, any cells that uses custom functions will display as #NAME, when they were previously working. I can add the functions back using addCustomFunction() and it works again. Is that the intended behavior?
Also, how can I cause the entire spreadsheet recalculate itself? One of my custom functions references external data that impacts the function result value. If that external data changes, I need the spreadsheet to recalculate any cells that use the custom function. This is why I was calling refresh(). Is there a better way?
VRVasanth Ravi Syncfusion Team December 10, 2022 04:16 PM UTC
we have checked your reported issue and confirmed
this as a defect. The fix will be available in our December – 28th, 2022
patch release. You can track the
status of this defect using the link below from our feedback portal.
Disclaimer: "Inclusion of this solution in the weekly
release may change due to other factors including but not limited to QA checks
and works re prioritization."
VRVasanth Ravi Syncfusion Team December 29, 2022 11:22 AM UTC
We are glad to announce that our weekly
patch release (20.4.40) is rolled out. And we have included the fix for the
reported issue in this release. So, kindly upgrade your package versions
to the latest to avail of these changes (20.4.40).