Bug 60979 - FormulaParser does not parse named ranges in parentheses
Summary: FormulaParser does not parse named ranges in parentheses
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.15-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-13 11:50 UTC by Efthimia
Modified: 2017-06-16 20:20 UTC (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Efthimia 2017-04-13 11:50:14 UTC
When attempting to parse valid Excel formula SUM(fenia:(fenia2)) with apache.poi.ss.formula.FormulaParser.parse it throws exception:

org.apache.poi.ss.formula.FormulaParseException: Parse error near char 10 '(' in specified formula 'SUM(fenia:(fenia2))'. Expected number, string, defined name, or data table

fenia and fenia2 in the formula are defined named ranges.