We have an existing presentation which contains a chart with two worksheets and formulas. The second sheet (Chart) references data from the first one (Data) and when CalculateFormulas is called it throws a CellCircularReferenceException but there is no circular reference. All formulas are on the second sheet and are all referencing data from the first sheet.
Attached is a project which reproduces the issue:
AsposeSlidesChartFormula.zip (36.3 KB)
I think the issue is that Chart!C2 references Data!C2 and the different sheet name is not taken into account when detecting circular references.
@kaiwachter,
Thank you for reporting the issue.
I’ve reproduced the problem with calculating formulas in the chart and added a ticket with ID SLIDESNET-43553 to our issue-tracking system. We apologize for any inconvenience. Our development team will investigate the case. You will be notified when a new release of Aspose.Slides with a fix is published.
The issues you found earlier (filed as SLIDESNET-43553) have been fixed in Aspose.Slides for .NET 24.8 (ZIP, MSI, NuGet, Cross-platform).
You can check all fixes on the Release Notes page.
You can also find the latest version of our library on the Product Download page.