I’m currently working on a project where I’ve ported the generation from Apache POI to Aspose.Cells. So far everything works fine. But before saving the document I’ve to calculate the workbook.
So I call workbook.calculateFormulas(false) and then I try to get a value from a cell. The value I get is #VALUE!
What am I doing wrong?
I need your help please!
Thanks for your posting and considering Aspose.Cells for Java.
We need your source xls/xlsx file and sample code to test your issue by running it. Please provide.
Please also try the latest version:
Aspose.Cells for Java v18.104.22.168
and see if it solves the problem.
I attached my source file and a sample sourcecode which reproduces my problem.
Any help is appreciated.
Oh yes, sorry I forgot to remove the protection.
The password is genByPOI