Bug 59684

Summary:	CellReference.separateRefParts(String reference) Fails to Parse Row References Correctly
Product:	POI	Reporter:	Sean Smitz <sean.smitz>
Component:	SS Common	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P2
Version:	3.14-FINAL
Target Milestone:	---
Hardware:	PC
OS:	Linux

Description Sean Smitz 2016-06-09 15:59:15 UTC

I have a sheet with a named range composed of a set of rows (HOME!$169:$454). When creating the AreaReference the following is passed to CellReference.separateRefParts(String reference="HOME!$169"). The CellRef is then set to the following values: _rowIndex = 169, _colIndex = -1, _sheetName = "HOME", _isRowAbs = false; _isColAbs = true; I believe _isRowAbs should be 'true' and _isColAbs should be 'false'. This happens because the '$' from reference gets parsed into parts.colRef instead of being parsed into parts.rowRef with the digits for the row number.

Comment 1 Javen O'Neal 2016-06-10 11:56:06 UTC

Thanks for reporting this bug and giving some hints on where the problem was. I wrote a unit test per comment 0 and fixed the behavior of CellReference(String) to be able to read entire-row reference strings.

Applied patch in r1747687 and changelog in r1747688. Will be fixed in POI 3.15 beta 2.