We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Calling refresh() removes custom functions from spreashseet

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?

2 Replies

VR Vasanth Ravi Syncfusion Team December 10, 2022 04:16 PM UTC

John, 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.

Feedback Portal Link: https://www.syncfusion.com/feedback/39711/calling-refresh-removes-custom-functions-reference-from-spreadsheet

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."

VR Vasanth Ravi Syncfusion Team December 29, 2022 11:22 AM UTC

Hi John,

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).

Package: https://www.npmjs.com/package/@syncfusion/ej2-spreadsheet

Feedback link: https://www.syncfusion.com/feedback/39711/calling-refresh-removes-custom-functions-reference-from-spreadsheet

Please let us know if you need further assistance on this.


Vasanth R

Live Chat Icon For mobile
Up arrow icon