Calling refresh() removes custom functions from spreashseet

[John]

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?

[Vasanth Ravi]

John, we have checked your reported issue and confirmed this as a defect. The fix will be available in our December – 28^th, 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."

[Vasanth Ravi]

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.

Regards,

Vasanth R