https://bz.apache.org/bugzilla/show_bug.cgi?id=59271
Bug ID: 59271
Summary: Regression: Formula parsing fails after update to poi
3.13 if formula contains spaces between closing
brackets
Product: POI
Version: 3.13-FINAL
Hardware: PC
Status: NEW
Severity: regression
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
The following formula works fine in poi 3.12 but does no longer work with poi
3.13 or 3.14
The error that we are getting with 3.13 is the following
Caused by: org.apache.poi.ss.formula.FormulaParseException: Parse error near
char 71 ')' in specified formula '(VLOOKUP("item1", A2:B3, 2, FALSE) -
VLOOKUP("item2", A2:B3, 2, FALSE) )'. Expected cell ref or constant literal
at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:208)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1148)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1103)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1090)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1450)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1570)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1554)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1511)
at
org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1499)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1472)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1131)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1103)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1090)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1450)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1570)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1554)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1511)
at
org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1492)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1472)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1612)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:153)
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:53)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:261)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:189)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCell(BaseXSSFFormulaEvaluator.java:117)
I've attached an excel file and a unit test to reproduce the bug. I guess that
this is the same issue as https://bz.apache.org/bugzilla/show_bug.cgi?id=58648
--
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]
