|Summary:||No more than 8 ActiveX Controls per Workbook|
|Product:||POI||Reporter:||Markus Wiesen <wiesen>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Original working excel sheet
Original not working excel sheet
Working copy created by HSSF
Broken copy created by HSSF
Description Markus Wiesen 2007-02-08 05:16:13 UTC
It is not possibleto have more than 10 ActiveX controls per workbook, otherwise HSSF creates broken excel document. Message "Unable to open file"
Comment 1 Andy Oliver 2007-02-08 07:59:56 UTC
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?
Comment 2 Markus Wiesen 2007-02-08 22:20:22 UTC
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.
Comment 3 Markus Wiesen 2007-02-08 22:21:05 UTC
Created attachment 19552 [details] Original working excel sheet
Comment 4 Markus Wiesen 2007-02-08 22:21:53 UTC
Created attachment 19553 [details] Original not working excel sheet
Comment 5 Markus Wiesen 2007-02-08 22:22:26 UTC
Created attachment 19554 [details] Working copy created by HSSF