I’ve just had a problem calculating a worksheet with Aspose Cells for Java 7.7.1. I finally tracked it down to a formula using HLOOKUP. The formula was
Could you provide us your template file and sample code to reproduce the issue on our end regarding HLOOKUP formula/function, we will check it soon.
Also, kindly download and try our latest version/fix: Aspose.Cells for Java (Latest Version) if it makes any difference.
I’ve tried 220.127.116.11 and the problem still occurs. I’ve attached a simple workbook which has the problem formula in D6.
Thank you for providing the sample spreadsheet.
We are able to observe the said exception (com.aspose.cells.CellsException: null) while using the latest build of Aspose.Cells for Java 18.104.22.168 with your sample file. A ticket (CELLSJAVA-40756) has been logged in our bug tracking system to probe further into this matter. Please spare us little time to properly analyze the problem cause, and to provide a fix at earliest. In the meanwhile, we will keep you posted with updates in this regard.
Thanks for using Aspose.Cells for Java.
We have fixed this issue.
Please download and try the latest version: Aspose.Cells
for Java v22.214.171.124 and let us know your feedback.
Thanks - that’s fixed it.