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:
- Charts and Pivot are not getting updated.
- 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)