Ignore Exceptions due to Circular references in Formulas using Aspose Cells for Java

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.

Please let me know if you need a sample.

Thanks,
Shashi

2

Hi Shashi,

Currently we only support ignore the exception when calculate formulas, you can use Workbook.calculateFormula(), Workbook.calculateFormula(true), Worksheet.calculateFormula(boolean, true) to calculate formulas and ignore those exceptions. For doing in same way with MS Excel, we will look into it later after some important tasks on hand. Thank you