Bug 55723

Summary:	Inconsistent behavior in setautofilter function
Product:	POI	Reporter:	uogra
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
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().