https://bz.apache.org/bugzilla/show_bug.cgi?id=60981
Bug ID: 60981
Summary: FormulaParser does not parse ranges with #REF! errors
Product: POI
Version: 3.15-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 34910
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34910&action=edit
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
--
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]
