https://issues.apache.org/bugzilla/show_bug.cgi?id=53314
--- Comment #5 from Pete Maher <[email protected]> --- That's great Mark, thanks. Whole rows also have problems although not the same exception at the same point: XSSFWorkbook wb = new XSSFWorkbook(fis); int namedCellIdx = wb.getNameIndex("MyRow"); //EG Sheet1!$5:$5 Name aNamedRange = wb.getNameAt(namedCellIdx); String refersToFormula = aNamedRange.getRefersToFormula(); //Correct value returned AreaReference aref = new AreaReference(refersToFormula); //At this point aref.isSingleCell() == true, no matter how many cells on MyRow are populated //And first cell and last cell both have a formatAsString() value of "Sheet1!$5" I can raise a second bug for this if you think it is a separate issue, let me know. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
