https://issues.apache.org/bugzilla/show_bug.cgi?id=47048
Josh Micich <[email protected]> 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 <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
