https://issues.apache.org/bugzilla/show_bug.cgi?id=49457
Summary: Exception while parsing SUM formula
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Exception fails when we try to write HSSF workbook:
"org.apache.poi.ss.formula.FormulaParseException: Parse error near char 7 ';'
in specified formula 'SUM(D19;D23)'. Expected ',' or ')'". When I made proposed
change and replaced 'SUM(D19;D23)' with 'SUM(D19,D23)' exception disappeared.
However, 'SUM(D19;D23)' is valid formula in Excel and 'SUM(D19,D23)' is not.
Complete stacktrace is here:
org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:217)
org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1049)
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:929)
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:551)
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:423)
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1112)
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1072)
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1059)
org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1410)
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1510)
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1494)
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1451)
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1431)
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1552)
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174)
org.apache.poi.hssf.model.HSSFFormulaParser.parse(HSSFFormulaParser.java:72)
org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:588)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
