How to identify is a cell has nested formula in Aspose.Cells for Java

Aspose.Cells Product Family
1

Is there a way to identify if a cell has a nested formula ?

For example: I have 2 formulas: Myfunc1, MyFunc2

I assign cell A1 in a sheet the formula: =MyFunc2(MyFunc1(123))
Also, I assign cell B1 the formula: =Myfunc1(123)

Is there any direct way to identify B1 distinctly from A1?

2

@jinesh.parikhmca1983,
I am afraid that apparently, no such option is available in Aspose.Cells. You need to write your own logic to parse the formula string in the cell and fetch the required information. However, if you may provide us details about a similar feature using Excel or any other relevant library, we will analyze it and provide assistance accordingly.