Hi,
I am using 4.7.1 Cells.
When I run workbook.calculateformula() any array formula's I have return a Value. When I open in excel it is fine.
I have recreated the issue on a simple workbook which I attach.
The code I am using for this test is:
Dim license As Aspose.Cells.License = New Aspose.Cells.License()
license.SetLicense("Aspose.Total.lic")
Dim wbk As Workbook = New Workbook
wbk.Open("c:\arrtest.xls")
wbk.CalculateFormula()
MsgBox(wbk.Worksheets(0).Cells("g120").Value)
It returns #VALUE.
If I comment out the CalculateFormula line it returns the correct value.
I hope you can help,
Oli