Circular Reference

Aspose.Cells Product Family
1

Hi,

I have an excel workbook having formulas with Circular references.


Currently users go to the Excel Menu option ->Tools | Options and click the Calculation tab --> click the iteration checkbox and then for all circular references,Excel resolves the formulas automatically.

In Aspose Cells, this is currently throwing a circular reference exception.


Is there any way we can do the same thing in aspose cells.
We are unable to read and recalculate the uploaded workbook due to the above limitation.

Thanks,
Satish

This message was posted using Aspose.Live 2 Forum
2

Hi Satish,

Kindly create a console demo application, zip it and post it here to show the issue, we will check it soon.

Thank you.

3

Sorry I can't send you the sample. Some what I tried to resolve but i am getting

'' Stack OverFlow exception" while Calculating Formula.

kindly please help on this.

Thanks

Satish

4

Hi,

I am afraid, we need your sample application to reproduce the issue, you may click “Keep this post private” checkbox when answering the post in this thread, thus only you and Aspose staff members would be able to see/download your attachments, no other users would see/download your post.

By the way, I have attached latest fix v5.0.0.13 here for you to try. Kindly try it and give us your feedback.

Thank you.