It is not possibleto have more than 10 ActiveX controls per workbook, otherwise HSSF creates broken excel document. Message "Unable to open file"
This bug report doesn't not contain an adequate description of the problem. For instance how did active x controls get in the file? Sample? Code used to generate it?
Ok now a more detailed description. I created a new Excel workbook with say 3 sheets. Then i added on each sheet 4 buttons (Not the form buttons, the ActiveX ones). I read the file and wrote it back again. HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream("excel.xls"); workbook.write(new FileOutputStream("another.xls"); If i try to open the another.xls, Excel tells me "Unable to read the file". This happens until there are no more than 8 buttons left. I tried it again and found out there must not be more than 8 not 10 buttons.
Created attachment 19552 [details] Original working excel sheet
Created attachment 19553 [details] Original not working excel sheet
Created attachment 19554 [details] Working copy created by HSSF
Created attachment 19555 [details] Broken copy created by HSSF