https://bz.apache.org/bugzilla/show_bug.cgi?id=63998
Bug ID: 63998
Summary: AreaReference doesn't support sheetName with commas
and exclamation marks
Product: POI
Version: 4.1.x-dev
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Functions in this class are not aware of special characters such as exclamation
mark ! and comma , at all.
AreaReference.generateContiguous and AreaReference.isContiguous are implemented
naively in this sense, which is simply looking for commas as delimiters.
References like these are all valid, but they'll fail unit tests:
'A,Sheet'!$A$1:$A$1
'!and,Sheet'!$A$1:$A$1
The first one fails AreaReference.generateContiguous, and the second one also
fails AreaReference.isContiguous
Sheet name is quoted with single quotation marks (luckily enough, it seems
Excel doesn't allow escaping single quotation marks)
This bug exists in the latest trunk code
--
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]
