Bug 50672 - AutoFilter
Summary: AutoFilter
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2011-01-27 09:55 UTC by smharding1
Modified: 2011-01-27 10:03 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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.