poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45707] Error While opening Excel file written by POI
Date Thu, 28 Aug 2008 17:37:47 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45707





--- Comment #2 from Josh Micich <josh@gildedtree.com>  2008-08-28 10:37:46 PST ---
The supplied POI generated file + Case-2 causes my Excel(2007) to completely
crash.
Re-saving Test-Main.xls in Excel (even without changes) makes the problem go
away. 

I couldn't reproduce the problem using latest svn trunk. So it looks like the
bug was fixed (probably some time ago).

I tried regenerating a similar file (plain number cells, plain text cells). 
Here is the code I used:

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
sheet.createRow(0).createCell(1).setCellValue(123.456);
sheet.createRow(1).createCell(1).setCellValue(new
HSSFRichTextString("abc.def"));
OutputStream os= new FileOutputStream("c:/temp/ex45707-linkDest.xls");
wb.write(os);
os.close();

After similar steps to Case-2 (linking to a text cell), the child spreadsheet
had this formula:
='C:\temp\[ex45707-linkDest.xls]Sheet1'!$B$2

Re-opening the child (after closing all) does not cause a crash like it did
before.  I ran through a few other variations of these use cases just to make
sure there were no other problems.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message