Free Support Forum - aspose.com

Formula Containing =Sheet() function is changing to #NameRef

image.png (5.6 KB)

Please find the attached sample code and excel file
Ticket.zip (5.9 KB)

@taruney,

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.

@taruney,

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.

@taruney,

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)