java.util.EmptyStackException on com.aspose.cells.Workbook.calculateFormula

Aspose.Cells Product Family
1

Hi,

When performing a calculateFormula operation we are getting the following exception.

java.util.EmptyStackException
at java.util.Stack.peek(Stack.java:79)
at java.util.Stack.pop(Stack.java:61)
at com.aspose.cells.z.a(Unknown Source)
at com.aspose.cells.z.a(Unknown Source)
at com.aspose.cells.Cell.a(Unknown Source)
at com.aspose.cells.Cell.b(Unknown Source)
at com.aspose.cells.Cell.getFormula(Unknown Source)
at com.aspose.cells.Cell.c(Unknown Source)
at com.aspose.cells.Worksheet.a(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at com.tms.basefw.report.paging.workbook.impl.CustomWorkbook.save(CustomWorkbook.java:141)

Please guide on what the problem cause could be.

Thanks & Regards,
Sandeep Bansi Jumani

2

Attached is the dat file that Kailas Kore asked us to provide with any issue.

Regards,

Sandeep Bansi Jumani

3

Hi Sandeep Bansi,

Could you post your source excel file, we will check your issue soon.

Thank you.

4

Hi,

Thanks for the reply.

I have commented the Caluclate formula part before saving the wrokbook and hence I was able to generate the Excel. I have also uploaded the file.

Expecting your reply

5

Hi,

Thank you for sharing your template file. We will check it for your mentioned issue and get back to you.

Thank You & Best Regards,

6

Hi,

Thank you for considering Aspose.

We have tested your template file with the latest version of Aspose.Cells for Java and CalculateFormula() works fine. Please try the attached latest version of Aspose.Cells. Also, following is our test code,

Test Code:

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Open Template File

workbook.open("E:\\Excels\\2v8w1MQqeg\\2v8w1MQqeg.xls");

//Calculate workbook Formulas

workbook.calculateFormula();

//Saving the Excel file

workbook.save("e:\\excels\\2v8w1MQqeg\\test.xls");

Thank You & Best Regards,

7

Hi,

We have tested our application with the latest version of Aspose.Cells which you have provided.

But still we are getting the same EmptyStackException erro. Please find the attached bug simulation dat file (retailSalesObjective-GEN-1235995870568.zip) for testing at your end.

Error Log:

[01 Mar 2009 12:47:32,223] [ TMS Users++RnNatAd ] [ERROR]-[ReportModelManager-loadWorksheet] - java.util.EmptyStackException
at java.util.Stack.peek(Stack.java:79)
at java.util.Stack.pop(Stack.java:61)
at com.aspose.cells.z.a(Unknown Source)
at com.aspose.cells.z.a(Unknown Source)
at com.aspose.cells.Cell.a(Unknown Source)
at com.aspose.cells.Cell.b(Unknown Source)
at com.aspose.cells.Cell.getR1C1Formula(Unknown Source)

Please provide the resultion for the above issues getting resolved.

Thanks & Regards,

Karuppiah M

8

Hi,

Thank you for considering Aspose.

We will look into your issue and get back to you soon.

Thank You & Best Regards,

9

Hi,

Thank you for considering Aspose.

Well, we are not really sure how we can reproduce your mentioned issue by using the provided .dat file. We will appreciate it a lot, if you can provide us some details about the .dat file and using this .dat file to reproduce your issue. This way it will be a lot easier for us to generate your issue and fix it.

Thank You & Best Regards,