I am having the Latest Version of “Formula” in my excel worksheet.
Which is as follow:
In Excel 2019 It is: “=TEXTJOIN(”-",TRUE, I27,I28)".
In Excel 2007 It Is: “=_xlfn.TEXTJOIN(”-",TRUE, I27,I28)"
Both are formula and Excel is returning them as Formula but aspose cells is not able to consider the formula as “Formula” in any of the version.
It’s cell.IsFormula Method returns False as it’s not considering as formula.