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

Aspose.Cells Product Family
,
1

image.png (5.6 KB)

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

2

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

3

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

4

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

5

The issues you have found earlier (filed as CELLSNET-47710) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao