Bug 44581

Summary: xssf.helpers.ColumnHelper bug/issue with long ranges
Product: POI Reporter: Paolo Mottadelli <paolo.moz>
Component: POI OverallAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal Keywords: PatchAvailable
Priority: P2    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: Patch that fixes the bug and adds XSSF style related stuff

Description Paolo Mottadelli 2008-03-11 09:19:21 UTC
Created attachment 21652 [details]
Patch that fixes the bug and adds XSSF style related stuff

cleanColumns() of xssf.helpers.ColumnHelper seems to have a slight bug in it. If you pass in a column definition for a long range, it'll take several minutes to run!
Try running the test org.apache.poi.xssf.extractor.TestXSSFExcelExtractor
One of the files that uses has a column definition for something like columns 14 to 16384 in it. cleanColumns() will still be trying to process it after about 5 minutes!
Comment 1 Nick Burch 2008-03-13 04:51:37 UTC
Thanks for this Paolo, committed to svn