Nick,
After careful examination of the problem in preparation for submitting
the bug report I have found out two things. The first is that I
cannot count. The second is that my inability to count makes the
problem even worse.
First of all, you are correct in that Excel limits titles to 256
characters. The problem is that POI 3.1 fails to read in excel files
containing charts that have titles with more than 127 characters. I
have filed this as a bug report (#45784).
RecordInputStream.readUnicodeLEString throws an
IllegalArgumentException: Illegal length - asked for -16 but only 130
left. It looks like an issue of using a Java byte to describe and
unsigned 8 bit number.
Laird
On 10-Sep-08, at 11:43 AM, Nick Burch wrote:
On Tue, 9 Sep 2008, [EMAIL PROTECTED] wrote:
SeriesTextRecords have a byte text length field that limits the
title text length to 256 characters. I presume that this is why
3.1 fails to read in files containing charts with long titles
whereas the data length of the UnknownRecord is not limited and
3.0.2 had no problems.
POI 3.1 has a little bit more low level charting support.
Page 398 points at page 850 of the excel spec, which clearly states
that the SeriesTextRecord is made up of a single byte length, some
flags, and then the text.
Since excel allows for chart titles longer than 256 characters, I
would presume the 256 character limit imposed by the
SeriesTextRecord is a bug. Is this the case? Is there a work
around for this problem?
Can you open a new bug in bugzilla, and upload a file that has a
longer title than 256 bytes? That way we can see what microsoft do
to get around their rather silly restriction of only using 1 byte
for the length
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
