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.