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 2009/05/16 00:56:13 UTC
DO NOT REPLY [Bug 47048] HSSF is unable to evaulate named ranges
with the 'complex' flag set
https://issues.apache.org/bugzilla/show_bug.cgi?id=47048
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
Summary|HSSF is unable to evaulate |HSSF is unable to evaulate
|the formula SUM(namedRange) |named ranges with the
| |'complex' flag set
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2009-05-15 15:56:11 PST ---
Fixed in svn r775376 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=775376 ).
junits added
In your sample workbook, the defined name "Is_Multicar_Vehicle" is marked as
'complex' even though it is just an area ref.
Currently POI only evaluates defined names which are simple cell or area
references. Until now (according to existing test samples) it was assumed that
these would not be flagged as complex. It is not clear what the 'complex' flag
is used for.
BTW - there was another bug in POI's implementation of INDEX() that would
prevent your example code from completing. This has been fixed in svn r775360 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=775360 ).
POI now produces the correct result: 1.0
--
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