We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

#REF in forumula referencing listobject on other worksheet

When giving a formula to a cell that references a listobject on a different worksheet as a range, aspose results in a #REF instead of the range name.

When using the exact same formula in excel, this does reference.

Original stackoverflow thread: http://stackoverflow.com/questions/32648981/cell-formula-gives-name-error-until-user-selects-formula

Hi Koen,

Thank you for sharing the code.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET, and we are able to replicate the said issue on our side. In order to further investigate the matter and to pin point the problem cause, we have logged this incident in our bug tracking system under the ticket CELLSNET-43927. Our product team will further look into the details of this problem and we will keep you updated on the status of correction. We apologize for your inconvenience.
Thanks for your reply.
Where can I find the bug tracking system so I can follow up on it?


Thanks for your posting and using Aspose.Cells.

You cannot track your issue status except that you can see if it is resolved or not resolved by seeing the link tag in the very first post of this thread.

We have also checked your issue status. We are afraid, your issue is not resolved. We have also requested the product team to consider and fix your issue or provide ETA for this. Please spare us some time. Once, there is some news for you, we will let you asap.

Also, you can ask for a status from us anytime then we will check it from database and update you with latest updates. Mostly when updates are available, we provide it ourselves and users don’t need to ask us.


This is to inform you that we have fixed your issue CELLSNET-43927 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Thank you.


Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.6.0.4 and let us know your feedback. .

The issues you have found earlier (filed as CELLSNET-43927) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.