image.png (5.6 KB)
Please find the attached sample code and excel file
Ticket.zip (5.9 KB)
Please notice, I am able to reproduce the issue as you mentioned by using your sample code with your template file. I found formula containing “=Sheet()” function is changing to “#NAME?”. I have logged a ticket with an id “CELLSNET-47710” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
Please try our latest version/fix: Aspose.Cells for .NET v20.11.2 (attached)
Your issue should be fixed in it.
Let us know your feedback.
Aspose.Cells20.11.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.11.2 For .Net4.0.Zip (5.4 MB)