Bug 60980

Summary: FormulaParser does not parse intersections of named ranges
Product: POI Reporter: Efthimia <e.aivaloglou>
Component: SS CommonAssignee: POI Developers List <dev>
Severity: normal CC: asfbz
Priority: P2    
Version: 3.15-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Efthimia 2017-04-13 11:56:39 UTC
When attempting to parse valid Excel formula SUM(fenia fenia3) with apache.poi.ss.formula.FormulaParser.parse, it throws exception:

org.apache.poi.ss.formula.FormulaParseException: Parse error near char 10 'f' in specified formula 'SUM(fenia fenia3)'. Expected ',' or ')'

fenia and fenia3 in the formula are defined named ranges
Comment 1 Yegor Kozlov 2019-02-21 17:10:29 UTC
Fixed in r1854037, junit added.

Comment 2 Yegor Kozlov 2019-02-24 12:56:25 UTC
*** Bug 60235 has been marked as a duplicate of this bug. ***