You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2003/01/23 15:09:44 UTC
DO NOT REPLY [Bug 16362] New: -
Can't open xls file if number of merged regions exceeds certain limit
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: poi-dev@jakarta.apache.org
ReportedBy: pdavidson@emery-waterhouse.com
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.