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/07/03 13:19:50 UTC

DO NOT REPLY [Bug 21305] New: - Excel crashing when reading large files generated by POI

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=21305>.
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=21305

Excel crashing when reading large files generated by POI

           Summary: Excel crashing when reading large files generated by POI
           Product: POI
           Version: 1.5.1
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: JulianJones2000@yahoo.co.uk


Our server-side application uses POI 1.5.1 to generate Excel files, 
which are then streamed over HTTP to the browser. Generally this process
works fine, but some streamed files cause Excel to crash. The crash does
not appear to be version-specific (we see the same results in Excel 97 and
Excel XP). The Excel document generated always has 2 worksheets. We see
the crash typically when there are > 300 rows and > 150 columns in one of
the worksheets. I have read bug reports that Excel will crash if > 256
columns are used, but this is not the case for our worksheets.
All our cell values are written as Strings. We don't use formulas or any other
of the more sophisticated Excel facilities.
I will attach an example file that exhibits this problem.