Bug 13461 - Excel 97 crashes when trying to open downloaded .xls
Summary: Excel 97 crashes when trying to open downloaded .xls
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5
Hardware: PC All
: P3 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-10-09 15:52 UTC by Kendall Coolidge
Modified: 2005-03-20 17:06 UTC (History)
0 users

Causes error in Excel 97 when opened (6.00 KB, application/vnd.ms-excel)
2002-10-09 15:59 UTC, Kendall Coolidge
Can open this in Excel 97 without error (13.50 KB, application/vnd.ms-excel)
2002-10-09 16:00 UTC, Kendall Coolidge

Note You need to log in before you can comment on or make changes to this bug.
Description Kendall Coolidge 2002-10-09 15:52:50 UTC
I am creating a workbook in a Struts action and streaming it to the browser 
using the following snippet:

// execute the ExcelQuery and write the results to the stream
	if (excelquery != null) {
	HSSFWorkbook wb = excelquery.getWorkbookSQL(user, messages);
	ServletOutputStream stream = response.getOutputStream();
	String fileName = selectedQuery + ".xls";
			"attachment; filename=\"" + fileName + "\"");
	return (null);

The user sees a File Download dialog that allows them to Open or Save the 
Excel file.  Either choice works GREAT in W2000/Office2000, XP/OfficeXP, but 
causes an Excel error in Win98/Excel97 SR-2.  The error says: EXCEL caused an 
invalid page fault in module EXCEL.EXE at 0177:300fa329.  If I take the 
offending xls to another computer, XP or 2000 can open the xls just fine.  I 
can save the xls back to the Win98 pc and open it normally in Excel97.  I will 
attach an example (when I figure out how) of an xls that I can't open and the 
same one after it has been opened/saved using Excel XP.

Any assistance would be greatly appreciated!  This is a critical project.

Thank you very much,
Comment 1 Kendall Coolidge 2002-10-09 15:59:33 UTC
Created attachment 3404 [details]
Causes error in Excel 97 when opened
Comment 2 Kendall Coolidge 2002-10-09 16:00:37 UTC
Created attachment 3405 [details]
Can open this in Excel 97 without error
Comment 3 Andy Oliver 2002-10-09 16:27:06 UTC
not only do I not see anything wrong with the file in BiffViewer
(org.apache.poi.hssf.dev.BiffViewer) but my copy of Excel97 opens it just fine.
 You should discuss this on the poi-user list perhaps someone else has
experienced a similar problem.