Aspose generate .xlsx file could not be opened again with Aspose

Aspose.Cells Product Family
1

Hi ,

I have generated the .xlsx file with Aspose Cells Java. This workbook contains a lot of worksheets and many pivots and charts.
Issues are listed below:

  1. Charts and Pivot are not getting updated.
  2. PivotTable.refreshData() throwing an exception

Lastly the generate output couldn’t be loaded again with Aspose - giving below exception.
java.lang.ArrayIndexOutOfBoundsException: 4
at com.aspose.cells.zaoz.a(Unknown Source)
at com.aspose.cells.zaoz.j(Unknown Source)
at com.aspose.cells.zaoz.a(Unknown Source)
at com.aspose.cells.zcqx.b(Unknown Source)
at com.aspose.cells.zd.f(Unknown Source)
at com.aspose.cells.zd.r(Unknown Source)
at com.aspose.cells.zd.a(Unknown Source)
at com.aspose.cells.zapt.a(Unknown Source)
at com.aspose.cells.zjq.a(Unknown Source)
at com.aspose.cells.zjq.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at com.ibm.pmo.projects.amerisource.TestPivot1.main(TestPivot1.java:22)
Thanks
AnirbanResponse_output.zip (255.4 KB)
Response_output.zip (255 KB)

2

@Anirban_Roy,

It looks like you are using some older version of the product, so kindly try using our latest version/fix (Aspose.Cells for Java v21.3) for your scenario/case. If you still find any issue with latest version, kindly do create a sample Java program (runnable) to create such corrupted file and share it with us with other template (input) files(if any) to reproduce the issue(s) on our end, we will check it soon.