https://issues.apache.org/bugzilla/show_bug.cgi?id=45676
Summary: poi-3.5-beta1 XSSF event usermodel occasionally
truncates cell values
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: blocker
Priority: P1
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
When parsing large excel files using XSSF and the event usermodel, when the
needed data referred to by start and length variables refer to the end of ch[],
only part of the cell value is returned. This will either give an incorrect
numeric value of a cell, or refer an incorrect position in the sharedStrings
file.
This can be verified by using the poi.xssf.eventusermodel.examples to parse a
very large sheet (several thousand rows with a couple dozen columns). Put a
conditional breakpoint on the value of the variable start when start + length
is 2048 in the method "public void characters(char[] ch, int start, int length)
throws SAXException". This will eventually give you a value that is truncated.
The value of ch needs to go to 2048 characters, then back up to the last
complete set of cell data rather than always cutting at exactly 2048 characters
and possibly truncating cell data being referred to.
This is a showstopper because the results of using the XSSF eventusermodel can
not be trusted when parsing large excel files.
Thanks.
Paul Dobson
--
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]
