Bug 59684

Summary: CellReference.separateRefParts(String reference) Fails to Parse Row References Correctly
Product: POI Reporter: Sean Smitz <sean.smitz>
Component: SS CommonAssignee: POI Developers List <dev>
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.