Bug 55723

Summary: Inconsistent behavior in setautofilter function
Product: POI Reporter: uogra
Component: HSSFAssignee: POI Developers List <dev>
Severity: major    
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description uogra 2013-10-30 06:55:09 UTC
Calling XSSFSheet.setAutofilter(CellRangeAddress.valueOf("A:D")) does not throw any exception and applies the autofilter on sheet for these columns but

Calling HSSFSheet.setAutofilter(CellRangeAddress.valueOf("A:D")) THROWS THIS EXCEPTION :
"row1 must be between 0 and 65280"

Why this inconsistent behavior?
Comment 1 Dominik Stadler 2014-01-01 22:27:31 UTC
Fix in r1554688, HSSF now also accepts column-only-ranges, also the XSSF side was fixed to allow to change the autofilter via a second call to setAutoFilter().