Getting wrong cell formula for cell

Aspose.Cells Product Family
1

an excel I have has in sheet “Sheet1” cell F8
a formula
=Table1[[#This Row],[b]]*2
but with aspose java
cell.getFoemula() returns
=[@b]*2
I need a way to get the actual formula text “=Table1[[#This Row],[b]]*2”

2.xlsx.zip (7.9 KB)

2

@turaaa,

Thanks for the template file and details.

I have checked your template file by opening it into MS Excel 2013 and found F8 cell in worksheet “Sheet1” has formula “=[@b]*2” in it, see the screenshot for your reference:

So, I do not think it is an issue with Aspose.Cells APIs. If you still think Aspose.Cells has issue with retrieving formula, kindly do provide more details, screenshots and sample code, we will check it soon.