Find Volatile/Circular Formula in Excel spreadsheet

Aspose.Cells Product Family
1

Hi.

I am using Aspose Cell 18.2 Version.

There is any method/Property to find Volatile or Circular Formula in sheet.
Or
Any method to identify the Cell has Volatile or Circular Formula.

2

@arvind6014,

Thanks for your query.

I am afraid there is no such kind of API to detect if a formula is volatile or circular formula. Moreover, it might not be supported (e.g provide such an API to find circular formula) because some circular references can only be found when calculating formulas in the spreadsheet. In short, we cannot provide an API to find formulas with circular references, but it might be possible to provide API to get notified when encountering circular references while calculating formulas. So, if you think this feature is usable for you, let us know so that we may log appropriate ticket and make further investigations.

3

Hi Amjad,

Thanks for your quick reply for this.