Does Aspose CalculateFormula() honors Formula Dependency Chain?

Aspose.Cells Product Family
1

We are using the Aspose API worksheet.calculateFormula() in our application and wanted to understand, does it follow the dependency chain?

Ex. - If the A1 cell formula depends on the B3 cell formula then do B3 cell formula will be calculated first before A1 cell formula?

2

@aduttaPlanful,

Yes, your understanding is correct. Aspose.Cells formula calculation engine calculates formulas recursively.

3

Cool. Thanks for the confirmation.

4

@aduttaPlanful,

You are welcome.