https://issues.apache.org/bugzilla/show_bug.cgi?id=50440
Summary: Newline characters in all formulas results in
FormulaParseException
Product: POI
Version: 3.7
Platform: Macintosh
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
The following snippet of code will fail:
FormulaEvaluator evaluator =
workbook.getCreationHelper().createFormulaEvaluator();
evaluator.evaluate(source)
workbook is of type org.apache.poi.ss.usermodel.Workbook
source is of type org.apache.poi.ss.usermodel.Cell with the following formula:
=SUM(1+
2)
Here's the exception:
Caught: org.apache.poi.ss.formula.FormulaParseException: Parse error near char
6 '
' in specified formula 'SUM(1+
2)'. Expected cell ref or constant literal
--
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]