Bug 35849 - HSSF hangs whilst reading file
Summary: HSSF hangs whilst reading file
Status: RESOLVED DUPLICATE of bug 33681
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-07-25 14:52 UTC by Dave S-B
Modified: 2005-07-25 11:32 UTC (History)
0 users



Attachments
Test Excel file (381.50 KB, application/vnd.ms-excel)
2005-07-25 14:56 UTC, Dave S-B
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dave S-B 2005-07-25 14:52:53 UTC
When reading the attached excel file (also available at
http://www.lledr-solutions.co.uk/downloads/test.xls) HSSF hangs. There is no
error, the application just gets stuck in a loop somewhere (this is tested using
EFHSSF). The file is quite small and only contains numeric/string fields and can
be opened and viewed in MS Excel and OpenOffice. I can't track down the problem
with this file (other files are working fine).
Comment 1 Dave S-B 2005-07-25 14:56:01 UTC
Created attachment 15764 [details]
Test Excel file
Comment 2 Amol Deshmukh 2005-07-25 18:23:52 UTC
Apparently, a string table related issue.
The sheet has several columns containing mostly same data (~2000 rows and 4 such
columns). With the current hack in SSTDeserializer.addToStringTable(..) we
create new string for each repeated value (actually several new strings since we
iteratively add spaces).

This is a duplicate of 33681 (at least the cause is the same). 

Found this discussion about the fix:
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05915.html

If there is a patch already, I can test it.

*** This bug has been marked as a duplicate of 33681 ***
Comment 3 Amol Deshmukh 2005-07-25 18:40:45 UTC
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05915.html is
probably fix for a different issue. So looks like we never had a fix for the
multiple string creation.
Comment 4 Avik Sengupta 2005-07-25 19:32:01 UTC
 (In reply to comment #3)
> http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05915.html is
> probably fix for a different issue. So looks like we never had a fix for the
> multiple string creation.

Yeah, that's a different one.