poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrea Nenni" <Andrea.Ne...@methodpark.de>
Subject RE: Opening HSSFSheets in MS Project - Is it a bug?
Date Tue, 27 Jan 2004 07:38:13 GMT

I dumped some of my Excel files with the org.apache.poi.hssf.dev.BiffViewer:

- "poi.dump" (from the Excel sheet created by HSSF)
- "excel.dump" ("poi.dump" opened and saved with MS Excel 2002)
- "openo.dump" ("poi.dump" opened and saved with Open Office 1.1.0)

This is what I see, when I compare the files with UNIX diff (-u):

--- poi.dump	2004-01-26 13:21:14.000000000 +0100
+++ excel.dump	2004-01-26 13:49:14.000000000 +0100


 recordid = 0x200, size =14
     .firstrow       = 0
-    .lastrow        = 3
+    .lastrow        = 4
     .firstcol       = 0
     .lastcol        = 1
     .zero           = 0

I get the same result when comparing "poi.dump" to "openo.dump".

My generated sheet has 4 rows. HSSF writes a "lastrow" entry of 3. 
MS Excel and Open Office both change the "lastrow" entry to 4 which
makes them readable for MS Project. 

I also had a look into the BiffViewer dump of a POI generated Excel
sheet with 5 rows. It has a "lastrow" entry of 5 (!). 

This looks like a bug to me which might cause the problems in opening
the file with MS Project.

Any ideas or comments?

Can anyone tell me, if there is an easy way to change the "lastrow" entry
in an Excel file? Is there a way to do it with HSSF?


> -----Original Message-----
> From: Avik Sengupta [mailto:avik.sengupta@itellix.com] 
> Sent: Saturday, January 24, 2004 11:26 AM
> You'll probably need to test this with a hand crafted excel file, to
> find out if this is POI issue or an MS project issue. 

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

View raw message