Hello Aspose team,
I have been using Aspose Java for a while & of late I have been getting a lot of errors like
"
java.lang.ArrayIndexOutOfBoundsException: 9
at com.aspose.cells.Q.e(Unknown Source)
at com.aspose.cells.dB.t(Unknown Source)
at com.aspose.cells.dB.a(Unknown Source)
at com.aspose.cells.bI.b(Unknown Source)
at com.aspose.cells.bI.a(Unknown Source)
at com.aspose.cells.bI.b(Unknown Source)
at com.aspose.cells.bI.a(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 TestExcel.main(TestExcel.java:71)"
Below is my sample code
Workbook workbook = new Workbook();
workbook.open("c:\\temp\\InputFile.xls");
Worksheet inputWorksheet = workbook.getWorksheets().getSheet(0);
System.out.println("ip file open");
Workbook dest = new Workbook();
dest.open("C:\\temp\\TemplateFile.xls",FileFormatType.DEFAULT);
Worksheet destWorksheet = dest.getWorksheets().getSheet(0);
destWorksheet.copy(inputWorksheet);
dest.calculateFormula(); // Fails here
dest.getWorksheets().setActiveSheet(1);
dest.save("C:\\temp\\dest.csv", FileFormatType.CSV);
I have attached the sample test & template file. Please advice.
Thanks