Bug 55723 - Inconsistent behavior in setautofilter function
Summary: Inconsistent behavior in setautofilter function
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2013-10-30 06:55 UTC by uogra
Modified: 2014-01-01 22:27 UTC (History)
0 users


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