Hello,
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
<snip>
recordid = 0x200, size =14
[DIMENSIONS]
.firstrow = 0
- .lastrow = 3
+ .lastrow = 4
.firstcol = 0
.lastcol = 1
.zero = 0
[/DIMENSIONS]
============================================
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?
Regards,
Andrea
> -----Original Message-----
> From: Avik Sengupta [mailto:[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
