though I am very certain this is the case, because now I see a 'formattingrecords' error at the top of the stack trace. If someone else can corroborate this so that I know I'm not crazy, I would appreciate it. even thinking about changing the format (opening the 'format cells' window and clicking around) of a cell will completely corrupt the workbook FOREVER. The worst part about this bug is that it is permanent. Evidently, it is having clicked one of the options in this window and pressed 'ok', even if it was the same format as before, which triggers the error. But if you open the window and then select ok without actually clicking on 'general', the error is not thrown. Actually, you do not even have to have changed the format- if you select only one cell and then go to the format cells window, click the 'general' format (which it already was by default), and hit ok and save the workbook again, the error is thrown. In JexcelAPI, if you try to copy a workbook more than once using the overloaded CreateWorkbook method, there is a bug that happens if you have ever tried to change the format of any cell in the original Workbook in the past.

Ok, so I have found out the issue that was causing this problem. I should also note that I don't see any particular significance to the outofbound indeces: I am do not have anything with dimension 54 in my workbook (rows, columns, or sheets), nor am I trying to replace anything with an array of length 62.Дoes any have any idea why this may have suddenly started happening? I have a feeling it has an embarrassingly easy answer but I can't figure it out, so any help would be greatly appreciated! I noticed that I can create both WritableWorkbooks at the same time, and I can even write() the second one (called 'writableWorkbook'), but for some reason when I try to write() the second one ('backup'), it throws the error. WritableWorkbook writableWorkbook = Workbook.createWorkbook(new WritableWorkbook backup = Workbook.createWorkbook(new File('BACKUP.xls'),workbook) Workbook workbook = Workbook.getWorkbook(new File ('NBSCOMBINED.xls'))

Public static void main(String args) throws IOException, BiffException, I have boiled down the problem to the following snippet of code: package musicpred The stack trace looks like this:Д®xception in thread 'main' : Index: 62, Size: 54ДЄt (ArrayList.java:604)ДЄt (ArrayList.java:382)ДЄt (FormattingRecords.java:338)ДЄt .getCellFormat(CellValue.java:144)ДЄt .(CellValue.java:129)ДЄt .(LabelRecord.java:116)ДЄt .shallowCopењњell(SheetCopier.java:808)ДЄt .shallowCopењњells(SheetCopier.java:934)ДЄt .copySheet(SheetCopier.java:219)ДЄt .copy(WritableSheetImpl.java:1584)ДЄt .copyWorkbook(WritableWorkbookImpl.java:971)ДЄt .(WritableWorkbookImpl.java:343)ДЄt (Workbook.java:339)ДЄt (Workbook.java:320)ДЄt (musicpreddebugtest.java:17) This has been working for a long time until recently I started getting an ArrayIndexOutOfBOunds exception. I need to make 2 copies of a Workbook object, one a WritableWorkbook for further manipulation, and one simply to copy from the original Workbook and then save it, so that in case anything happens to the original object and it's writable copy, I will have a backup. I am using JexcelAPI in java in order to manipulate excel files.

Java jxl methos