Exception when copying sheets between workbooks

Aspose.Cells Product Family
1

I am using the latest version of Cells for java 1.7.5.0. I have a requirement to merge several excel files into one. I am using the copy method.

mynewsheet = sheets.addSheet();

mynewsheet.copy(sheet);

All seems to be working fine until I do a save. When I save I receive the following exception:

java.lang.IndexOutOfBoundsException: Index: 17, Size: 17

at java.util.ArrayList.RangeCheck(ArrayList.java:507)

at java.util.ArrayList.get(ArrayList.java:324)

at com.aspose.cells.s.c(Unknown Source)

at com.aspose.cells.s.x(Unknown Source)

at com.aspose.cells.s.(Unknown Source)

at com.aspose.cells.Workbook.save(Unknown Source)

at com.aspose.cells.Workbook.save(Unknown Source)

at com.metatomix.cm.output.excel.Xml2ExcelUtil.mergeExcelFiles(Xml2ExcelUtil.java:169)

Note sometimes this works. So I did some testing and have found that if there are font styles applied to the cell it can cause the problem but haven't been able to narrow it down any further. Please let me know if there is any additional information I can provide to resolve this issue.

Jim

2

Hi,

Please try this fix in <A href="</A>.</P>

3

Thanks. It works.

Jim