We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

calculateFormula StackOverflowError

Hi,
We are getting StackOverfloError when calculating formulae of our Excel spreadsheet. We are using Aspose Cells for Java 7.0.4 (also 7.1.0). I’ve attached a small test case (java and xlsx).
The xlsx file opens (and calculates) fine in Excel.

Thanks in advance,

Hi,

Thanks for the sample code and template file.

I can find the exception by running your JAVA program with your template file. I have logged a ticket with an id:
CELLSJAVA-40117. We will look into your issue soon.

Thank you.

Hi,


Please try our latest version/fix: Aspose.Cells for Java v8.0.1.4

Please use smaller value for
WorkbookSettings.CalcStackSize, such as:<o:p></o:p>

e.g

Sample code:

wb.getSettings().setCalcStackSize(100);

wb.calculateFormula();