https://issues.apache.org/bugzilla/show_bug.cgi?id=47199


Josh Micich <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #7 from Josh Micich <[email protected]>  2009-05-21 12:51:13 PST 
---
The files you uploaded are incomplete.  It appears that the output of BiffView
has been truncated.  None of the sheet sub-streams are present, and even the
workbook stream is incomplete.  I can see 49 BOUNDSHEET records which implies
49 sheet sub-streams are missing.

I am pretty sure that BiffView will not silently quit in the middle of a file.
So either it crashed and you didn't mention that, or you have deliberately
truncated the output hoping that we only needed to consider the record order in
the first 5% of the workbook.  Perhaps you are concerned that even these BIFF
header summaries constitute information that you must keep private.  I can't
convince you otherwise, but at least let us know that's what you are thinking.


If you are not able to upload a complete BIFF summary, you could try single
stepping the code in a debugger:
 - First (since there are many sheets), find out which sheet the error occurs
on.  When the bug occurs, take at "this._sheets.size" 2 stack frames up
(HSSFWorkbook.java:288). 
 - Next re-run your app and progress over all the previous sheets and stop at
HSSFWorkbook.java:288 before reading the sheet with the problem.
 - Put a breakpoint on line Sheet.java:219, let the app execute to there.
 - Observe carefully how many and which records are read from the RecordStream
in the PageSettingsBlock constructor.
 - Let the app run to the Sheet.java:219 breakpoint again.  Pay attention to
which records (non-PSB) have been read from the RecordStream since creating the
PageSettingsBlock, and the current record (which seems to belong to the PSB)
 - Make sure that execution _immediately_ proceeds to the exception at
Sheet.java:236 (otherwise you haven't observed the exact conditions for the bug
yet)

When you find out specifically what POI is doing wrong (and what Excel is doing
'right'), please reply here so we can incorporate this knowledge back into POI.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to