Bug 41567 - No more than 8 ActiveX Controls per Workbook
Summary: No more than 8 ActiveX Controls per Workbook
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: Other other
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-08 05:16 UTC by Markus Wiesen
Modified: 2007-05-23 03:10 UTC (History)
0 users



Attachments
Original working excel sheet (28.50 KB, application/vnd.ms-excel)
2007-02-08 22:21 UTC, Markus Wiesen
Details
Original not working excel sheet (31.50 KB, application/vnd.ms-excel)
2007-02-08 22:21 UTC, Markus Wiesen
Details
Working copy created by HSSF (28.50 KB, application/vnd.ms-excel)
2007-02-08 22:22 UTC, Markus Wiesen
Details
Broken copy created by HSSF (28.50 KB, application/vnd.ms-excel)
2007-02-08 22:22 UTC, Markus Wiesen
Details

Note You need to log in before you can comment on or make changes to this bug.
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