Bug 27497

Summary: Charts not working
Product: POI Reporter: Eric DeFazio <mdefazio>
Component: POI OverallAssignee: POI Developers List <dev>
Severity: major    
Priority: P3    
Version: 2.0-FINAL   
Target Milestone: ---   
Hardware: All   
OS: other   
Bug Depends on:    
Bug Blocks: 28203    
Attachments: java example
excel example
First example was wrong, sorry

Description Eric DeFazio 2004-03-06 19:47:20 UTC
I have recently updated to the POI 2.5-final realease of POI from the 2.0 
Final, and when I dynamically populate data which feeds into charts, the Excel 
File becomes corrupt.

I switched back to 2.0-final and everything worked fine.

Basically to repeat this bug:

1) create an Excel Worksheet with a chart (by selecting the data) in Excel
2) through POI, open the worksheet and change the data which feeds the chart
3) open the modified Excel Document in Excel, and the (File Corrupt) error 
message occurs

... wish I had more details about this... seems to be something with the 2.5 
final release, (Maybe dealing with the Escher format code or something) 
everything works great when I use the 2.0 jars.
Comment 1 Daniel Shaw 2004-03-23 17:02:45 UTC
Having the exact same problem (even without modifying the sheet)..

When I use POIFSFileSystem.writeFileSystem(OutputStream), I can transmit the 
whole document.

but when I use HSSFWorkbook.write(OutputStream) the file becomes corrupted.

Attaching my code and the excel example.
Comment 2 Daniel Shaw 2004-03-23 17:04:50 UTC
Created attachment 10925 [details]
java example
Comment 3 Daniel Shaw 2004-03-23 17:05:31 UTC
Created attachment 10926 [details]
excel example
Comment 4 Daniel Shaw 2004-03-23 17:06:56 UTC
Created attachment 10927 [details]
First example was wrong, sorry
Comment 5 jon batcheller 2004-04-20 20:31:42 UTC
Reverting to 2.0-RC2 it works OK
Comment 6 Glen Stampoultzis 2004-06-27 11:24:30 UTC
Resolved by applying patch in 28203 from Michael.