Bug 50672

Summary: AutoFilter
Product: POI Reporter: smharding1
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description smharding1 2011-01-27 09:55:25 UTC 
setAutoFilter creates a bloated HSSF Excel 97 file (~130kb without AutoFilter to ~830kb applying setAutoFilter to a worksheet with 22 columns and 288 rows).  The resulting workbook displays the AutoFilter correctly, but the menu option Data->Filter->AutoFilter does not turn the AutoFilter off.  The "same" code creates am XSSF workbook without bloat, and the AutoFilter behaves properly (On/Off) when the workbook is opened in Microsoft Excel.
Comment 1 smharding1 2011-01-27 10:03:12 UTC 
Despite being able to consistently reproduce this issue previously, I am now unable to do so.  setAutoFilter is now behaving for me with both HSSF and XSSF.