Bug 60981

Summary: FormulaParser does not parse ranges with #REF! errors
Product: POI Reporter: Efthimia <e.aivaloglou>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.15-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: File from Euses spreadsheets corpus

Description Efthimia 2017-04-13 12:15:36 UTC
Created attachment 34910 [details]
File from Euses spreadsheets corpus

When attempting to parse Excel formula SUM(#REF!:#REF!) with apache.poi.ss.formula.FormulaParser.parse, it throws exception:

org.apache.poi.ss.formula.FormulaParseException: Parse error near char 9 ':' in specified formula 'SUM(#REF!:#REF!)'. Expected ',' or ')'

A real-world example taken from the Euses spreadsheet corpus is formula


in the attatched EC101Grades.xls::Gradebook!AC43