You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/07/08 23:20:20 UTC
DO NOT REPLY [Bug 45354] Complex formula calcuation does not support
named cells
https://issues.apache.org/bugzilla/show_bug.cgi?id=45354
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org