https://bz.apache.org/bugzilla/show_bug.cgi?id=60235
Bug ID: 60235
Summary: Intersection arguments to worksheet function in
FormulaEvaluator
Product: POI
Version: 3.15-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: as...@pnash.me.uk
XSSF sheet with worksheet function whose arguments are overlapping intersecting
ranges, for example =SUM(B3:C3 C3:C4), generates a FormulaParseException from
the following code (stack trace below).
FileInputStream fileIn = new FileInputStream(new File("intersect.xlsx"));
Workbook wb = WorkbookFactory.create(fileIn);
fileIn.close();
FormulaEvaluator eval = wb.getCreationHelper().createFormulaEvaluator();
eval.evaluateAll();
Speculation: A Possible Fix: In FormulaParser, in Arguments() method, replace
call to temp.add(comparisonExpression()); with
temp.add(intersectionExpression()); instead. This appears to fix it for me!
-------------------------------------------------------
Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException:
Parse error near char 10 'C' in specified formula 'SUM(B3:C3 C3:C4)'. Expected
',' or ')'
at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:262)
at
org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1444)
at
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1316)
at
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:884)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:575)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:311)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1509)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1467)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1454)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1827)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1955)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1939)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1896)
at
org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1869)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1849)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1997)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170)
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:85)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:315)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:259)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65)
at
org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(BaseFormulaEvaluator.java:193)
at
org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:268)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAll(XSSFFormulaEvaluator.java:92)
at poi.POIDemo.main(POIDemo.java:20)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
