poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45354] Complex formula calcuation does not support named cells
Date Tue, 08 Jul 2008 21:20:20 GMT

Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Josh Micich <josh@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

View raw message