|Summary:||HSSF hangs whilst reading file|
|Product:||POI||Reporter:||Dave S-B <dave>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||Test Excel file|
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 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://email@example.com/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://firstname.lastname@example.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://email@example.com/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.