Bug 41567

Summary: No more than 8 ActiveX Controls per Workbook
Product: POI Reporter: Markus Wiesen <wiesen>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: critical    
Priority: P2    
Version: 2.5-FINAL   
Target Milestone: ---   
Hardware: Other   
OS: other   
Attachments: 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
Comment 6 Markus Wiesen 2007-02-08 22:22:54 UTC
Created attachment 19555 [details]
Broken copy created by HSSF