poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53314] Invalid Formula Cell Reference for named ranges referring to whole columns
Date Wed, 30 May 2012 10:11:28 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53314

--- Comment #5 from Pete Maher <peter.maher@poz.co.im> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message