Bug 60981 - FormulaParser does not parse ranges with #REF! errors
Summary: FormulaParser does not parse ranges with #REF! errors
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 12:15 UTC by Efthimia
Modified: 2017-06-16 20:20 UTC (History)
0 users



Attachments
File from Euses spreadsheets corpus (56.00 KB, application/vnd.ms-excel)
2017-04-13 12:15 UTC, Efthimia
Details

Note You need to log in before you can comment on or make changes to this bug.
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

SUM(AC12:AC15,AC17:AC20,AC22:AC24,AC26:AC29,AC33,AC35:AC40,#REF!),AVERAGE(AC15,AC17:AC20,AC22:AC24,AC26:AC29,AC33,AC35:AC40,#REF!:#REF!),"") 

in the attatched EC101Grades.xls::Gradebook!AC43