https://issues.apache.org/bugzilla/show_bug.cgi?id=45354
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Josh Micich <[EMAIL PROTECTED]> 2008-07-08 14:20:19 PST ---
Fixed in svn r674953
Excel allows named ranges to have names which look like cell references. They
seem to be distinguished only by the allowable values for row and column. For
instance, "FY2008" is definitely a cell reference and cannot be a named range.
"A70123" definitely not a cell reference and might be a named range.
POI was interpreting 'pfy1' as a cell reference (also incorrectly calculating
the column index to be 1012 - it would really be 10997). The fixed code now
checks the apparent column ('pfy') and row ('1') for maximum BIFF8 range ('IV'
and '65536') to decide whether to treat the identifier as a named range.
There are all sorts of complexities related to this issue. For example dots
are legal in named range names, but also may be used instead of the colon range
operator. In BIFF12 (Excel 2007) the sheet boundaries change, so 'pfy1'
becomes a valid cell reference, and presumably an invalid named range name.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
