Hello,
After patching POI 3.2, i got it to properly clone/remove sheets from
workbooks ( i'll transmit the patch asap, should also solve bug #17475,
#18149, #29619 and #40829)
BUT, even if the xls file is properly opened in excel 2003, 2007 and
openoffice, excel 2000 won't open it, it doesnt even complains or crahs,
it just does nothing.
When i open this xls file in excel 2007 than save it thanks to excel
2007, then excel 2000 opens it with no problem.
I tried to compare this "repared" version with the version comming from
POI, the only differances i can see thanks to BiffViewer is that the
NAME records order is shuffled but they are the same, and excel put
multiple POI-generated BLANKs records into MULBLANKs.
So i guess the problem goes beyond that : there are some troubles with
things that BiffViewer doesnt report.
A bin-diff on the files yields way too many differances.
Something i might point out also, i tried with jxl (an other Java xls
lib) it produces files with a bit more garbadge but it is interesting to
note that it seem to have the same problem.
Any idea about how i may look into this problem? an other
BiffViewer-like? any tools to do an in-depth inspection of xls files?
Regards
Gilles
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
