DO NOT REPLY [Bug 20871] - [RFE] Lie to excel. version issue while saving/updating an excel 2002 file

[bu...@apache.org]

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

[RFE] Lie to excel.  version issue while saving/updating an excel 2002 file





------- Additional Comments From zalewski@optonline.net  2003-08-07 00:18 -------
FWIW: This does not seem to happen in all cases. I tried running 
org.apache.poi.hssf.usermodel.examples.CreateCells (which produces a simple 
workbook.xls). I could open the output file in both 2000 and XP (SR-1) without 
seeing this problem.

However, I did notice that POI/HSSF does not put the 'Storage Class ID' into 
the .xls file when it creates a new workbook from scratch. I thought this might 
be the cause of the problem, but upon further investigation I discovered that 
the class ID {00020820-0000-0000-C000-000000000046} is put for all versions of 
Excel. HSSF just puts in all zeros.

Also, there is a BOF record in the workbook, which has a field 
named 'rversion'. Excel 97 and Excel 2000 put 06100000. Excel XP puts 06200000. 
HSSF puts 06100000 (same as Excel 97). But that does not seem to make a 
difference when Excel XP opens the file.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/