DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16362>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16362 Can't open xls file if number of merged regions exceeds certain limit Summary: Can't open xls file if number of merged regions exceeds certain limit Product: POI Version: 1.5.1 Platform: PC OS/Version: Windows XP Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'm trying to construct an xls file with plenty of merged cells, about 5 separate groups of merged cells per row. This works fine until the number of rows exceeds about 1000. When I try to open the file in MS-Excel 2000, I get a message saying: " Unable to open file", and then refuses to open the file. Has anybody out there experienced anything similar, and possibly found a solution? I'm using the latest release version of POI, in jakarta-poi-1.5.1-final- 20020615.jar. To add the merged cells, I'm creating a new org.apache.poi.hssf.util.Region object and adding that to the HSSFSheet instance using the addMergedRegion method, eg Region region = new Region(rowNum, colFrom, rowNum, colTo); m_Sheet.addMergedRegion(region); JDK version: j2sdk1.4.1_01 OS: Windows XP 5.1, build 2600.xpsp 1.020828-1920: service pack 1. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
