https://issues.apache.org/bugzilla/show_bug.cgi?id=53314
Priority: P2
Bug ID: 53314
Assignee: [email protected]
Summary: Invalid Formula Cell Reference for named ranges
referring to whole columns
Severity: critical
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
Created attachment 28847
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28847&action=edit
Sample workbook with whole column named range
Where a workbook has a whole column cell reference (EG Sheet1!$A:$A) then
creating an area reference will fail with the message "Invalid Formula cell
reference: 'Sheet1!$A'"
The following code will fail for the sample attached:
FileInputStream fis = new
FileInputStream(sampleSpreadsheet2.getFile().getAbsolutePath());
XSSFWorkbook wb = new XSSFWorkbook(fis);
int namedCellIdx = wb.getNameIndex("MyColumn");
Name aNamedRange = wb.getNameAt(namedCellIdx);
AreaReference aref = new
AreaReference(aNamedRange.getRefersToFormula());
--
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]
